Package org.apache.poi.hssf.converter
Class AbstractExcelUtils
- java.lang.Object
-
- org.apache.poi.hssf.converter.AbstractExcelUtils
-
- Direct Known Subclasses:
ExcelToHtmlUtils
@Beta public class AbstractExcelUtils extends Object
Common class forExcelToFoUtils
andExcelToHtmlUtils
- Since:
- POI 3.8 beta 5
- See Also:
AbstractWordUtils
-
-
Constructor Summary
Constructors Constructor Description AbstractExcelUtils()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method 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 detailsstatic CellRangeAddress
getMergedRange(CellRangeAddress[][] mergedRanges, int rowNumber, int columnNumber)
static HSSFWorkbook
loadXls(File xlsFile)
-
-
-
Method Detail
-
getAlign
public static String getAlign(HorizontalAlignment alignment)
-
getBorderStyle
public static String getBorderStyle(BorderStyle xlsBorder)
-
getBorderWidth
public static String getBorderWidth(BorderStyle xlsBorder)
-
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
public static HSSFWorkbook loadXls(File xlsFile) throws IOException
- Throws:
IOException
-
-