Hi all,
I have an excel sheet with an OLEObject
Forms.CheckBox.1.
With visual basic I can read it with following code:
For Each SFB In ActiveSheet.OLEObjects
If TypeName(SFB.Object) = "Checkbox" Then
Result = SFB.Object:Value
End If
Next SFB
How can I read the entry.checked of this checkbox?
List objects = wb.getAllEmbeddedObjects();
System.out.println(objects.size()); // object
size is 1
((HSSFObjectData)
objects.get(0)).getDirectory(); // this throws an exception
If I call getDirectory() this throws an exception.
java.io.FileNotFoundException: no such entry: "MBD00000000"
at
org.apache.poi.poifs.filesystem.DirectoryNode.getEntry(DirectoryNode.jav
a:247)
at
org.apache.poi.hssf.usermodel.HSSFObjectData.getDirectory(HSSFObjectData
.java:76)
Dump of the object returns:
[ftPictFmla]
.streamIdOffset = 0x0020 (32 )
.unknown = 0x[264C, 01A0, F802, 2321, 0301, ] (5 )
.unicodeLen = 0x0010 (16 )
.unicodeFlag = 0x0 (false )
.oleClassname = Forms.CheckBox.1
.streamId = 0x00000000 (0 )
[/ftPictFmla]
Thanks.
Gazanfer