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

Packages that use HSSFWorkbook
org.apache.poi.hssf.contrib.view   
org.apache.poi.hssf.dev DEV package serves two purposes. 
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.record Record package contains class representations for XLS binary strutures. 
org.apache.poi.hssf.record.formula formula package contains binary PTG structures used in Formulas 
org.apache.poi.hssf.record.formula.functions   
org.apache.poi.hssf.usermodel usermodel package maps HSSF low level strutures to familiar workbook/sheet model 
org.apache.poi.hssf.usermodel.contrib   
 

Uses of HSSFWorkbook in org.apache.poi.hssf.contrib.view
 

Constructors in org.apache.poi.hssf.contrib.view with parameters of type HSSFWorkbook
SViewerPanel(HSSFWorkbook wb, boolean allowEdits)
          Construct the representation of the workbook
SVTableCellEditor(HSSFWorkbook wb)
           
SVTableCellRenderer(HSSFWorkbook wb)
           
 

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

Fields in org.apache.poi.hssf.dev declared as HSSFWorkbook
protected  HSSFWorkbook HSSF.hssfworkbook
           
 

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[] FormulaParser.parse(java.lang.String formula, HSSFWorkbook book)
           
static java.lang.String FormulaParser.toFormulaString(HSSFWorkbook book, java.util.List lptgs)
          Convenience method which takes in a list then passes it to the other toFormulaString signature.
static java.lang.String FormulaParser.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.
 

Constructors in org.apache.poi.hssf.model with parameters of type HSSFWorkbook
FormulaParser(java.lang.String formula, HSSFWorkbook book)
          Create the formula parser, with the string that is to be parsed against the supplied workbook.
 

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

Methods in org.apache.poi.hssf.record with parameters of type HSSFWorkbook
static CFRuleRecord CFRuleRecord.create(HSSFWorkbook workbook, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2)
          Creates a new comparison operation rule
static CFRuleRecord CFRuleRecord.create(HSSFWorkbook workbook, java.lang.String formulaText)
          Creates a new comparison operation rule
 java.lang.String NameRecord.getAreaReference(HSSFWorkbook book)
          gets the reference , the area only (range)
 

Uses of HSSFWorkbook in org.apache.poi.hssf.record.formula
 

Methods in org.apache.poi.hssf.record.formula with parameters of type HSSFWorkbook
 java.lang.String ValueOperatorPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String UnknownPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String UnionPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String StringPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String RefPtgBase.toFormulaString(HSSFWorkbook book)
           
 java.lang.String RefErrorPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String Ref3DPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String RangePtg.toFormulaString(HSSFWorkbook book)
           
abstract  java.lang.String Ptg.toFormulaString(HSSFWorkbook book)
          return a string representation of this token alone
 java.lang.String ParenthesisPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String NumberPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String NameXPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String NamePtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String MissingArgPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String MemFuncPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String MemErrPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String MemAreaPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String IntPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String IntersectionPtg.toFormulaString(HSSFWorkbook book)
          Implementation of method from Ptg
 java.lang.String ExpPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String ErrPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String DeletedRef3DPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String DeletedArea3DPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String BoolPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String AttrPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String ArrayPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String AreaPtgBase.toFormulaString(HSSFWorkbook book)
           
 java.lang.String AreaErrPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String Area3DPtg.toFormulaString(HSSFWorkbook book)
           
 java.lang.String AbstractFunctionPtg.toFormulaString(HSSFWorkbook book)
           
 

Constructors in org.apache.poi.hssf.record.formula with parameters of type HSSFWorkbook
NamePtg(java.lang.String name, HSSFWorkbook book)
          Creates new NamePtg and sets its name index to that of the corresponding defined name record in the workbook.
 

Uses of HSSFWorkbook in org.apache.poi.hssf.record.formula.functions
 

Methods in org.apache.poi.hssf.record.formula.functions with parameters of type HSSFWorkbook
 ValueEval Offset.evaluate(Eval[] args, int srcCellRow, short srcCellCol, HSSFWorkbook workbook, HSSFSheet sheet)
           
 ValueEval Indirect.evaluate(Eval[] args, int srcCellRow, short srcCellCol, HSSFWorkbook workbook, HSSFSheet sheet)
           
 ValueEval FreeRefFunction.evaluate(Eval[] args, int srcCellRow, short srcCellCol, HSSFWorkbook workbook, HSSFSheet sheet)
           
 

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

Fields in org.apache.poi.hssf.usermodel declared as HSSFWorkbook
protected  HSSFWorkbook HSSFSheet.workbook
           
protected  HSSFWorkbook HSSFFormulaEvaluator.workbook
           
 

Methods in org.apache.poi.hssf.usermodel with parameters of type HSSFWorkbook
 void HSSFChart.createBarChart(HSSFWorkbook workbook, HSSFSheet sheet)
          Creates a bar chart.
static void HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFWorkbook wb)
          Loops over all cells in all sheets of the supplied workbook.
static AreaEval HSSFFormulaEvaluator.evaluateArea3dPtg(HSSFWorkbook workbook, Area3DPtg a3dp)
           
static AreaEval HSSFFormulaEvaluator.evaluateAreaPtg(HSSFSheet sheet, HSSFWorkbook workbook, AreaPtg ap)
           
protected static ValueEval HSSFFormulaEvaluator.getEvalForCell(HSSFCell cell, HSSFRow row, HSSFSheet sheet, HSSFWorkbook workbook)
          Given a cell, find its type and from that create an appropriate ValueEval impl instance and return that.
 HSSFFont HSSFCellStyle.getFont(HSSFWorkbook parentWorkbook)
          gets the font for this style
static FormulaParser HSSFFormulaEvaluator.getUnderlyingParser(HSSFWorkbook workbook, java.lang.String formula)
          Returns an underlying FormulaParser, for the specified Formula String and HSSFWorkbook.
 

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.
HSSFCell(HSSFWorkbook book, Sheet sheet, int row, CellValueRecordInterface cval)
          Creates an HSSFCell from a CellValueRecordInterface.
HSSFCell(HSSFWorkbook book, Sheet sheet, int row, short col)
          Creates new Cell - Should only be called by HSSFRow.
HSSFCell(HSSFWorkbook book, Sheet sheet, int row, short col, int 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??
HSSFFormulaEvaluator(HSSFSheet sheet, HSSFWorkbook workbook)
           
HSSFName(HSSFWorkbook book, NameRecord name)
          Creates new HSSFName - called by HSSFWorkbook to create a sheet from scratch.
HSSFSheet(HSSFWorkbook workbook)
          Creates new HSSFSheet - called by HSSFWorkbook to create a sheet from scratch.
HSSFSheet(HSSFWorkbook workbook, Sheet sheet)
          Creates an HSSFSheet representing the given Sheet object.
 

Uses of HSSFWorkbook in org.apache.poi.hssf.usermodel.contrib
 

Methods in org.apache.poi.hssf.usermodel.contrib with parameters of type HSSFWorkbook
static void HSSFCellUtil.setAlignment(HSSFCell cell, HSSFWorkbook workbook, short align)
          Take a cell, and align it.
static void HSSFRegionUtil.setBorderBottom(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook)
          Sets the borderBottom attribute of the HSSFRegionUtil object
static void HSSFRegionUtil.setBorderLeft(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook)
          Sets the left border for a region of cells by manipulating the cell style of the indidual cells on the left
static void HSSFRegionUtil.setBorderRight(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook)
          Sets the borderRight attribute of the HSSFRegionUtil object
static void HSSFRegionUtil.setBorderTop(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook)
          Sets the borderBottom attribute of the HSSFRegionUtil object
static void HSSFRegionUtil.setBottomBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook)
          Sets the bottomBorderColor attribute of the HSSFRegionUtil object
static void HSSFCellUtil.setCellStyleProperty(HSSFCell cell, HSSFWorkbook workbook, java.lang.String propertyName, java.lang.Object propertyValue)
          This method attempt to find an already existing HSSFCellStyle that matches what you want the style to be.
static void HSSFCellUtil.setFont(HSSFCell cell, HSSFWorkbook workbook, HSSFFont font)
          Take a cell, and apply a font to it
static void HSSFRegionUtil.setLeftBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook)
          Sets the leftBorderColor attribute of the HSSFRegionUtil object
static void HSSFRegionUtil.setRightBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook)
          Sets the rightBorderColor attribute of the HSSFRegionUtil object
static void HSSFRegionUtil.setTopBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook)
          Sets the topBorderColor attribute of the HSSFRegionUtil object
 



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