Uses of Interface
org.zkoss.poi.ss.usermodel.CellStyle

Packages that use CellStyle

Package	Description
io.keikai.range.impl.imexp	Keikai Spreadsheet Internal Range API Implementation classes.
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.ss.usermodel
org.zkoss.poi.ss.util
org.zkoss.poi.xssf.streaming
org.zkoss.poi.xssf.usermodel
org.zkoss.poi.xssf.usermodel.helpers

Uses of CellStyle in io.keikai.range.impl.imexp

Fields in io.keikai.range.impl.imexp with type parameters of type CellStyle

Modifier and Type	Field and Description
protected Map<SCellStyle,CellStyle>	AbstractExcelExporter.styleTable The map stores the exported CellStyle during exporting, so that we can reuse them for exporting other cells.

Methods in io.keikai.range.impl.imexp that return CellStyle

Modifier and Type	Method and Description
protected CellStyle	AbstractExcelExporter.toPOICellStyle(SCellStyle cellStyle)
protected CellStyle	ExcelXlsxExporter.toPOIDefaultCellStyle(SCellStyle cellStyle)
protected CellStyle	AbstractExcelExporter.toPOIDefaultCellStyle(SCellStyle cellStyle)

Methods in io.keikai.range.impl.imexp with parameters of type 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)

Uses of CellStyle in org.zkoss.poi.hssf.converter

Methods in org.zkoss.poi.hssf.converter with parameters of type CellStyle

Modifier and Type	Method and Description
protected boolean	ExcelToFoConverter.isEmptyStyle(CellStyle cellStyle) Returns false if cell style by itself (without text, i.e.

Uses of CellStyle in org.zkoss.poi.hssf.usermodel

Classes in org.zkoss.poi.hssf.usermodel that implement CellStyle

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

Methods in org.zkoss.poi.hssf.usermodel that return types with arguments of type CellStyle

Modifier and Type	Method and Description
List<CellStyle>	HSSFWorkbook.getDefaultCellStyles()

Methods in org.zkoss.poi.hssf.usermodel with parameters of type CellStyle

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.

Constructors in org.zkoss.poi.hssf.usermodel with parameters of type CellStyle

Constructor and Description
HSSFNamedStyle(StyleRecord rec, StyleExtRecord rec2, CellStyle inner)

Uses of CellStyle in org.zkoss.poi.ss.usermodel

Subinterfaces of CellStyle in org.zkoss.poi.ss.usermodel

Modifier and Type	Interface and Description
interface	DxfCellStyle Cell style for Dxfs
interface	NamedStyle CellStyle with a name.

Methods in org.zkoss.poi.ss.usermodel that return CellStyle

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.

Methods in org.zkoss.poi.ss.usermodel that return types with arguments of type CellStyle

Modifier and Type	Method and Description
List<CellStyle>	Workbook.getDefaultCellStyles()

Methods in org.zkoss.poi.ss.usermodel with parameters of type CellStyle

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.

Uses of CellStyle in org.zkoss.poi.ss.util

Methods in org.zkoss.poi.ss.util with parameters of type CellStyle

Modifier and Type	Method and Description
static Cell	CellUtil.createCell(Row row, int column, String value, CellStyle style) Creates a cell, gives it a value, and applies a style if provided

Uses of CellStyle in org.zkoss.poi.xssf.streaming

Methods in org.zkoss.poi.xssf.streaming that return CellStyle

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.

Methods in org.zkoss.poi.xssf.streaming that return types with arguments of type CellStyle

Modifier and Type	Method and Description
List<CellStyle>	SXSSFWorkbook.getDefaultCellStyles()

Methods in org.zkoss.poi.xssf.streaming with parameters of type CellStyle

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.

Uses of CellStyle in org.zkoss.poi.xssf.usermodel

Classes in org.zkoss.poi.xssf.usermodel that implement CellStyle

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

Methods in org.zkoss.poi.xssf.usermodel that return CellStyle

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

Methods in org.zkoss.poi.xssf.usermodel that return types with arguments of type CellStyle

Modifier and Type	Method and Description
List<CellStyle>	XSSFWorkbook.getDefaultCellStyles()

Methods in org.zkoss.poi.xssf.usermodel with parameters of type CellStyle

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.

Uses of CellStyle in org.zkoss.poi.xssf.usermodel.helpers

Methods in org.zkoss.poi.xssf.usermodel.helpers with parameters of type CellStyle

Modifier and Type	Method and Description
void	ColumnHelper.setColDefaultStyle(long index, CellStyle style)