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

Packages that use HSSFWorkbook

Package	Description
org.apache.poi.hssf.converter
org.apache.poi.hssf.eventusermodel	HSSF eventmodel Package provides an event-based API for reading HSSF files.
org.apache.poi.hssf.extractor
org.apache.poi.hssf.model	Provides low level API structures for reading, writing, modifying XLS files.
org.apache.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.hssf.util	util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.

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

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

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

Methods in org.apache.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)
static org.w3c.dom.Document	ExcelToHtmlConverter.process(HSSFWorkbook workbook) Converts Excel file (97-2007) into HTML file.
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, BorderStyle 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.apache.poi.hssf.eventusermodel

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

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

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

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

Constructor and Description
ExcelExtractor(HSSFWorkbook wb)

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

Methods in org.apache.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.
static Ptg[]	HSSFFormulaParser.parse(java.lang.String formula, HSSFWorkbook workbook, FormulaType formulaType)
static Ptg[]	HSSFFormulaParser.parse(java.lang.String formula, HSSFWorkbook workbook, FormulaType 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.apache.poi.hssf.usermodel

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

Modifier and Type	Field and Description
protected HSSFWorkbook	HSSFSheet._workbook

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

Modifier and Type	Method and Description
static HSSFWorkbook	HSSFWorkbook.create(InternalWorkbook book)
static HSSFWorkbook	HSSFWorkbookFactory.createWorkbook() Create a new empty Workbook
static HSSFWorkbook	HSSFWorkbookFactory.createWorkbook(DirectoryNode root) Creates a HSSFWorkbook from the given DirectoryNode
static HSSFWorkbook	HSSFWorkbookFactory.createWorkbook(POIFSFileSystem fs) Creates a HSSFWorkbook from the given NPOIFSFileSystem
HSSFWorkbook	HSSFSheet.getWorkbook() Return the parent workbook

Methods in org.apache.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 parentSheet) Creates a bar chart.
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.
protected static java.lang.String	HSSFConditionalFormattingRule.toFormulaString(Ptg[] parsedExpression, HSSFWorkbook workbook)
void	HSSFCellStyle.verifyBelongsToWorkbook(HSSFWorkbook wb) Verifies that this style belongs to the supplied Workbook.

Constructors in org.apache.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.
HSSFBorderFormatting(CFRuleBase cfRuleRecord, HSSFWorkbook workbook)
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, CellType 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??
HSSFFontFormatting(CFRuleBase cfRuleRecord, HSSFWorkbook workbook)
HSSFFormulaEvaluator(HSSFWorkbook workbook)
HSSFFormulaEvaluator(HSSFWorkbook workbook, IStabilityClassifier stabilityClassifier)
HSSFPatternFormatting(CFRuleBase cfRuleRecord, HSSFWorkbook workbook)
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.apache.poi.hssf.util

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

Modifier and Type	Method and Description
static void	HSSFRegionUtil.setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. Sets the borderBottom attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setBorderLeft(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
static void	HSSFRegionUtil.setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. Sets the borderRight attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. Sets the borderBottom attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. Sets the bottomBorderColor attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. Sets the leftBorderColor attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. Sets the rightBorderColor attribute of the HSSFRegionUtil object
static void	HSSFRegionUtil.setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated. Sets the topBorderColor attribute of the HSSFRegionUtil object