|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
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 |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |