@Beta public class AbstractExcelUtils extends java.lang.Object
AbstractWordUtils
Constructor and Description |
---|
AbstractExcelUtils() |
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
getAlign(HorizontalAlignment alignment) |
static java.lang.String |
getBorderStyle(BorderStyle xlsBorder) |
static java.lang.String |
getBorderWidth(BorderStyle xlsBorder) |
static java.lang.String |
getColor(HSSFColor color) |
static int |
getColumnWidthInPx(int widthUnits)
See
here for Xio explanation and details
(有关 Xio 的说明和详细信息,请参见此处)
|
static CellRangeAddress |
getMergedRange(CellRangeAddress[][] mergedRanges, int rowNumber, int columnNumber) |
static HSSFWorkbook |
loadXls(java.io.File xlsFile) |
public static java.lang.String getAlign(HorizontalAlignment alignment)
public static java.lang.String getBorderStyle(BorderStyle xlsBorder)
public static java.lang.String getBorderWidth(BorderStyle xlsBorder)
public static java.lang.String getColor(HSSFColor color)
public static int getColumnWidthInPx(int widthUnits)
public static CellRangeAddress getMergedRange(CellRangeAddress[][] mergedRanges, int rowNumber, int columnNumber)
mergedRanges
- map of sheet merged ranges built with
ExcelToHtmlUtils.buildMergedRangesMap(Sheet)
(mergeRanges - 使用 ExcelToHtmlUtils.buildMergedRangesMap(Sheet) 构建的工作表合并范围的地图)
CellRangeAddress
from map if cell with specified row and column numbers contained in found range,
null otherwise
(地图中的 CellRangeAddress 如果具有指定行号和列号的单元格包含在找到的范围内,否则为 null)
public static HSSFWorkbook loadXls(java.io.File xlsFile) throws java.io.IOException
java.io.IOException
(java.io.IOException)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.