Hi, I tried saving my workbook as an Excel Binary file (the latest release mentions it supports this format). When I try the load function, an exception is thrown, saying “LoadData method does not support this file format:Excel2007Xlsb”. The file is attached.
Any tips on how to achieve this? Is there a separate method to call?
Cheers
Hi,
Please use Workbook.Open method instead of Workbook.LoadData method. See the following sample code it works fine.
Workbook book = new Workbook();
book.Open(“e:\test\xb\orig.xlsb”);
book.Save(“e:\test\xb\origout.xlsb”,FileFormatType.Excel2007Xlsb);
Thank you.
Aha, thanks for your help! Works on this end too.
Cheers
Mark