org.zkoss.poi.xssf.model

Class StylesTable

java.lang.Object

org.zkoss.poi.POIXMLDocumentPart

org.zkoss.poi.xssf.model.StylesTable

public class StylesTable
extends POIXMLDocumentPart

Table of styles shared across all sheets in a workbook.

Author:

ugo

Field Summary

Fields

Modifier and Type	Field and Description
static int	FIRST_CUSTOM_STYLE_ID The first style id available for use as a custom style

Fields inherited from class org.zkoss.poi.POIXMLDocumentPart

DEFAULT_XML_OPTIONS

Constructor Summary

Constructors

Constructor and Description
StylesTable() Create a new, empty StylesTable
StylesTable(PackagePart part, PackageRelationship rel)

Method Summary

Modifier and Type	Method and Description
int	_getDXfsSize()
int	_getNumberFormatSize() For unit testing only
int	_getStyleXfsSize() For unit testing only
int	_getXfsSize() For unit testing only
void	addTableStyle(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTableStyle tbStyle)
protected void	commit() Save the content in the underlying package part.
XSSFCellStyle	createCellStyle()
XSSFCellStyle	createDefaultCellStyle(XSSFCellBorder border, XSSFCellFill fill, XSSFFont font, int numFmtId)
XSSFFont	findFont(short boldWeight, short color, short fontHeight, String name, boolean italic, boolean strikeout, short typeOffset, byte underline) Finds a font that matches the one with the supplied attributes
XSSFFont	findFont(short boldWeight, XSSFColor color, short fontHeight, String name, boolean italic, boolean strikeout, short typeOffset, byte underline) Find a font per the given font.
XSSFCellBorder	getBorderAt(int idx)
List<XSSFCellBorder>	getBorders()
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellStyle	getCellStyle(String name)
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellStyle	getCellStyleByName(String name)
Collection<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf>	getCellStyleDxfs()
Collection<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellStyle>	getCellStyles()
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf	getCellStyleXfAt(int idx)
Collection<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf>	getCellStyleXfs()
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf	getCellXfAt(int idx)
List<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf>	getCellXfs()
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTStylesheet	getCTStylesheet() For unit testing only!
String	getDefaultPivotStyle()
XSSFFont	getDefaultStyleFont()
String	getDefaultTableStyle()
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf	getDxfAt(int idx)
int	getDxfIndex(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf dxf)
XSSFCellFill	getFillAt(int idx)
List<XSSFCellFill>	getFills()
XSSFFont	getFontAt(int idx)
List<XSSFFont>	getFonts()
String	getNumberFormatAt(int idx)
Map<Integer,String>	getNumberFormats()
int	getNumCellStyles() get the size of cell styles
XSSFCellStyle	getStyleAt(int idx)
XSSFNamedStyle	getStyleByName(String name)
List<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTableStyle>	getTableStyles()
ThemesTable	getTheme()
int	putBorder(XSSFCellBorder border)
int	putCellStyle(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellStyle style)
int	putCellStyleXf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf xf)
int	putCellXf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellXf)
int	putDxf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf dxf)
int	putFill(XSSFCellFill fill)
int	putFont(XSSFFont font)
int	putFont(XSSFFont font, boolean forceRegistration) Records the given font in the font table.
int	putNumberFormat(String fmt)
int	putStyle(XSSFCellStyle style)
protected void	readFrom(InputStream is) Read this shared styles table from an XML file.
void	replaceCellStyleXfAt(int idx, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellStyleXf)
void	replaceCellXfAt(int idx, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellXf)
void	setDefaultCellStyle(XSSFCellStyle cellStyle)
void	setDefaultPivotStyle(String defaultPivotStyle)
void	setDefaultTableStyle(String defaultTableStyle)
void	setTheme(ThemesTable theme)
void	writeTo(OutputStream out) Write this table out as XML.

Methods inherited from class org.zkoss.poi.POIXMLDocumentPart

addRelation, clearMemoryPackagePart, createRelationship, createRelationship, createRelationship, getPackagePart, getPackageRelationship, getParent, getRelationById, getRelationCounter, getRelationId, getRelations, getTargetPart, onDocumentCreate, onDocumentRead, onDocumentRemove, onSave, read, rebase, removeRelation, removeRelation, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

FIRST_CUSTOM_STYLE_ID

public static final int FIRST_CUSTOM_STYLE_ID

The first style id available for use as a custom style

See Also:

Constant Field Values

Constructor Detail

StylesTable

public StylesTable()

Create a new, empty StylesTable

StylesTable

public StylesTable(PackagePart part,
                   PackageRelationship rel)
            throws IOException

Throws:

IOException

Method Detail

getTheme

public ThemesTable getTheme()

setTheme

public void setTheme(ThemesTable theme)

readFrom

protected void readFrom(InputStream is)
                 throws IOException

Read this shared styles table from an XML file.

Parameters:

is - The input stream containing the XML document.

Throws:

IOException - if an error occurs while reading.

getNumberFormatAt

public String getNumberFormatAt(int idx)

putNumberFormat

public int putNumberFormat(String fmt)

getFontAt

public XSSFFont getFontAt(int idx)

putFont

public int putFont(XSSFFont font,
                   boolean forceRegistration)

Records the given font in the font table. Will re-use an existing font index if this font matches another, EXCEPT if forced registration is requested. This allows people to create several fonts then customise them later. Note - End Users probably want to call XSSFFont.registerTo(StylesTable)

putFont

public int putFont(XSSFFont font)

getStyleAt

public XSSFCellStyle getStyleAt(int idx)

putStyle

public int putStyle(XSSFCellStyle style)

getBorderAt

public XSSFCellBorder getBorderAt(int idx)

putBorder

public int putBorder(XSSFCellBorder border)

getFillAt

public XSSFCellFill getFillAt(int idx)

getBorders

public List<XSSFCellBorder> getBorders()

getFills

public List<XSSFCellFill> getFills()

getFonts

public List<XSSFFont> getFonts()

getNumberFormats

public Map<Integer,String> getNumberFormats()

putFill

public int putFill(XSSFCellFill fill)

getCellXfAt

public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf getCellXfAt(int idx)

putCellXf

public int putCellXf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellXf)

replaceCellXfAt

public void replaceCellXfAt(int idx,
                            org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellXf)

getCellStyleXfAt

public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf getCellStyleXfAt(int idx)

replaceCellStyleXfAt

public void replaceCellStyleXfAt(int idx,
                                 org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellStyleXf)

getNumCellStyles

public int getNumCellStyles()

get the size of cell styles

_getNumberFormatSize

public int _getNumberFormatSize()

For unit testing only

_getXfsSize

public int _getXfsSize()

For unit testing only

_getStyleXfsSize

public int _getStyleXfsSize()

For unit testing only

getCTStylesheet

public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTStylesheet getCTStylesheet()

For unit testing only!

_getDXfsSize

public int _getDXfsSize()

writeTo

public void writeTo(OutputStream out)
             throws IOException

Write this table out as XML.

Parameters:

out - The stream to write to.

Throws:

IOException - if an error occurs while writing.

commit

protected void commit()
               throws IOException

Description copied from class: POIXMLDocumentPart

Save the content in the underlying package part. Default implementation is empty meaning that the package part is left unmodified. Sub-classes should override and add logic to marshal the "model" into Ooxml4J. For example, the code saving a generic XML entry may look as follows:

 protected void commit() throws IOException {
   PackagePart part = getPackagePart();
   OutputStream out = part.getOutputStream();
   XmlObject bean = getXmlBean(); //the "model" which holds changes in memory
   bean.save(out, DEFAULT_XML_OPTIONS);
   out.close();
 }
  

Overrides:

commit in class POIXMLDocumentPart

Throws:

IOException

getDxfAt

public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf getDxfAt(int idx)

putDxf

public int putDxf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf dxf)

createCellStyle

public XSSFCellStyle createCellStyle()

findFont

public XSSFFont findFont(short boldWeight,
                         short color,
                         short fontHeight,
                         String name,
                         boolean italic,
                         boolean strikeout,
                         short typeOffset,
                         byte underline)

Finds a font that matches the one with the supplied attributes

findFont

public XSSFFont findFont(short boldWeight,
                         XSSFColor color,
                         short fontHeight,
                         String name,
                         boolean italic,
                         boolean strikeout,
                         short typeOffset,
                         byte underline)

Find a font per the given font.

setDefaultCellStyle

public void setDefaultCellStyle(XSSFCellStyle cellStyle)

putCellStyle

public int putCellStyle(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellStyle style)

putCellStyleXf

public int putCellStyleXf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf xf)

getCellStyleByName

public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellStyle getCellStyleByName(String name)

getCellStyleXfs

public Collection<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf> getCellStyleXfs()

getCellStyles

public Collection<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellStyle> getCellStyles()

getCellStyle

public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellStyle getCellStyle(String name)

getStyleByName

public XSSFNamedStyle getStyleByName(String name)

getCellStyleDxfs

public Collection<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf> getCellStyleDxfs()

createDefaultCellStyle

public XSSFCellStyle createDefaultCellStyle(XSSFCellBorder border,
                                            XSSFCellFill fill,
                                            XSSFFont font,
                                            int numFmtId)

getCellXfs

public List<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf> getCellXfs()

getDefaultStyleFont

public XSSFFont getDefaultStyleFont()

getTableStyles

public List<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTableStyle> getTableStyles()

getDefaultPivotStyle

public String getDefaultPivotStyle()

getDefaultTableStyle

public String getDefaultTableStyle()

setDefaultPivotStyle

public void setDefaultPivotStyle(String defaultPivotStyle)

setDefaultTableStyle

public void setDefaultTableStyle(String defaultTableStyle)

getDxfIndex

public int getDxfIndex(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf dxf)

addTableStyle

public void addTableStyle(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTableStyle tbStyle)