Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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

Packages that use HSSFWorkbook
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
`static HSSFWorkbook` | `AbstractExcelUtils.loadXls(java.io.File xlsFile)`

Methods in org.apache.poi.hssf.converter with parameters of type HSSFWorkbook
`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
`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
`ExcelExtractor(HSSFWorkbook wb)`

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

Methods in org.apache.poi.hssf.model with parameters of type HSSFWorkbook
`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 `Ptg`s 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
`protected HSSFWorkbook` | `HSSFSheet._workbook`

Methods in org.apache.poi.hssf.usermodel that return HSSFWorkbook
`static HSSFWorkbook` | `HSSFWorkbook.create(InternalWorkbook book)`
`HSSFWorkbook` | `HSSFSheet.getWorkbook()` Return the parent workbook

Methods in org.apache.poi.hssf.usermodel with parameters of type HSSFWorkbook
`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
`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
`static void` | `HSSFRegionUtil.setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderBottom attribute of the HSSFRegionUtil object
`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.setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderRight attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderBottom attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the bottomBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the leftBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the rightBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the topBorderColor attribute of the HSSFRegionUtil object

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.