Package | Description |
---|---|
org.zkoss.poi.hssf.converter | |
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.usermodel | |
org.zkoss.poi.ss.util | |
org.zkoss.poi.xssf.streaming | |
org.zkoss.poi.xssf.usermodel | |
org.zkoss.poi.xssf.usermodel.helpers | |
org.zkoss.zss.range.impl.imexp |
ZK Spreadsheet Internal Range API Implementation classes.
|
Modifier and Type | Method and Description |
---|---|
protected boolean |
ExcelToFoConverter.isEmptyStyle(CellStyle cellStyle)
Returns false if cell style by itself (without text, i.e.
|
Modifier and Type | Class and Description |
---|---|
class |
HSSFCellStyle
High level representation of the style of a cell in a sheet of a workbook.
|
class |
HSSFNamedStyle |
Modifier and Type | Method and Description |
---|---|
java.util.List<CellStyle> |
HSSFWorkbook.getDefaultCellStyles() |
Modifier and Type | Method and Description |
---|---|
void |
HSSFWorkbook.addDefaultCellStyle(CellStyle cellStyle) |
void |
HSSFNamedStyle.cloneStyleFrom(CellStyle source) |
void |
HSSFCellStyle.cloneStyleFrom(CellStyle source)
Clones all the style information from another
HSSFCellStyle, onto this one.
|
void |
HSSFCell.setCellStyle(CellStyle style)
set the style for the cell.
|
void |
HSSFSheet.setDefaultColumnStyle(int column,
CellStyle style)
Sets the default column style for a given column.
|
void |
HSSFRow.setRowStyle(CellStyle style)
Applies a whole-row cell styling to the row.
|
Constructor and Description |
---|
HSSFNamedStyle(StyleRecord rec,
StyleExtRecord rec2,
CellStyle inner) |
Modifier and Type | Interface and Description |
---|---|
interface |
DxfCellStyle
Cell style for Dxfs
|
interface |
NamedStyle
CellStyle with a name.
|
Modifier and Type | Method and Description |
---|---|
CellStyle |
Workbook.createCellStyle()
Create a new Cell style and add it to the workbook's style table
|
CellStyle |
Cell.getCellStyle()
Return the cell's style.
|
CellStyle |
Workbook.getCellStyleAt(int idx)
Get the cell style object at the given index
Note since 3.9.9 we have changed the return value type from short to int because the limit of
distinct cell style in Excel 2007's is 64000 while that of Excel 97-2003 is 4000
only; have to extend it to accommodate the capacity.
|
CellStyle |
Sheet.getColumnStyle(int column)
Returns the CellStyle that applies to the given
(0 based) column, or null if no style has been
set for that column
|
CellStyle |
Row.getRowStyle()
Returns the whole-row cell styles.
|
Modifier and Type | Method and Description |
---|---|
java.util.List<CellStyle> |
Workbook.getDefaultCellStyles() |
Modifier and Type | Method and Description |
---|---|
void |
Workbook.addDefaultCellStyle(CellStyle cellStyle) |
void |
CellStyle.cloneStyleFrom(CellStyle source)
Clones all the style information from another
CellStyle, onto this one.
|
void |
Cell.setCellStyle(CellStyle style)
Set the style for the cell.
|
void |
Sheet.setDefaultColumnStyle(int column,
CellStyle style)
Sets the default column style for a given column.
|
void |
Row.setRowStyle(CellStyle style)
Applies a whole-row cell styling to the row.
|
Modifier and Type | Method and Description |
---|---|
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
|
Modifier and Type | Method and Description |
---|---|
CellStyle |
SXSSFWorkbook.createCellStyle()
Create a new Cell style and add it to the workbook's style table
|
CellStyle |
SXSSFCell.getCellStyle()
Return the cell's style.
|
CellStyle |
SXSSFWorkbook.getCellStyleAt(int idx)
Get the cell style object at the given index
|
CellStyle |
SXSSFSheet.getColumnStyle(int column)
Returns the CellStyle that applies to the given
(0 based) column, or null if no style has been
set for that column
|
CellStyle |
SXSSFRow.getRowStyle()
Returns the whole-row cell style.
|
Modifier and Type | Method and Description |
---|---|
java.util.List<CellStyle> |
SXSSFWorkbook.getDefaultCellStyles() |
Modifier and Type | Method and Description |
---|---|
void |
SXSSFWorkbook.addDefaultCellStyle(CellStyle cellStyle) |
void |
SXSSFCell.setCellStyle(CellStyle style)
Set the style for the cell.
|
void |
SXSSFSheet.setDefaultColumnStyle(int column,
CellStyle style)
Sets the default column style for a given column.
|
void |
SXSSFRow.setRowStyle(CellStyle style)
Applies a whole-row cell styling to the row.
|
Modifier and Type | Class and Description |
---|---|
class |
XSSFCellStyle
High level representation of the the possible formatting information for the contents of the cells on a sheet in a
SpreadsheetML document.
|
class |
XSSFDxfCellStyle
Cell style for Dxfs
|
class |
XSSFNamedStyle |
Modifier and Type | Method and Description |
---|---|
CellStyle |
XSSFWorkbook.createDefaultCellStyle(XSSFCellBorder border,
XSSFCellFill fill,
XSSFFont font,
int numFmtId) |
CellStyle |
XSSFSheet.getColumnStyle(int column)
Returns the CellStyle that applies to the given
(0 based) column, or null if no style has been
set for that column
|
Modifier and Type | Method and Description |
---|---|
java.util.List<CellStyle> |
XSSFWorkbook.getDefaultCellStyles() |
Modifier and Type | Method and Description |
---|---|
void |
XSSFWorkbook.addDefaultCellStyle(CellStyle cellStyle) |
void |
XSSFNamedStyle.cloneStyleFrom(CellStyle source) |
void |
XSSFDxfCellStyle.cloneStyleFrom(CellStyle source) |
void |
XSSFCellStyle.cloneStyleFrom(CellStyle source)
Clones all the style information from another
XSSFCellStyle, onto this one.
|
void |
XSSFCell.setCellStyle(CellStyle style)
Set the style for the cell.
|
void |
XSSFSheet.setDefaultColumnStyle(int column,
CellStyle style) |
void |
XSSFRow.setRowStyle(CellStyle style)
Applies a whole-row cell styling to the row.
|
Modifier and Type | Method and Description |
---|---|
void |
ColumnHelper.setColDefaultStyle(long index,
CellStyle style) |
Modifier and Type | Field and Description |
---|---|
protected java.util.Map<CellStyle,SCellStyle> |
AbstractExcelImporter.importedStyle
SCellStyle object> Keep track of imported
style during importing to avoid creating duplicated style objects. |
protected java.util.Map<SCellStyle,CellStyle> |
AbstractExcelExporter.styleTable
The map stores the exported
CellStyle during exporting, so that
we can reuse them for exporting other cells. |
Modifier and Type | Method and Description |
---|---|
protected CellStyle |
AbstractExcelExporter.toPOICellStyle(SCellStyle cellStyle) |
protected CellStyle |
ExcelXlsxExporter.toPOIDefaultCellStyle(SCellStyle cellStyle) |
protected CellStyle |
AbstractExcelExporter.toPOIDefaultCellStyle(SCellStyle cellStyle) |
Modifier and Type | Method and Description |
---|---|
protected SCellStyle |
AbstractExcelImporter.importCellStyle(CellStyle poiCellStyle)
Convert CellStyle into NCellStyle
|
protected SCellStyle |
AbstractExcelImporter.importCellStyle(CellStyle poiCellStyle,
boolean inStyleTable) |
protected SFont |
ExcelXlsxImporter.importFont(CellStyle poiCellStyle) |
protected SFont |
AbstractExcelImporter.importFont(CellStyle poiCellStyle) |
static void |
BookHelper.setBottomBorderColor(CellStyle style,
Color color) |
static void |
BookHelper.setFillBackgroundColor(CellStyle newCellStyle,
Color xlsColor) |
static void |
BookHelper.setFillForegroundColor(CellStyle newCellStyle,
Color xlsColor) |
static void |
BookHelper.setLeftBorderColor(CellStyle style,
Color color) |
static void |
BookHelper.setRightBorderColor(CellStyle style,
Color color) |
static void |
BookHelper.setTopBorderColor(CellStyle style,
Color color) |
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.