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 |
---|---|
CellStyle |
HSSFWorkbook.createDxfCellStyle(int index) |
Modifier and Type | Method and Description |
---|---|
java.util.List<CellStyle> |
HSSFWorkbook.getDefaultCellStyles() |
java.util.List<CellStyle> |
HSSFWorkbook.getDxfCellStyles() |
Modifier and Type | Method and Description |
---|---|
void |
HSSFWorkbook.addDefaultCellStyle(CellStyle cellStyle) |
void |
HSSFWorkbook.addDxfCellStyle(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 |
Workbook.createDxfCellStyle(int index) |
CellStyle |
Cell.getCellStyle()
Return the cell's style.
|
CellStyle |
Workbook.getCellStyleAt(short idx)
Get the cell style object at the given index
|
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() |
java.util.List<CellStyle> |
Workbook.getDxfCellStyles() |
Modifier and Type | Method and Description |
---|---|
void |
Workbook.addDefaultCellStyle(CellStyle cellStyle) |
void |
Workbook.addDxfCellStyle(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 |
SXSSFWorkbook.createDxfCellStyle(int index) |
CellStyle |
SXSSFCell.getCellStyle()
Return the cell's style.
|
CellStyle |
SXSSFWorkbook.getCellStyleAt(short 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() |
java.util.List<CellStyle> |
SXSSFWorkbook.getDxfCellStyles() |
Modifier and Type | Method and Description |
---|---|
void |
SXSSFWorkbook.addDefaultCellStyle(CellStyle cellStyle) |
void |
SXSSFWorkbook.addDxfCellStyle(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 |
XSSFWorkbook.createDxfCellStyle(int index) |
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() |
java.util.List<CellStyle> |
XSSFWorkbook.getDxfCellStyles() |
Modifier and Type | Method and Description |
---|---|
void |
XSSFWorkbook.addDefaultCellStyle(CellStyle cellStyle) |
void |
XSSFWorkbook.addDxfCellStyle(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 |
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.