Hutool工具类导出Excel设置自适应宽度

SXSSFWorkbook workbook = new SXSSFWorkbook();
BigExcelWriter writer = new BigExcelWriter(workbook,"sheet1");
// ... 省略业务实现
writer.writeRow(data);
// 必须在write后调用
writer.autoSizeColumnAll();

sheet.setColumnWidth(columnNum, columnWidth );

public static void setSizeColumn(Sheet sheet, int size) {
     for (int columnNum = 0; columnNum <= size; columnNum++) {
         int columnWidth = sheet.getColumnWidth(columnNum) / 256;
         for (int rowNum = 0; rowNum <= sheet.getLastRowNum(); rowNum++) {
             Row currentRow;
             if (sheet.getRow(rowNum) == null) {
                 currentRow = sheet.createRow(rowNum);
             } else {
                 currentRow = sheet.getRow(rowNum);
             }

             if (currentRow.getCell(columnNum) != null) {
                 Cell currentCell = currentRow.getCell(columnNum);
                 if (currentCell.getCellType() == XSSFCell.CELL_TYPE_STRING) {
                     int length = currentCell.getStringCellValue().getBytes().length;
                     if (columnWidth < length) {
                         columnWidth = length;
                     }
                 }
             }
         }
         sheet.setColumnWidth(columnNum, columnWidth * 256);
     }
 }

setSizeColumn(writer.getSheet(), writer.getColumnCount());