| Package | Description | 
|---|---|
| cn.hutool.poi.excel | POI中对Excel读写的封装,入口为ExcelUtil | 
| Modifier and Type | Method and Description | 
|---|---|
| BigExcelWriter | BigExcelWriter. autoSizeColumn(int columnIndex) | 
| BigExcelWriter | BigExcelWriter. autoSizeColumnAll() | 
| BigExcelWriter | BigExcelWriter. autoSizeColumnAll(float widthRatio) | 
| static BigExcelWriter | ExcelUtil. getBigWriter()获得 BigExcelWriter,默认写出到第一个sheet不传入写出的Excel文件路径,只能调用ExcelWriter#flush(OutputStream)方法写出到流 若写出到文件,还需调用 ExcelWriter.setDestFile(File)方法自定义写出的文件,然后调用ExcelWriter.flush()方法写出到文件 | 
| static BigExcelWriter | ExcelUtil. getBigWriter(File destFile)获得 BigExcelWriter,默认写出到第一个sheet,名字为sheet1 | 
| static BigExcelWriter | ExcelUtil. getBigWriter(File destFile,
            String sheetName) | 
| static BigExcelWriter | ExcelUtil. getBigWriter(int rowAccessWindowSize)获得 BigExcelWriter,默认写出到第一个sheet不传入写出的Excel文件路径,只能调用ExcelWriter#flush(OutputStream)方法写出到流 若写出到文件,还需调用 ExcelWriter.setDestFile(File)方法自定义写出的文件,然后调用ExcelWriter.flush()方法写出到文件 | 
| static BigExcelWriter | ExcelUtil. getBigWriter(String destFilePath)获得 BigExcelWriter,默认写出到第一个sheet | 
| static BigExcelWriter | ExcelUtil. getBigWriter(String destFilePath,
            String sheetName) | 
Copyright © 2025. All rights reserved.