I am facing some weird issue in this method.
I am using LightCellDataProvider for creating a excel file. Also I need to format same excel based on data size.
But any way autoFitColumn() doesn’t work in LightCellMode.
So I created a TWO dimensional array which maintains [SheetNumber][ColumnWidth].
Now suppose I have 2 sheets need to format. I will setColumnWidth for the first sheet after putting data in that sheet using startSheet() method.
setWidthSheet(sheetIndex-1) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
So this will set width for the previous sheet which has all data. But not saved in the Sheet (Due to LightCellMode).
And then I start processing next sheet.
This works perfectly in XlsSaveOptions for saving XLS-2003 file.
But same code doesn’t work for OoxmlSaveOptions for saving XLSX-2007 file format.