OleObject.FileFormatType property

Aspose.Cells Product Family
1
Hi,

I want to extract embedded Xls (OLE object) from Xls file.

I'd read your Docs (http://www.aspose.com/docs/display/cellsnet/Managing+OLE+Objects) and understood that for getting the extension I've to use:

Workbook workbook = new Workbook(MyXls.xls");
OleObjectCollection oles = workbook.Worksheets[0].OleObjects;
for (int i = 0; i < oles.Count; i++)
{
OleObject ole = oles[i];
string extension = ole.FileType
Console.WriteLine(extension);
}

But then I got a warning:

Aspose.Cells.Drawing.OleObject.FileType' is obsolete: 'Use OleObject.FileFormatType property instead.'

So, I've used "FileFormatType":

string extension = ole.FileFormatType;
Its works good for embedded ppt\pptx\doc\docx etc BUT for embedded Xls there is a problem, ole.FileFormatType returns "Default" (instead of "Xls").

Is it the right return value or a bug?
If it is the right return value, what is its meaning? (when do we expect to receive this "Default" value?)

Please your help,

Thanks,

Roi.
2

Hi,


Yes, I think there should be no issue if you are getting Default as its file format type, it represents XLS (Excel 97 - 2003) file format.

Thank you.