@Beta public class AbstractExcelUtils extends java.lang.Object
ExcelToFoUtils
and ExcelToHtmlUtils
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
|
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)
CellRangeAddress
from map if cell with specified row and
column numbers contained in found range, null otherwisepublic static HSSFWorkbook loadXls(java.io.File xlsFile) throws java.io.IOException
java.io.IOException
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.