org.apache.poi.hssf.converter
Class AbstractExcelUtils

java.lang.Object
  org.apache.poi.hssf.converter.AbstractExcelUtils

Direct Known Subclasses:

ExcelToFoUtils, ExcelToHtmlUtils

@Beta
public class AbstractExcelUtils
extends java.lang.Object

Common class for ExcelToFoUtils and ExcelToHtmlUtils

Since:

POI 3.8 beta 5

Author:

Sergey Vladimirov (vlsergey {at} gmail {dot} com)

See Also:

AbstractWordUtils

AbstractExcelUtils

public AbstractExcelUtils()

getAlign

public static java.lang.String getAlign(short alignment)

Deprecated. POI 3.15 beta 3. Use getAlign(HorizontalAlignment) instead.

Parameters:

alignment - The horizontal alignment. See HorizontalAlignment.

Returns:

a friendly string representation of the alignment code

getAlign

public static java.lang.String getAlign(HorizontalAlignment alignment)

getBorderStyle

public static java.lang.String getBorderStyle(BorderStyle xlsBorder)

getBorderWidth

public static java.lang.String getBorderWidth(BorderStyle xlsBorder)

getColor

public static java.lang.String getColor(HSSFColor color)

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 with ExcelToHtmlUtils.buildMergedRangesMap(HSSFSheet)

Returns:

CellRangeAddress from map if cell with specified row and column numbers contained in found range, null otherwise

loadXls

public static HSSFWorkbook loadXls(java.io.File xlsFile)
                            throws java.io.IOException

Throws:

java.io.IOException