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 © 2024. All rights reserved.