Package | Description |
---|---|
loci.poi.hssf.model |
Provides low level API structures for reading, writing, modifying XLS files.
|
loci.poi.hssf.record |
Record package contains class representations for XLS binary strutures.
|
loci.poi.hssf.record.formula |
formula package contains binary PTG structures used in Formulas
|
loci.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
Modifier and Type | Method and Description |
---|---|
static Workbook |
Workbook.createWorkbook()
Creates an empty workbook object with three blank sheets and all the empty
fields.
|
static Workbook |
Workbook.createWorkbook(java.util.List recs)
read support for low level
API.
|
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
FormulaParser.toFormulaString(Workbook book,
java.util.List lptgs)
Convience method which takes in a list then passes it to the
other toFormulaString signature.
|
static java.lang.String |
FormulaParser.toFormulaString(Workbook book,
Ptg[] ptgs)
Static method to convert an array of Ptgs in RPN order
to a human readable string format in infix mode.
|
Constructor and Description |
---|
FormulaParser(java.lang.String formula,
Workbook book)
Create the formula parser, with the string that is to be
parsed against the supplied workbook.
|
Modifier and Type | Method and Description |
---|---|
java.lang.String |
NameRecord.getAreaReference(Workbook book)
gets the reference , the area only (range)
|
Modifier and Type | Method and Description |
---|---|
java.lang.String |
ArrayPtg.toFormulaString(Workbook book) |
java.lang.String |
RefErrorPtg.toFormulaString(Workbook book) |
java.lang.String |
LessThanPtg.toFormulaString(Workbook book)
Implementation of method from Ptg
|
java.lang.String |
MemFuncPtg.toFormulaString(Workbook book) |
java.lang.String |
AttrPtg.toFormulaString(Workbook book) |
java.lang.String |
RangePtg.toFormulaString(Workbook book)
Implementation of method from Ptg
|
java.lang.String |
Ref3DPtg.toFormulaString(Workbook book) |
java.lang.String |
PercentPtg.toFormulaString(Workbook book)
Implementation of method from Ptg
|
abstract java.lang.String |
Ptg.toFormulaString(Workbook book)
return a string representation of this token alone
|
java.lang.String |
BoolPtg.toFormulaString(Workbook book) |
java.lang.String |
GreaterEqualPtg.toFormulaString(Workbook book) |
java.lang.String |
UnaryMinusPtg.toFormulaString(Workbook book)
Implementation of method from Ptg
|
java.lang.String |
NamePtg.toFormulaString(Workbook book) |
java.lang.String |
NotEqualPtg.toFormulaString(Workbook book) |
java.lang.String |
UnionPtg.toFormulaString(Workbook book)
Implementation of method from Ptg
|
java.lang.String |
MultiplyPtg.toFormulaString(Workbook book) |
java.lang.String |
AddPtg.toFormulaString(Workbook book)
Implementation of method from Ptg
|
java.lang.String |
ConcatPtg.toFormulaString(Workbook book) |
java.lang.String |
AreaPtg.toFormulaString(Workbook book) |
java.lang.String |
AreaErrPtg.toFormulaString(Workbook book) |
java.lang.String |
RefNPtg.toFormulaString(Workbook book) |
java.lang.String |
PowerPtg.toFormulaString(Workbook book) |
java.lang.String |
AreaNVPtg.toFormulaString(Workbook book) |
java.lang.String |
Area3DPtg.toFormulaString(Workbook book) |
java.lang.String |
IntPtg.toFormulaString(Workbook book) |
java.lang.String |
RefNAPtg.toFormulaString(Workbook book) |
java.lang.String |
ErrPtg.toFormulaString(Workbook book) |
java.lang.String |
AbstractFunctionPtg.toFormulaString(Workbook book) |
java.lang.String |
EqualPtg.toFormulaString(Workbook book) |
java.lang.String |
ExpPtg.toFormulaString(Workbook book) |
java.lang.String |
GreaterThanPtg.toFormulaString(Workbook book)
Implementation of method from Ptg
|
java.lang.String |
AreaNAPtg.toFormulaString(Workbook book) |
java.lang.String |
RefNVPtg.toFormulaString(Workbook book) |
java.lang.String |
DividePtg.toFormulaString(Workbook book) |
java.lang.String |
NumberPtg.toFormulaString(Workbook book) |
java.lang.String |
AreaNPtg.toFormulaString(Workbook book) |
java.lang.String |
SubtractPtg.toFormulaString(Workbook book) |
java.lang.String |
MemErrPtg.toFormulaString(Workbook book) |
java.lang.String |
MissingArgPtg.toFormulaString(Workbook book) |
java.lang.String |
LessEqualPtg.toFormulaString(Workbook book) |
java.lang.String |
ReferencePtg.toFormulaString(Workbook book) |
java.lang.String |
NameXPtg.toFormulaString(Workbook book) |
java.lang.String |
IntersectionPtg.toFormulaString(Workbook book)
Implementation of method from Ptg
|
java.lang.String |
UnknownPtg.toFormulaString(Workbook book) |
java.lang.String |
StringPtg.toFormulaString(Workbook book) |
java.lang.String |
ParenthesisPtg.toFormulaString(Workbook book) |
java.lang.String |
UnaryPlusPtg.toFormulaString(Workbook book)
Implementation of method from Ptg
|
java.lang.String |
MemAreaPtg.toFormulaString(Workbook book) |
Constructor and Description |
---|
NamePtg(java.lang.String name,
Workbook book)
Creates new NamePtg
|
Modifier and Type | Field and Description |
---|---|
protected Workbook |
HSSFSheet.book |
Modifier and Type | Method and Description |
---|---|
protected Workbook |
HSSFCell.getBoundWorkbook()
Returns the Workbook that this Cell is bound to
|
protected Workbook |
HSSFWorkbook.getWorkbook() |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
HSSFCellStyle.getDataFormatString(Workbook workbook)
Get the contents of the format string, by looking up
the DataFormat against the supplied workbook
|
Constructor and Description |
---|
HSSFCell(Workbook book,
Sheet sheet,
int row,
CellValueRecordInterface cval)
Creates an HSSFCell from a CellValueRecordInterface.
|
HSSFCell(Workbook book,
Sheet sheet,
int row,
short col)
Creates new Cell - Should only be called by HSSFRow.
|
HSSFCell(Workbook book,
Sheet sheet,
int row,
short col,
int type)
Creates new Cell - Should only be called by HSSFRow.
|
HSSFDataFormat(Workbook workbook)
Construncts a new data formatter.
|
HSSFName(Workbook book,
NameRecord name)
Creates new HSSFName - called by HSSFWorkbook to create a sheet from
scratch.
|
HSSFRow(Workbook book,
Sheet sheet,
int rowNum)
Creates new HSSFRow from scratch.
|
HSSFRow(Workbook book,
Sheet sheet,
RowRecord record)
Creates an HSSFRow from a low level RowRecord object.
|
HSSFWorkbook(Workbook book) |
Copyright © 2014 Open Microscopy Environment