Xlsb Binary support

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