Package | Description |
---|---|
org.zkoss.poi.hssf.converter | |
org.zkoss.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.zkoss.poi.hssf.util |
util package contains tools needed for writing HSSF files that are not necesarily "real"
HSSF concepts.
|
Modifier and Type | Method and Description |
---|---|
protected boolean |
AbstractExcelConverter.isTextEmpty(HSSFCell cell) |
protected boolean |
ExcelToHtmlConverter.processCell(HSSFCell cell,
Element tableCellElement,
int normalWidthPx,
int maxSpannedWidthPx,
float normalHeightPt) |
protected boolean |
ExcelToFoConverter.processCell(HSSFWorkbook workbook,
HSSFCell cell,
Element tableCellElement,
int normalWidthPx,
int maxSpannedWidthPx,
float normalHeightPt) |
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 |
---|---|
CellRange<HSSFCell> |
HSSFSheet.removeArrayFormula(Cell cell) |
CellRange<HSSFCell> |
HSSFSheet.setArrayFormula(String formula,
CellRangeAddress range) |
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,
String value)
Create a cell, and give it a value.
|
static HSSFCell |
HSSFCellUtil.createCell(HSSFRow row,
int column,
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,
String propertyName,
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 © 2020. All rights reserved.