how to apply the column wise format with lightcelldataprovider.
i am using this one.
it takes more time.
Style arrStyle = new Style[noOfCols];
for(int i=0; i<noOfCols; i++)
arrStyle[i] = (Style)styleHashTable.get(String.valueOf(i));
arrStyleIndex = CellsHelper.gatherStyles(writeWorkbook, arrStyle);
public void startCell(Cell cell)
Thanks & Regards
we are trying to creating the excel using LightCellDataProvider.
autofit column is not working in this case.
could you please give some solution.
Thanks & regards
we are still facing the issue.
Thanks & regards.
We have escalated your issue to our development team. Once we will get any update, we will let you know.
This issue has been logged as CELLSJAVA-27957.
Because you are saving the workbook by LightCellsDataProvider, you should know that there is no cell data when you call autofit methods. So the column width cannot be determined.
In light mode, we are afraid you have to look for other solutions to determine the proper column width and set it to corresponding Column object before saving the file.