Package | Description |
---|---|
cn.orionsec.kit.office.excel | |
cn.orionsec.kit.office.excel.option |
Modifier and Type | Method and Description |
---|---|
static Date |
Excels.getCellDate(org.apache.poi.ss.usermodel.Cell cell,
CellOption option)
获取时间
|
static Date |
Excels.getCellDate(org.apache.poi.ss.usermodel.Cell cell,
org.apache.poi.ss.usermodel.CellType type,
CellOption option)
获取时间
|
static BigDecimal |
Excels.getCellDecimal(org.apache.poi.ss.usermodel.Cell cell,
CellOption option)
获取数字
|
static BigDecimal |
Excels.getCellDecimal(org.apache.poi.ss.usermodel.Cell cell,
org.apache.poi.ss.usermodel.CellType type,
CellOption option)
获取数字
|
static Integer |
Excels.getCellInteger(org.apache.poi.ss.usermodel.Cell cell,
CellOption option)
获取数字
|
static Integer |
Excels.getCellInteger(org.apache.poi.ss.usermodel.Cell cell,
org.apache.poi.ss.usermodel.CellType type,
CellOption option)
获取数字
|
static Long |
Excels.getCellLong(org.apache.poi.ss.usermodel.Cell cell,
CellOption option)
获取数字
|
static Long |
Excels.getCellLong(org.apache.poi.ss.usermodel.Cell cell,
org.apache.poi.ss.usermodel.CellType type,
CellOption option)
获取数字
|
static <T> T |
Excels.getCellValue(org.apache.poi.ss.usermodel.Cell cell,
ExcelReadType type,
CellOption option)
通过类型获取值
|
static void |
Excels.setCellValue(org.apache.poi.ss.usermodel.Cell cell,
Object value,
ExcelFieldType type,
CellOption option)
设置cell的值
|
static void |
Excels.setLink(org.apache.poi.ss.usermodel.Workbook workbook,
org.apache.poi.ss.usermodel.Cell cell,
ExcelLinkType linkType,
String address,
ExcelFieldType textType,
CellOption option,
Object text)
设置超链接
|
Modifier and Type | Method and Description |
---|---|
CellOption |
WriteFieldOption.getCellOption() |
CellOption |
PictureOption.getCellOption() |
CellOption |
LinkOption.getCellOption() |
CellOption |
ImportFieldOption.getCellOption() |
CellOption |
ExportFieldOption.getCellOption() |
Modifier and Type | Method and Description |
---|---|
void |
WriteFieldOption.setCellOption(CellOption cellOption) |
void |
PictureOption.setCellOption(CellOption cellOption) |
void |
LinkOption.setCellOption(CellOption cellOption) |
void |
ImportFieldOption.setCellOption(CellOption cellOption) |
void |
ExportFieldOption.setCellOption(CellOption cellOption) |
Copyright © 2024. All rights reserved.