Automatically refresh OLE object via Microsoft Excel with C++

Aspose.Cells provides the OleObject.GetAutoLoad() 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 the Microsoft Word image. However, if you open the output Excel file, you will see Microsoft Excel displays the correct OLE image.

#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;

int main()
{
    Aspose::Cells::Startup();

    // Source directory path
    U16String srcDir(u"..\\Data\\01_SourceDirectory\\");

    // Create workbook object from your sample excel file
    Workbook wb(srcDir + u"sample.xlsx");

    // Access first worksheet
    Worksheet sheet = wb.GetWorksheets().Get(0);

    // Set auto load property of first ole object to true
    sheet.GetOleObjects().Get(0).SetAutoLoad(true);

    // Save the workbook in xlsx format
    wb.Save(srcDir + u"RefreshOLEObjects_out.xlsx", SaveFormat::Xlsx);

    std::cout << "OLE object refreshed successfully!" << std::endl;

    Aspose::Cells::Cleanup();
}