org.zkoss.poi.hssf.converter

Class AbstractExcelUtils

java.lang.Object

org.zkoss.poi.hssf.converter.AbstractExcelUtils

Direct Known Subclasses:

ExcelToFoUtils, ExcelToHtmlUtils

@Beta
public class AbstractExcelUtils
extends Object

Common class for ExcelToFoUtils and ExcelToHtmlUtils

Author:

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

See Also:

AbstractWordUtils

Constructor Summary

Constructors

Constructor and Description
AbstractExcelUtils()

Method Summary

Modifier and Type	Method and Description
static String	getAlign(short alignment)
static String	getBorderStyle(short xlsBorder)
static String	getBorderWidth(short 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)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

AbstractExcelUtils

public AbstractExcelUtils()

Method Detail

getAlign

public static String getAlign(short alignment)

getBorderStyle

public static String getBorderStyle(short xlsBorder)

getBorderWidth

public static String getBorderWidth(short xlsBorder)

getColor

public static 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(File xlsFile)
                            throws IOException

Throws:

IOException