Extracting OLE Objects from Workbook

allbad · October 1, 2012, 9:58am

I was able to successfully extract five adobe PDFs from an Excel workbook using the following link:

http://www.aspose.com/docs/display/cellsnet/Extract+Ole+Objects+from+Workbook

The .pdf's are named based on the Ole xx file name (outOLE0.pdf, outOLE1.pdf, outOLE2.pdf,etc) Is there a way to determine the row/column of the OLE objects, so that I can name the file more appropriately? I wanted to name ExcelFileName, concatenated, with a value in a row/cell (or similar). For example, ExcelTest-F2.pdf, ExcelTest-K2.pdf, ExcelTest-M2's value.

shakeel.faiz · October 1, 2012, 10:27am

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please use the following properties. These properties should meet your needs.

OleObject.UpperLeftColumn
OleObject.UpperLeftRow
OleObject.LowerRightColumn
OleObject.LowerRightRow

shakeel.faiz · October 1, 2012, 11:28am

Hi,

You are welcome.

Let us know if you face any other issue, we will be glad to assist you further.