int columnsSize = 100; Sheet sheet = workbook.createSheet("sheet") ((SXSSFSheet) sheet).trackAllColumnsForAutoSizing(); for (int i = 0; i < columnsSize; i++) { sheet.autoSizeColumn(i); }