Package net.datenwerke.rs.jxlsreport.service.jxlsreport.utils

Class AbstractExcelUtils

java.lang.Object

net.datenwerke.rs.jxlsreport.service.jxlsreport.utils.AbstractExcelUtils

public class AbstractExcelUtils
extends Object

Common class for

invalid reference

ExcelToFoConverter

and

invalid reference

ExcelToHtmlConverter

Since:

POI 3.8 beta 5

See Also:

• invalid reference

  AbstractWordUtils

Constructor Summary

Constructors

Constructor	Description
AbstractExcelUtils()

Method Summary

Modifier and Type	Method	Description
static void	appendAlign(StringBuilder style, HorizontalAlignment alignment)
static CellRangeAddress[][]	buildMergedRangesMap(Sheet sheet)	Creates a map (i.e.
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)

Methods inherited from class java.lang.Object

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

Constructor Details

AbstractExcelUtils

public AbstractExcelUtils()

Method Details

getAlign

public static String getAlign(HorizontalAlignment alignment)

getBorderStyle

public static String getBorderStyle(BorderStyle xlsBorder)

getBorderWidth

public static String getBorderWidth(BorderStyle 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 buildMergedRangesMap(Sheet)

Returns:

invalid reference

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

appendAlign

public static void appendAlign(StringBuilder style,
 HorizontalAlignment alignment)

buildMergedRangesMap

public static CellRangeAddress[][] buildMergedRangesMap(Sheet sheet)

Creates a map (i.e. two-dimensional array) filled with ranges. Allow fast retrieving

invalid reference

CellRangeAddress

of any cell, if cell is contained in range.

See Also:

• getMergedRange(CellRangeAddress[][], int, int)