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

Packages that use HSSFWorkbook

Package	Description
org.apache.poi.hssf	Horrible SpreadSheet Format API's for reading/writting Excel files using pure Java.
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	The usermodel package maps HSSF low level structures to familiar workbook/sheet model

Uses of HSSFWorkbook in org.apache.poi.hssf

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

Modifier and Type	Method	Description
static HSSFWorkbook	HSSFParser.parse(InputStream stream)	Parse the given InputStream and return a new HSSFWorkbook instance.

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

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

Modifier and Type	Method	Description
protected String	ExcelToHtmlConverter.buildStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle)
protected String	ExcelToHtmlConverter.getStyleClassName(HSSFWorkbook workbook, HSSFCellStyle cellStyle)
static Document	ExcelToHtmlConverter.process(HSSFWorkbook workbook)	Converts Excel file (97-2007) into HTML file.
protected boolean	ExcelToFoConverter.processCell(HSSFWorkbook workbook, HSSFCell cell, Element tableCellElement, int normalWidthPx, int maxSpannedWidthPx, float normalHeightPt)
protected void	ExcelToFoConverter.processCellStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle, Element cellTarget, Element blockTarget)
protected void	ExcelToFoConverter.processCellStyleBorder(HSSFWorkbook workbook, Element cellTarget, String type, BorderStyle xlsBorder, short borderColor)
protected void	ExcelToFoConverter.processCellStyleFont(HSSFWorkbook workbook, Element blockTarget, HSSFFont font)
protected int	ExcelToFoConverter.processRow(HSSFWorkbook workbook, CellRangeAddress[][] mergedRanges, HSSFRow row, Element tableRowElement)
protected boolean	ExcelToFoConverter.processSheet(HSSFWorkbook workbook, int sheetIndex)	Process single sheet (as specified by 0-based sheet index)
protected float	ExcelToFoConverter.processSheet(HSSFWorkbook workbook, HSSFSheet sheet, Element flow)
void	ExcelToFoConverter.processWorkbook(HSSFWorkbook workbook)
void	ExcelToHtmlConverter.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	Description
HSSFWorkbook	EventWorkbookBuilder.SheetRecordCollectingListener.getStubHSSFWorkbook()

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

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

Modifier and Type	Method	Description
HSSFWorkbook	ExcelExtractor.getDocument()
HSSFWorkbook	ExcelExtractor.getFilesystem()

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

Modifier	Constructor	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	Description
static Ptg[]	HSSFFormulaParser.parse(String formula, HSSFWorkbook workbook)	Convenience method for parsing cell formulas.
static Ptg[]	HSSFFormulaParser.parse(String formula, HSSFWorkbook workbook, FormulaType formulaType)
static Ptg[]	HSSFFormulaParser.parse(String formula, HSSFWorkbook workbook, FormulaType formulaType, int sheetIndex)
static 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	Description
protected final HSSFWorkbook	HSSFSheet._workbook

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

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

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

Modifier and Type	Method	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.
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

Modifier	Constructor	Description
	EscherGraphics(HSSFShapeGroup escherGroup, HSSFWorkbook workbook, Color forecolor, float verticalPointsPerPixel)	Construct an escher graphics object.
protected	HSSFBorderFormatting(CFRuleBase cfRuleRecord, HSSFWorkbook workbook)
protected	HSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col)	Creates new Cell - Should only be called by HSSFRow.
protected	HSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col, CellType type)	Creates new Cell - Should only be called by HSSFRow.
protected	HSSFCell(HSSFWorkbook book, HSSFSheet sheet, CellValueRecordInterface cval)	Creates an HSSFCell from a CellValueRecordInterface.
protected	HSSFCellStyle(short index, ExtendedFormatRecord rec, HSSFWorkbook workbook)
	HSSFFormulaEvaluator(HSSFWorkbook workbook)
	HSSFFormulaEvaluator(HSSFWorkbook workbook, IStabilityClassifier stabilityClassifier)
protected	HSSFPatternFormatting(CFRuleBase cfRuleRecord, HSSFWorkbook workbook)
protected	HSSFSheet(HSSFWorkbook workbook)	Creates new HSSFSheet - called by HSSFWorkbook to create a sheet from scratch.
protected	HSSFSheet(HSSFWorkbook workbook, InternalSheet sheet)	Creates an HSSFSheet representing the given Sheet object.