Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.hssf.usermodel.contrib |
Modifier and Type | Method and Description |
---|---|
HSSFCell |
HSSFRow.createCell(int column)
Use this to create new cells within the row and return it.
|
HSSFCell |
HSSFRow.createCell(int columnIndex,
int type)
Use this to create new cells within the row and return it.
|
HSSFCell |
HSSFRow.createCell(short columnIndex)
Deprecated.
(Aug 2008) use
HSSFRow.createCell(int) |
HSSFCell |
HSSFRow.createCell(short columnIndex,
int type)
Deprecated.
(Aug 2008) use
HSSFRow.createCell(int, int) |
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.
|
HSSFCell |
HSSFRow.getCell(int cellnum)
Get the hssfcell representing a given column (logical cell)
0-based.
|
HSSFCell |
HSSFRow.getCell(int cellnum,
Row.MissingCellPolicy policy)
Get the hssfcell representing a given column (logical cell)
0-based.
|
HSSFCell |
HSSFRow.getCell(short cellnum)
Deprecated.
(Aug 2008) use
HSSFRow.getCell(int) |
Modifier and Type | Method and Description |
---|---|
void |
HSSFRow.moveCell(HSSFCell cell,
short newColumn)
Moves the supplied cell to a new column, which
must not already have a cell there!
|
void |
HSSFFormulaEvaluator.notifyDeleteCell(HSSFCell cell)
Should be called to tell the cell value cache that the specified cell has just been
deleted.
|
void |
HSSFFormulaEvaluator.notifyUpdateCell(HSSFCell cell)
Should be called to tell the cell value cache that the specified (value or formula) cell
has changed.
|
Modifier and Type | Method and Description |
---|---|
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 columnIndex)
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.
|
Modifier and Type | Method and Description |
---|---|
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.
|
Copyright 2014 The Apache Software Foundation or its licensors, as applicable.