Extract OLE Objects from Workbook

Sometimes, you do need to extract OLE objects from a workbook. Aspose.Cells for Python via .NET supports extracting and saving those Ole objects.

This article shows how to create a console application in Visual Studio.Net and extract different OLE objects from a workbook with a few simple lines of code.

Extract OLE Objects from a Workbook

Creating a Template Workbook

1. Created a workbook in Microsoft Excel.
2. Add a Microsoft Word document, an Excel workbook and a PDF document as OLE objects on first worksheet.

Template document with OLE objects (OleFile.xls)

Next extract the OLE objects and save them to the hard disk with their respective file types.

Extract OLE Objects Using Aspose.Cells for Python Excel Library

The code below does the actual work of finding and extracting OLE objects. The OLE objects (DOC, XLS and PDF files) are saved to disk.