We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Specific XLS is not supported

Attached is a strange kind of XLS file. MS Excel can open it after a warning.
Aspose.Cells throws CellsException {“The file format and extension do not match.”}.

What kind of XLS is this?
Do you plan to support it in future?

Thanks!
Vassil348152_NotSupported - XML Spreadsheet.zip (2.5 KB)

@DWProject,

We evaluated your file and found your so called XLS file is actually an XML (SpreadsheetML 2003) file. It is necessary to specify the proper LoadFormat in code, so Aspose.Cells could understand it as a SpreadsheetML file. Please try the following sample code and it will work fine:
e.g.
Sample code:

LoadOptions options = new LoadOptions(LoadFormat.SpreadsheetML);
Workbook workbook = new Workbook("e:\\test2\\348152_NotSupported - XML Spreadsheet.xls", options);

Hope, this helps a bit.

Thanks for the sample code and sorry for the late answer.
I tried the code and exception is no longer thrown. However, this file can’t be rendered or converted to PDF. It has no pages.

Can you please try to save it as a PDF
doc.Save(outputFile, Aspose.Cells.SaveFormat.Pdf);
In my case an empty PDF is created.

Is this a limited support? Or is it an issue?

@DWProject,
We have observed this issue where the output PDF is empty and logged it in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSNET-48478 - XML file contents are not loaded

@DWProject,
This is to inform you that your issue has been resolved. We will provide you the fixed version within the next few days after performing QA and incorporating other enhancements and fixes.

@DWProject
Please try the latest 21.7.6
Aspose.Cells21.7.6 For .Net2_AuthenticodeSigned.Zip (5.6 MB)
Aspose.Cells21.7.6 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.7.6 For .NetStandard20.Zip (5.6 MB)

Thanks! I can render the file using Aspose.Cells21.7.6 For .Net4.0

However, specifying LoadFormat.SpreadsheetML is not needed. LoadFormat.Auto is enough.

Best Regards,
Vassil

@DWProject,
Thank you for the feedback and we are glad to know that your issue is resolved. Feel free to write us back if you have any other query in this regard.

The issues you have found earlier (filed as CELLSNET-48478) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao