|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use HSSFCell | |
---|---|
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 HSSFCell in org.apache.poi.hssf.usermodel |
---|
Methods in org.apache.poi.hssf.usermodel that return HSSFCell | |
---|---|
HSSFCell |
HSSFRow.createCell(short column)
Use this to create new cells within the row and return it. |
HSSFCell |
HSSFRow.createCell(short column,
int type)
Use this to create new cells within the row and return it. |
protected HSSFCell |
HSSFRow.createCellFromRecord(CellValueRecordInterface cell)
create a high level HSSFCell object from an existing low level record. |
HSSFCell |
HSSFFormulaEvaluator.evaluateInCell(HSSFCell cell)
If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula. |
HSSFCell |
HSSFRow.getCell(int cellnum)
Get the hssfcell representing a given column (logical cell) 0-based. |
HSSFCell |
HSSFRow.getCell(int cellnum,
HSSFRow.MissingCellPolicy policy)
Get the hssfcell representing a given column (logical cell) 0-based. |
HSSFCell |
HSSFRow.getCell(short cellnum)
Get the hssfcell representing a given column (logical cell) 0-based. |
Methods in org.apache.poi.hssf.usermodel with parameters of type HSSFCell | |
---|---|
HSSFFormulaEvaluator.CellValue |
HSSFFormulaEvaluator.evaluate(HSSFCell 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(HSSFCell cell)
If cell contains formula, it evaluates the formula, and saves the result of the formula. |
HSSFCell |
HSSFFormulaEvaluator.evaluateInCell(HSSFCell cell)
If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula. |
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. |
static boolean |
HSSFDateUtil.isCellDateFormatted(HSSFCell 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 |
HSSFDateUtil.isCellInternalDateFormatted(HSSFCell cell)
Check if a cell contains a date, checking only for internal excel date formats. |
void |
HSSFRow.moveCell(HSSFCell cell,
short newColumn)
Moves the supplied cell to a new column, which must not already have a cell there! |
void |
HSSFRow.removeCell(HSSFCell cell)
remove the HSSFCell from this row. |
Uses of HSSFCell in org.apache.poi.hssf.usermodel.contrib |
---|
Methods in org.apache.poi.hssf.usermodel.contrib that return HSSFCell | |
---|---|
static HSSFCell |
HSSFCellUtil.createCell(HSSFRow row,
int column,
java.lang.String value)
Create a cell, and give it a value. |
static HSSFCell |
HSSFCellUtil.createCell(HSSFRow row,
int column,
java.lang.String value,
HSSFCellStyle style)
Creates a cell, gives it a value, and applies a style if provided |
static HSSFCell |
HSSFCellUtil.getCell(HSSFRow row,
int column)
Get a specific cell from a row. |
static HSSFCell |
HSSFCellUtil.translateUnicodeValues(HSSFCell cell)
Looks for text in the cell that should be unicode, like α and provides the unicode version of it. |
Methods in org.apache.poi.hssf.usermodel.contrib with parameters of type HSSFCell | |
---|---|
static void |
HSSFCellUtil.setAlignment(HSSFCell cell,
HSSFWorkbook workbook,
short align)
Take a cell, and align it. |
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 HSSFCell |
HSSFCellUtil.translateUnicodeValues(HSSFCell cell)
Looks for text in the cell that should be unicode, like α and provides the unicode version of it. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |