Automatically refresh OLE object

Aspose.Cells for Python via .NET provides the OleObject.auto_load property to refresh the OLE object when the excel file is opened in Microsoft Excel. Because of this property, the OLE object will display the correct OLE image generated by Microsoft Excel.

The following sample code loads the sample excel file which has a non-real OLE image. The OLE object is actually a Microsoft Word document but the sample excel file shows the animal image instead of Microsoft Word image. But if you open the output excel file, you will see Microsoft Excel displays the correct OLE image.

from aspose.cells import SaveFormat, Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create workbook object from your sample excel file
wb = Workbook(dataDir + "sample.xlsx")
#  Access first worksheet
sheet = wb.worksheets[0]
#  Set auto load property of first ole object to true
sheet.ole_objects[0].auto_load = True
#  Save the worbook in xlsx format
wb.save(dataDir + "RefreshOLEObjects_out.xlsx", SaveFormat.XLSX)