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 modelorg.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 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 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 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, org.w3c.dom.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
Constructors in org.apache.poi.hssf.extractor with parameters of type HSSFWorkbook 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(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 ofPtg
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 Modifier and Type Field Description protected HSSFWorkbook
HSSFSheet. _workbook
Methods in org.apache.poi.hssf.usermodel that return HSSFWorkbook Modifier and Type Method Description static HSSFWorkbook
HSSFWorkbook. create(InternalWorkbook book)
static HSSFWorkbook
HSSFWorkbookFactory. createWorkbook()
Create a new empty Workbookstatic HSSFWorkbook
HSSFWorkbookFactory. createWorkbook(DirectoryNode root)
Creates a HSSFWorkbook from the given DirectoryNodestatic HSSFWorkbook
HSSFWorkbookFactory. createWorkbook(POIFSFileSystem fs)
Creates a HSSFWorkbook from the given NPOIFSFileSystemHSSFWorkbook
HSSFSheet. getWorkbook()
Return the parent workbookMethods 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 fontstatic 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 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, 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.HSSFCell(HSSFWorkbook book, HSSFSheet sheet, CellValueRecordInterface cval)
Creates an HSSFCell from a CellValueRecordInterface.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 Description static void
HSSFRegionUtil. setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic 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 leftstatic void
HSSFRegionUtil. setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the borderRight attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the bottomBorderColor attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the leftBorderColor attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the rightBorderColor attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the topBorderColor attribute of the HSSFRegionUtil object
-