Package | Description |
---|---|
org.dromara.hutool.poi.excel |
POI中对Excel读写的封装,入口为ExcelUtil
|
org.dromara.hutool.poi.excel.writer |
Excel生成封装
|
Modifier and Type | Method and Description |
---|---|
static BigExcelWriter |
ExcelUtil.getBigWriter()
获得
BigExcelWriter ,默认写出到第一个sheet不传入写出的Excel文件路径,只能调用ExcelWriter#flush(OutputStream)方法写出到流 若写出到文件,还需调用 ExcelWriter.setTargetFile(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.setTargetFile(File) 方法自定义写出的文件,然后调用ExcelWriter.flush() 方法写出到文件 |
static BigExcelWriter |
ExcelUtil.getBigWriter(String destFilePath)
获得
BigExcelWriter ,默认写出到第一个sheet |
static BigExcelWriter |
ExcelUtil.getBigWriter(String destFilePath,
String sheetName)
|
Modifier and Type | Method and Description |
---|---|
BigExcelWriter |
BigExcelWriter.autoSizeColumn(int columnIndex,
boolean useMergedCells,
float widthRatio) |
BigExcelWriter |
BigExcelWriter.autoSizeColumnAll(boolean useMergedCells,
float widthRatio) |
Copyright © 2025. All rights reserved.