@Beta public class AbstractExcelUtils extends Object
ExcelToFoUtils
and ExcelToHtmlUtils
AbstractWordUtils
Constructor and Description |
---|
AbstractExcelUtils() |
Modifier and Type | Method and Description |
---|---|
static String |
getAlign(HorizontalAlignment alignment) |
static String |
getBorderStyle(BorderStyle xlsBorder) |
static String |
getBorderWidth(BorderStyle xlsBorder) |
static 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(File xlsFile) |
public static String getAlign(HorizontalAlignment alignment)
public static String getBorderStyle(BorderStyle xlsBorder)
public static String getBorderWidth(BorderStyle xlsBorder)
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(File xlsFile) throws IOException
IOException
Copyright © 2010 - 2020 Adobe. All Rights Reserved