Package org.apache.poi.hssf.converter
Class AbstractExcelUtils
java.lang.Object
org.apache.poi.hssf.converter.AbstractExcelUtils
- Direct Known Subclasses:
ExcelToHtmlUtils
Common class for
ExcelToFoUtils
and ExcelToHtmlUtils
- Since:
- POI 3.8 beta 5
- Author:
- Sergey Vladimirov (vlsergey {at} gmail {dot} com)
- See Also:
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic String
getAlign
(HorizontalAlignment alignment) static String
getBorderStyle
(BorderStyle xlsBorder) static String
getBorderWidth
(BorderStyle xlsBorder) static String
static int
getColumnWidthInPx
(int widthUnits) See here for Xio explanation and detailsstatic CellRangeAddress
getMergedRange
(CellRangeAddress[][] mergedRanges, int rowNumber, int columnNumber) static HSSFWorkbook
-
Constructor Details
-
AbstractExcelUtils
public AbstractExcelUtils()
-
-
Method Details
-
getAlign
-
getBorderStyle
-
getBorderWidth
-
getColor
-
getColumnWidthInPx
public static int getColumnWidthInPx(int widthUnits) See here for Xio explanation and details -
getMergedRange
public static CellRangeAddress getMergedRange(CellRangeAddress[][] mergedRanges, int rowNumber, int columnNumber) - Parameters:
mergedRanges
- map of sheet merged ranges built withExcelToHtmlUtils.buildMergedRangesMap(Sheet)
- Returns:
CellRangeAddress
from map if cell with specified row and column numbers contained in found range, null otherwise
-
loadXls
- Throws:
IOException
-