public abstract class ExcelTools extends Object
| 构造器和说明 |
|---|
ExcelTools() |
| 限定符和类型 | 方法和说明 |
|---|---|
static String |
columnIndexToName(int columnIndex)
列序号转换为列名
1 = A, 27 = AA, 37 = AK, 216 = HH |
static int |
columnNameToIndex(String columnName)
列名转换为列序号
A = 1, AA = 27, AK = 37, HH = 216 |
static void |
copyCell(org.apache.poi.ss.usermodel.Cell src,
org.apache.poi.ss.usermodel.Cell target,
boolean copyValue)
复制单元格
|
static void |
copyConcat(Map<String,Object> data,
List<CopyConcat> copyConcatFields)
将多个字段复制合并到一个字段
|
static void |
copyRow(org.apache.poi.ss.usermodel.Row src,
org.apache.poi.ss.usermodel.Row target,
boolean copyValue)
复制行
|
static void |
copySheet(org.apache.poi.ss.usermodel.Sheet src,
org.apache.poi.ss.usermodel.Sheet target,
boolean copyValue)
复制Sheet
TODO 目前只复制了部分属性, 另外复制前景色和背景色有问题 |
static Object |
getCellValue(org.apache.poi.ss.usermodel.Cell cell)
获取单元格的值
|
static int |
getTotalColumnsOfRow(org.apache.poi.ss.usermodel.Row row)
获取Row的总列数
|
static int |
getTotalRowsOfSheet(org.apache.poi.ss.usermodel.Sheet sheet)
获取Sheet的总行数
|
static String |
newConvertErrorMessage(CellInfo cell,
CellRule rule) |
static boolean |
setCellValue(org.apache.poi.ss.usermodel.Cell cell,
Object value)
设置单元格的值, 如果格式转换失败将不会设置单元格
|
static boolean |
setCellValue(org.apache.poi.ss.usermodel.Cell cell,
Object value,
boolean setToStringOnConvertError)
设置单元格的值
|
public static int getTotalRowsOfSheet(org.apache.poi.ss.usermodel.Sheet sheet)
public static int getTotalColumnsOfRow(org.apache.poi.ss.usermodel.Row row)
public static int columnNameToIndex(String columnName)
columnName - 列名, 如A, AA, AK, HHpublic static String columnIndexToName(int columnIndex)
columnIndex - 列序号, 从1开始public static void copyConcat(Map<String,Object> data, List<CopyConcat> copyConcatFields)
public static void copySheet(org.apache.poi.ss.usermodel.Sheet src,
org.apache.poi.ss.usermodel.Sheet target,
boolean copyValue)
src - 复制源target - 目标行copyValue - 是否复制值public static void copyRow(org.apache.poi.ss.usermodel.Row src,
org.apache.poi.ss.usermodel.Row target,
boolean copyValue)
src - 复制源target - 目标行copyValue - 是否复制值public static void copyCell(org.apache.poi.ss.usermodel.Cell src,
org.apache.poi.ss.usermodel.Cell target,
boolean copyValue)
src - 复制源target - 目标行copyValue - 是否复制值public static Object getCellValue(org.apache.poi.ss.usermodel.Cell cell)
cell - 单元格public static boolean setCellValue(org.apache.poi.ss.usermodel.Cell cell,
Object value)
cell - 单元格value - 值public static boolean setCellValue(org.apache.poi.ss.usermodel.Cell cell,
Object value,
boolean setToStringOnConvertError)
cell - 单元格value - 值setToStringOnConvertError - 格式转换失败时是否设置为toString的值Copyright © 2020. All rights reserved.