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



Reply via email to