Attached is a simple test workbook in XLS format that has a single worksheet with a single OleObject on it. If I remove the OleObject via Aspose, errors occur when the resulting workbook is opened in Excel. If you let Excel do error recovery, then the resulting document also still has the OleObject in it. Is there something else that needs to be done to remove OleObjects from XLS files? The same problem does not occur with XLSX files, or if I open an XLS, remove the object, and then save as an XLSX - it only happens when .
Here's some sample code that'll work with the attached file:
Dim Workbook = New Aspose.Cells.Workbook(SourceFile)
Workbook.Worksheets(0).OleObjects.Clear()
Workbook.Save(DestFile)
My tests were done using Aspose.Cells for .NET v7.5.2.1.
Thanks for any help on this,
Michael Whalen