- Code: Select all
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
workbook.LoadFromStream(cdfStream);
workbook.SaveToFile(filePathName, ExcelVersion.Version2013);
It doesn't matter which ExcelVersion I choose. This is how the conversion looks:
The data is coming from a 3rd party database so that is why the code sample has the data loaded as a stream. It doesn't matter if I export to a file first, the same thing happens. Attached is the raw file from the database.
The 3rd party application hides the workbook so you have to click the View menu in Excel and click Unhide to view the data. The conversion automatically unhides the data which is perfectly fine.
Any help would be appreciated.