Package | Description |
---|---|
org.dromara.hutool.poi.excel |
POI中对Excel读写的封装,入口为ExcelUtil
|
org.dromara.hutool.poi.excel.cell |
Excel中单元格相关类,入口为CellUtil
|
org.dromara.hutool.poi.excel.style |
Excel样式封装,入口为:StyleUtil
|
org.dromara.hutool.poi.excel.writer |
Excel生成封装
|
Modifier and Type | Method and Description |
---|---|
static void |
RowUtil.writeRow(org.apache.poi.ss.usermodel.Row row,
Iterable<?> rowData,
StyleSet styleSet,
boolean isHeader,
CellEditor cellEditor)
写一行数据
|
Modifier and Type | Method and Description |
---|---|
static void |
CellUtil.setCellValue(org.apache.poi.ss.usermodel.Cell cell,
Object value,
StyleSet styleSet,
boolean isHeader,
CellEditor cellEditor)
设置单元格值
根据传入的styleSet自动匹配样式 当为头部样式时默认赋值头部样式,但是头部中如果有数字、日期等类型,将按照数字、日期样式设置 |
Modifier and Type | Class and Description |
---|---|
class |
DefaultStyleSet
默认样式集合,定义了标题、数字、日期等默认样式
|
Modifier and Type | Method and Description |
---|---|
StyleSet |
ExcelWriter.getStyleSet()
获取样式集,样式集可以自定义包括:
1. |
Modifier and Type | Method and Description |
---|---|
SheetDataWriter |
SheetDataWriter.setStyleSet(StyleSet styleSet)
设置样式表
|
ExcelWriter |
ExcelWriter.setStyleSet(StyleSet styleSet)
设置样式集,如果不使用样式,传入
null |
Constructor and Description |
---|
SheetDataWriter(org.apache.poi.ss.usermodel.Sheet sheet,
ExcelWriteConfig config,
StyleSet styleSet)
构造
|
Copyright © 2025. All rights reserved.