I have a collection of Excel workbooks that I need to get the count of embedded OLE objects from. These are documents I have created for the purposes of testing. Using the Excel object model, the return value for worksheet.OleObjects.Count returns the correct number. Using Aspose.Cells, the return value for Sheet.OleObjects.Count is always 0.
My code: (assume a valid Cells.Workbook in ExcelDoc)
Dim Sheet As Cells.Worksheet
Dim I As Integer = 0
For Each Sheet In ExcelDoc.Worksheets
I += Sheet.OleObjects.Count
I have attached one of the documents I'm working with for reference.
Am I doing something wrong?