Uses of Class
org.zkoss.poi.hssf.usermodel.HSSFWorkbook

Packages that use HSSFWorkbook

Package	Description
org.zkoss.poi.hssf.converter
org.zkoss.poi.hssf.eventusermodel	HSSF eventmodel Package provides an event-based API for reading HSSF files.
org.zkoss.poi.hssf.extractor
org.zkoss.poi.hssf.model	Provides low level API structures for reading, writing, modifying XLS files.
org.zkoss.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model Related Documentation For overviews, tutorials, examples, guides, and tool documentation, please see: Apache POI Project
org.zkoss.poi.hssf.util	util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.

Uses of HSSFWorkbook in org.zkoss.poi.hssf.converter

Methods in org.zkoss.poi.hssf.converter that return HSSFWorkbook

Modifier and Type	Method and Description
static HSSFWorkbook	AbstractExcelUtils.loadXls(java.io.File xlsFile)

Methods in org.zkoss.poi.hssf.converter with parameters of type HSSFWorkbook

Modifier and Type	Method and Description
protected java.lang.String	ExcelToHtmlConverter.buildStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle)
protected java.lang.String	ExcelToHtmlConverter.getStyleClassName(HSSFWorkbook workbook, HSSFCellStyle cellStyle)
protected boolean	ExcelToFoConverter.processCell(HSSFWorkbook workbook, HSSFCell cell, org.w3c.dom.Element tableCellElement, int normalWidthPx, int maxSpannedWidthPx, float normalHeightPt)
protected void	ExcelToFoConverter.processCellStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle, org.w3c.dom.Element cellTarget, org.w3c.dom.Element blockTarget)
protected void	ExcelToFoConverter.processCellStyleBorder(HSSFWorkbook workbook, org.w3c.dom.Element cellTarget, java.lang.String type, short xlsBorder, short borderColor)
protected void	ExcelToFoConverter.processCellStyleFont(HSSFWorkbook workbook, org.w3c.dom.Element blockTarget, HSSFFont font)
protected int	ExcelToFoConverter.processRow(HSSFWorkbook workbook, CellRangeAddress[][] mergedRanges, HSSFRow row, org.w3c.dom.Element tableRowElement)
protected float	ExcelToFoConverter.processSheet(HSSFWorkbook workbook, HSSFSheet sheet, org.w3c.dom.Element flow)
protected boolean	ExcelToFoConverter.processSheet(HSSFWorkbook workbook, int sheetIndex) Process single sheet (as specified by 0-based sheet index)
void	ExcelToHtmlConverter.processWorkbook(HSSFWorkbook workbook)
void	ExcelToFoConverter.processWorkbook(HSSFWorkbook workbook)

Uses of HSSFWorkbook in org.zkoss.poi.hssf.eventusermodel

Methods in org.zkoss.poi.hssf.eventusermodel that return HSSFWorkbook

Modifier and Type	Method and Description
HSSFWorkbook	EventWorkbookBuilder.SheetRecordCollectingListener.getStubHSSFWorkbook()

Uses of HSSFWorkbook in org.zkoss.poi.hssf.extractor

Constructors in org.zkoss.poi.hssf.extractor with parameters of type HSSFWorkbook

Constructor and Description
ExcelExtractor(HSSFWorkbook wb)

Uses of HSSFWorkbook in org.zkoss.poi.hssf.model

Methods in org.zkoss.poi.hssf.model with parameters of type HSSFWorkbook

Modifier and Type	Method and Description
static Ptg[]	HSSFFormulaParser.parse(java.lang.String formula, HSSFWorkbook workbook) Convenience method for parsing cell formulas. see HSSFFormulaParser.parse(String, HSSFWorkbook, int, int)
static Ptg[]	HSSFFormulaParser.parse(java.lang.String formula, HSSFWorkbook workbook, int formulaType)
static Ptg[]	HSSFFormulaParser.parse(java.lang.String formula, HSSFWorkbook workbook, int formulaType, int sheetIndex)
static java.lang.String	HSSFFormulaParser.toFormulaString(HSSFWorkbook book, Ptg[] ptgs) Static method to convert an array of Ptgs in RPN order to a human readable string format in infix mode.

Uses of HSSFWorkbook in org.zkoss.poi.hssf.usermodel

Fields in org.zkoss.poi.hssf.usermodel declared as HSSFWorkbook

Modifier and Type	Field and Description
protected HSSFWorkbook	HSSFSheet._workbook

Methods in org.zkoss.poi.hssf.usermodel that return HSSFWorkbook

Modifier and Type	Method and Description
static HSSFWorkbook	HSSFWorkbook.create(InternalWorkbook book)
HSSFWorkbook	HSSFSheet.getWorkbook() Return the parent workbook

Methods in org.zkoss.poi.hssf.usermodel with parameters of type HSSFWorkbook

Modifier and Type	Method and Description
static HSSFEvaluationWorkbook	HSSFEvaluationWorkbook.create(HSSFWorkbook book)
static HSSFFormulaEvaluator	HSSFFormulaEvaluator.create(HSSFWorkbook workbook, IStabilityClassifier stabilityClassifier, UDFFinder udfFinder)
void	HSSFChart.createBarChart(HSSFWorkbook workbook, HSSFSheet sheet) Creates a bar chart.
protected HSSFSheet	HSSFWorkbook.createHSSFSheet(HSSFWorkbook workbook)
protected HSSFSheet	HSSFWorkbook.createHSSFSheet(HSSFWorkbook workbook, InternalSheet sheet)
static void	HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFWorkbook wb) Loops over all cells in all sheets of the supplied workbook.
HSSFColor	HSSFFont.getHSSFColor(HSSFWorkbook wb) get the color value for the font
static void	HSSFOptimiser.optimiseCellStyles(HSSFWorkbook workbook) Goes through the Wokrbook, optimising the cell styles by removing duplicate ones, and ones that aren't used.
static void	HSSFOptimiser.optimiseFonts(HSSFWorkbook workbook) Goes through the Workbook, optimising the fonts by removing duplicate ones.
void	HSSFCellStyle.verifyBelongsToWorkbook(HSSFWorkbook wb) Verifies that this style belongs to the supplied Workbook.

Constructors in org.zkoss.poi.hssf.usermodel with parameters of type HSSFWorkbook

Constructor and Description
EscherGraphics(HSSFShapeGroup escherGroup, HSSFWorkbook workbook, java.awt.Color forecolor, float verticalPointsPerPixel) Construct an escher graphics object.
HSSFCell(HSSFWorkbook book, HSSFSheet sheet, CellValueRecordInterface cval) Creates an HSSFCell from a CellValueRecordInterface.
HSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col) Creates new Cell - Should only be called by HSSFRow.
HSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col, int type) Creates new Cell - Should only be called by HSSFRow.
HSSFCellStyle(short index, ExtendedFormatRecord rec, HSSFWorkbook workbook) Creates new HSSFCellStyle why would you want to do this??
HSSFFormulaEvaluator(HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. (Sep 2008) HSSFSheet parameter is ignored
HSSFFormulaEvaluator(HSSFWorkbook workbook)
HSSFFormulaEvaluator(HSSFWorkbook workbook, IStabilityClassifier stabilityClassifier)
HSSFSheet(HSSFWorkbook workbook) Creates new HSSFSheet - called by HSSFWorkbook to create a sheet from scratch.
HSSFSheet(HSSFWorkbook workbook, InternalSheet sheet) Creates an HSSFSheet representing the given Sheet object.

Uses of HSSFWorkbook in org.zkoss.poi.hssf.util

Methods in org.zkoss.poi.hssf.util with parameters of type HSSFWorkbook

Modifier and Type	Method and Description
static void	HSSFCellUtil.setAlignment(HSSFCell cell, HSSFWorkbook workbook, short align) Take a cell, and align it.
static void	HSSFRegionUtil.setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Sets the borderBottom attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setBorderBottom(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. (Aug 2008) use CellRangeAddress instead of Region
static void	HSSFRegionUtil.setBorderLeft(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
static void	HSSFRegionUtil.setBorderLeft(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. (Aug 2008) use CellRangeAddress instead of Region
static void	HSSFRegionUtil.setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Sets the borderRight attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setBorderRight(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. (Aug 2008) use CellRangeAddress instead of Region
static void	HSSFRegionUtil.setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Sets the borderBottom attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setBorderTop(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. (Aug 2008) use CellRangeAddress instead of Region
static void	HSSFRegionUtil.setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Sets the bottomBorderColor attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setBottomBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. (Aug 2008) use CellRangeAddress instead of Region
static void	HSSFCellUtil.setCellStyleProperty(HSSFCell cell, HSSFWorkbook workbook, java.lang.String propertyName, java.lang.Object propertyValue) This method attempt to find an already existing HSSFCellStyle that matches what you want the style to be.
static void	HSSFCellUtil.setFont(HSSFCell cell, HSSFWorkbook workbook, HSSFFont font) Take a cell, and apply a font to it
static void	HSSFRegionUtil.setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Sets the leftBorderColor attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setLeftBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. (Aug 2008) use CellRangeAddress instead of Region
static void	HSSFRegionUtil.setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Sets the rightBorderColor attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setRightBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. (Aug 2008) use CellRangeAddress instead of Region
static void	HSSFRegionUtil.setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Sets the topBorderColor attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setTopBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. (Aug 2008) use CellRangeAddress instead of Region