AutosizeColumns on SXSSFWorkbook
Use sheet.isColumnTrackedForAutoSizing(0); for first and subsequently used for other column, i have faced exception whenever code executed autoSizeColumn(0) get executed. by using above code i have resolved the issue and it's good to expand the column width too based on the text.
You need to make sure every cell has a value.
We use the following code to set a string value to a cell:
Cell c = row.createCell(i);
c.setCellValue(text == null ? "" : text );
** Cell should never be null values else it throws NullPointerException. Hence set the value as shown above.
Thanks a lot, this helped!!