Package | Description |
---|---|
org.zkoss.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
Related Documentation
For overviews, tutorials, examples, guides, and tool documentation, please see:
Apache POI Project
|
org.zkoss.poi.ss.format |
This package contains classes that implement cell formatting
|
org.zkoss.poi.ss.usermodel | |
org.zkoss.poi.ss.util | |
org.zkoss.poi.ss.util.cellwalk | |
org.zkoss.poi.xssf.streaming | |
org.zkoss.poi.xssf.usermodel | |
org.zkoss.zss.range.impl.imexp |
ZK Spreadsheet Internal Range API Implementation classes.
|
Modifier and Type | Class and Description |
---|---|
class |
HSSFCell
High level representation of a cell in a row of a spreadsheet.
|
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<Cell> |
HSSFRow.cellIterator() |
Modifier and Type | Method and Description |
---|---|
CellValue |
HSSFFormulaEvaluator.evaluate(Cell cell)
If cell contains a formula, the formula is evaluated and returned,
else the CellValue simply copies the appropriate cell value from
the cell and also its cell type.
|
int |
HSSFFormulaEvaluator.evaluateFormulaCell(Cell cell)
If cell contains formula, it evaluates the formula, and saves the result of the formula.
|
HSSFCell |
HSSFFormulaEvaluator.evaluateInCell(Cell cell)
If cell contains formula, it evaluates the formula, and
puts the formula result back into the cell, in place
of the old formula.
|
void |
HSSFFormulaEvaluator.notifyDeleteCell(Cell cell) |
void |
HSSFFormulaEvaluator.notifySetFormula(Cell cell)
Should be called to tell the cell value cache that the specified (value or formula) cell
has changed.
|
void |
HSSFFormulaEvaluator.notifyUpdateCell(Cell cell) |
CellRange<HSSFCell> |
HSSFSheet.removeArrayFormula(Cell cell) |
void |
HSSFRow.removeCell(Cell cell)
remove the HSSFCell from this row.
|
Modifier and Type | Method and Description |
---|---|
CellFormatResult |
CellFormat.apply(Cell c)
Fetches the appropriate value from the cell, and returns the result of
applying it to the appropriate format.
|
CellFormatResult |
CellFormat.apply(javax.swing.JLabel label,
Cell c)
Fetches the appropriate value from the cell, and uses the result, setting
the text and color of a label before returning the result.
|
static int |
CellFormat.ultimateType(Cell cell)
Returns the ultimate cell type, following the results of formulas.
|
Modifier and Type | Interface and Description |
---|---|
interface |
CellRange<C extends Cell>
Represents a rectangular region of a
Sheet |
Modifier and Type | Method and Description |
---|---|
Cell |
Row.createCell(int column)
Use this to create new cells within the row and return it.
|
Cell |
Row.createCell(int column,
int type)
Use this to create new cells within the row and return it.
|
Cell |
FormulaEvaluator.evaluateInCell(Cell cell)
If cell contains formula, it evaluates the formula, and
puts the formula result back into the cell, in place
of the old formula.
|
Cell |
Row.getCell(int cellnum)
Get the cell representing a given column (logical cell) 0-based.
|
Cell |
Row.getCell(int cellnum,
Row.MissingCellPolicy policy)
Returns the cell at the given (0 based) index, with the specified
Row.MissingCellPolicy |
C[][] |
CellRange.getCells() |
C[] |
CellRange.getFlattenedCells() |
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<Cell> |
Row.cellIterator() |
CellRange<? extends Cell> |
Sheet.removeArrayFormula(Cell cell)
Remove a Array Formula from this sheet.
|
CellRange<? extends Cell> |
Sheet.setArrayFormula(java.lang.String formula,
CellRangeAddress range)
Sets array formula to specified region for result.
|
Modifier and Type | Method and Description |
---|---|
java.text.Format |
DataFormatter.createFormat(Cell cell)
Create and return a Format based on the format string from a cell's
style.
|
CellValue |
FormulaEvaluator.evaluate(Cell cell)
If cell contains a formula, the formula is evaluated and returned,
else the CellValue simply copies the appropriate cell value from
the cell and also its cell type.
|
int |
FormulaEvaluator.evaluateFormulaCell(Cell cell)
If cell contains formula, it evaluates the formula,
and saves the result of the formula.
|
Cell |
FormulaEvaluator.evaluateInCell(Cell cell)
If cell contains formula, it evaluates the formula, and
puts the formula result back into the cell, in place
of the old formula.
|
java.lang.String |
DataFormatter.formatCellValue(Cell cell)
Returns the formatted value of a cell as a String regardless
of the cell type.
|
java.lang.String |
DataFormatter.formatCellValue(Cell cell,
FormulaEvaluator evaluator)
Returns the formatted value of a cell as a String regardless
of the cell type.
|
java.lang.String |
DataFormatter.formatCellValue(Cell cell,
int cellType) |
java.text.Format |
DataFormatter.getDefaultFormat(Cell cell)
Returns a default format for a cell.
|
static java.text.Format |
DataFormatter.getJavaFormat(Cell cell,
java.util.Locale locale) |
static boolean |
DateUtil.isCellDateFormatted(Cell cell)
Check if a cell contains a date
Since dates are stored internally in Excel as double values
we infer it is a date if it is formatted as such.
|
static boolean |
DateUtil.isCellInternalDateFormatted(Cell cell)
Check if a cell contains a date, checking only for internal
excel date formats.
|
void |
FormulaEvaluator.notifyDeleteCell(Cell cell)
Should be called to tell the cell value cache that the specified cell has just become a
formula cell, or the formula text has changed
|
void |
FormulaEvaluator.notifySetFormula(Cell cell)
Should be called to tell the cell value cache that the specified (value or formula) cell
has changed.
|
void |
FormulaEvaluator.notifyUpdateCell(Cell cell)
Should be called to tell the cell value cache that the specified (value or formula) cell
has changed.
|
CellRange<? extends Cell> |
Sheet.removeArrayFormula(Cell cell)
Remove a Array Formula from this sheet.
|
void |
Row.removeCell(Cell cell)
Remove the Cell from this row.
|
Modifier and Type | Class and Description |
---|---|
class |
SSCellRange<K extends Cell>
For POI internal use only
|
Modifier and Type | Method and Description |
---|---|
static <B extends Cell> |
SSCellRange.create(int firstRow,
int firstColumn,
int height,
int width,
java.util.List<B> flattenedList,
java.lang.Class<B> cellClass) |
Modifier and Type | Method and Description |
---|---|
static Cell |
CellUtil.createCell(Row row,
int column,
java.lang.String value)
Create a cell, and give it a value.
|
static Cell |
CellUtil.createCell(Row row,
int column,
java.lang.String value,
CellStyle style)
Creates a cell, gives it a value, and applies a style if provided
|
static Cell |
CellUtil.getCell(Row row,
int columnIndex)
Get a specific cell from a row.
|
K[][] |
SSCellRange.getCells() |
K[] |
SSCellRange.getFlattenedCells() |
static Cell |
CellUtil.translateUnicodeValues(Cell cell)
Looks for text in the cell that should be unicode, like α and provides the
unicode version of it.
|
Modifier and Type | Method and Description |
---|---|
static double |
SheetUtil.getCellWidth(Cell cell,
int defaultCharWidth,
DataFormatter formatter,
boolean useMergedCells)
Compute width of a single cell
|
static void |
CellUtil.setAlignment(Cell cell,
Workbook workbook,
short align)
Take a cell, and align it.
|
static void |
CellUtil.setCellStyleProperty(Cell cell,
Workbook workbook,
java.lang.String propertyName,
java.lang.Object propertyValue)
This method attempt to find an already existing CellStyle that matches what you want the
style to be.
|
static void |
CellUtil.setFont(Cell cell,
Workbook workbook,
Font font)
Take a cell, and apply a font to it
|
static Cell |
CellUtil.translateUnicodeValues(Cell cell)
Looks for text in the cell that should be unicode, like α and provides the
unicode version of it.
|
Constructor and Description |
---|
CellReference(Cell cell) |
Modifier and Type | Method and Description |
---|---|
void |
CellHandler.onCell(Cell cell,
CellWalkContext ctx) |
Modifier and Type | Class and Description |
---|---|
class |
SXSSFCell
Streaming version of XSSFRow implementing the "BigGridDemo" strategy.
|
Modifier and Type | Method and Description |
---|---|
Cell |
SXSSFRow.createCell(int column)
Use this to create new cells within the row and return it.
|
Cell |
SXSSFRow.createCell(int column,
int type)
Use this to create new cells within the row and return it.
|
Cell |
SXSSFRow.getCell(int cellnum)
Get the cell representing a given column (logical cell) 0-based.
|
Cell |
SXSSFRow.getCell(int cellnum,
Row.MissingCellPolicy policy)
Returns the cell at the given (0 based) index, with the specified
Row.MissingCellPolicy |
Cell |
SXSSFRow.FilledCellIterator.next() |
Cell |
SXSSFRow.CellIterator.next() |
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<Cell> |
SXSSFRow.allCellsIterator() |
java.util.Iterator<Cell> |
SXSSFRow.cellIterator() |
java.util.Iterator<Cell> |
SXSSFRow.iterator() |
CellRange<? extends Cell> |
SXSSFSheet.removeArrayFormula(Cell cell)
Remove a Array Formula from this sheet.
|
CellRange<? extends Cell> |
SXSSFSheet.setArrayFormula(java.lang.String formula,
CellRangeAddress range)
Sets array formula to specified region for result.
|
Modifier and Type | Method and Description |
---|---|
CellRange<? extends Cell> |
SXSSFSheet.removeArrayFormula(Cell cell)
Remove a Array Formula from this sheet.
|
void |
SXSSFRow.removeCell(Cell cell)
Remove the Cell from this row.
|
void |
SheetDataWriter.writeCell(int columnIndex,
Cell cell) |
Modifier and Type | Class and Description |
---|---|
class |
XSSFCell
High level representation of a cell in a row of a spreadsheet.
|
Modifier and Type | Method and Description |
---|---|
java.util.Iterator<Cell> |
XSSFRow.cellIterator()
Cell iterator over the physically defined cells:
for (Iterator
|
java.util.Iterator<Cell> |
XSSFRow.iterator()
Alias for
XSSFRow.cellIterator() to allow foreach loops:
for(Cell cell : row){
...
}
|
Modifier and Type | Method and Description |
---|---|
CellValue |
XSSFFormulaEvaluator.evaluate(Cell cell)
If cell contains a formula, the formula is evaluated and returned,
else the CellValue simply copies the appropriate cell value from
the cell and also its cell type.
|
int |
XSSFFormulaEvaluator.evaluateFormulaCell(Cell cell)
If cell contains formula, it evaluates the formula,
and saves the result of the formula.
|
XSSFCell |
XSSFFormulaEvaluator.evaluateInCell(Cell cell)
If cell contains formula, it evaluates the formula, and
puts the formula result back into the cell, in place
of the old formula.
|
void |
XSSFFormulaEvaluator.notifyDeleteCell(Cell cell) |
void |
XSSFFormulaEvaluator.notifySetFormula(Cell cell) |
void |
XSSFFormulaEvaluator.notifyUpdateCell(Cell cell) |
CellRange<XSSFCell> |
XSSFSheet.removeArrayFormula(Cell cell) |
void |
XSSFRow.removeCell(Cell cell)
Remove the Cell from this row.
|
Modifier and Type | Method and Description |
---|---|
protected Font |
AbstractExcelImporter.getPoiFontFromRichText(Workbook book,
Cell cell,
RichTextString rstr,
int run) |
protected SCell |
AbstractExcelImporter.importCell(Cell poiCell,
int row,
SSheet sheet) |
protected void |
AbstractExcelImporter.importRichText(Cell poiCell,
RichTextString poiRichTextString,
SRichText richText) |
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.