LightCellsDataProvider & .xls files

Using C#.NET LightCellsProvider - is there any way to output to an Excel 2003 (.xls) file? Or do I have to use .xlsx?

Hi,

Yes, you can use xls in light cells provider.

Please modify the demo which I have given you in my previous post like this to get output in xls format.

I have also attached the output.xls file generated by the code.

C#


var workbook = new Workbook();


var excelSaveOptions = new XlsSaveOptions();

excelSaveOptions.LightCellsDataProvider = new TestDataProvider(workbook);


workbook.Save(“output.xls”, excelSaveOptions);