Uses of Class
org.apache.poi.hssf.usermodel.HSSFWorkbook
Packages that use HSSFWorkbook
Package
Description
HSSF eventmodel Package provides an event-based API for reading HSSF files.
Provides low level API structures for reading, writing, modifying XLS files.
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
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 HSSFWorkbookMethods in org.apache.poi.hssf.converter with parameters of type HSSFWorkbookModifier and TypeMethodDescriptionprotected StringExcelToHtmlConverter.buildStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle) protected StringExcelToHtmlConverter.getStyleClassName(HSSFWorkbook workbook, HSSFCellStyle cellStyle) static DocumentExcelToHtmlConverter.process(HSSFWorkbook workbook) Converts Excel file (97-2007) into HTML file.protected booleanExcelToFoConverter.processCell(HSSFWorkbook workbook, HSSFCell cell, Element tableCellElement, int normalWidthPx, int maxSpannedWidthPx, float normalHeightPt) protected voidExcelToFoConverter.processCellStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle, Element cellTarget, Element blockTarget) protected voidExcelToFoConverter.processCellStyleBorder(HSSFWorkbook workbook, Element cellTarget, String type, BorderStyle xlsBorder, short borderColor) protected voidExcelToFoConverter.processCellStyleFont(HSSFWorkbook workbook, Element blockTarget, HSSFFont font) protected intExcelToFoConverter.processRow(HSSFWorkbook workbook, CellRangeAddress[][] mergedRanges, HSSFRow row, Element tableRowElement) protected booleanExcelToFoConverter.processSheet(HSSFWorkbook workbook, int sheetIndex) Process single sheet (as specified by 0-based sheet index)protected floatExcelToFoConverter.processSheet(HSSFWorkbook workbook, HSSFSheet sheet, Element flow) voidExcelToFoConverter.processWorkbook(HSSFWorkbook workbook) voidExcelToHtmlConverter.processWorkbook(HSSFWorkbook workbook) -
Uses of HSSFWorkbook in org.apache.poi.hssf.eventusermodel
Methods in org.apache.poi.hssf.eventusermodel that return HSSFWorkbookModifier and TypeMethodDescriptionEventWorkbookBuilder.SheetRecordCollectingListener.getStubHSSFWorkbook() -
Uses of HSSFWorkbook in org.apache.poi.hssf.extractor
Constructors in org.apache.poi.hssf.extractor with parameters of type HSSFWorkbook -
Uses of HSSFWorkbook in org.apache.poi.hssf.model
Methods in org.apache.poi.hssf.model with parameters of type HSSFWorkbookModifier and TypeMethodDescriptionstatic 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 StringHSSFFormulaParser.toFormulaString(HSSFWorkbook book, Ptg[] ptgs) Static method to convert an array ofPtgs 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 HSSFWorkbookMethods in org.apache.poi.hssf.usermodel that return HSSFWorkbookModifier and TypeMethodDescriptionstatic HSSFWorkbookHSSFWorkbook.create(InternalWorkbook book) static HSSFWorkbookHSSFWorkbookFactory.createWorkbook()Create a new empty Workbookstatic HSSFWorkbookHSSFWorkbookFactory.createWorkbook(DirectoryNode root) Creates a HSSFWorkbook from the given DirectoryNodestatic HSSFWorkbookHSSFWorkbookFactory.createWorkbook(POIFSFileSystem fs) Creates a HSSFWorkbook from the given NPOIFSFileSystemHSSFSheet.getWorkbook()Return the parent workbookMethods in org.apache.poi.hssf.usermodel with parameters of type HSSFWorkbookModifier and TypeMethodDescriptionstatic HSSFEvaluationWorkbookHSSFEvaluationWorkbook.create(HSSFWorkbook book) static HSSFFormulaEvaluatorHSSFFormulaEvaluator.create(HSSFWorkbook workbook, IStabilityClassifier stabilityClassifier, UDFFinder udfFinder) voidHSSFChart.createBarChart(HSSFWorkbook workbook, HSSFSheet parentSheet) Creates a bar chart.static voidHSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFWorkbook wb) Loops over all cells in all sheets of the supplied workbook.HSSFFont.getHSSFColor(HSSFWorkbook wb) get the color value for the fontstatic voidHSSFOptimiser.optimiseCellStyles(HSSFWorkbook workbook) Goes through the Wokrbook, optimising the cell styles by removing duplicate ones, and ones that aren't used.static voidHSSFOptimiser.optimiseFonts(HSSFWorkbook workbook) Goes through the Workbook, optimising the fonts by removing duplicate ones.protected static StringHSSFConditionalFormattingRule.toFormulaString(Ptg[] parsedExpression, HSSFWorkbook workbook) voidHSSFCellStyle.verifyBelongsToWorkbook(HSSFWorkbook wb) Verifies that this style belongs to the supplied Workbook.Constructors in org.apache.poi.hssf.usermodel with parameters of type HSSFWorkbookModifierConstructorDescriptionEscherGraphics(HSSFShapeGroup escherGroup, HSSFWorkbook workbook, Color forecolor, float verticalPointsPerPixel) Construct an escher graphics object.protectedHSSFBorderFormatting(CFRuleBase cfRuleRecord, HSSFWorkbook workbook) protectedHSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col) Creates new Cell - Should only be called by HSSFRow.protectedHSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col, CellType type) Creates new Cell - Should only be called by HSSFRow.protectedHSSFCell(HSSFWorkbook book, HSSFSheet sheet, CellValueRecordInterface cval) Creates an HSSFCell from a CellValueRecordInterface.protectedHSSFCellStyle(short index, ExtendedFormatRecord rec, HSSFWorkbook workbook) Creates new HSSFCellStyle why would you want to do this??protectedHSSFFontFormatting(CFRuleBase cfRuleRecord, HSSFWorkbook workbook) HSSFFormulaEvaluator(HSSFWorkbook workbook) HSSFFormulaEvaluator(HSSFWorkbook workbook, IStabilityClassifier stabilityClassifier) protectedHSSFPatternFormatting(CFRuleBase cfRuleRecord, HSSFWorkbook workbook) protectedHSSFSheet(HSSFWorkbook workbook) Creates new HSSFSheet - called by HSSFWorkbook to create a sheet from scratch.protectedHSSFSheet(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 HSSFWorkbookModifier and TypeMethodDescriptionstatic voidHSSFRegionUtil.setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.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 leftstatic voidHSSFRegionUtil.setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the borderRight attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the bottomBorderColor attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the leftBorderColor attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the rightBorderColor attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the topBorderColor attribute of the HSSFRegionUtil object