|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.apache.poi.POIXMLDocumentPart org.apache.poi.xssf.model.StylesTable
public class StylesTable
Table of styles shared across all sheets in a workbook.
Field Summary | |
---|---|
static int |
FIRST_CUSTOM_STYLE_ID
The first style id available for use as a custom style |
Fields inherited from class org.apache.poi.POIXMLDocumentPart |
---|
DEFAULT_XML_OPTIONS |
Constructor Summary | |
---|---|
StylesTable()
Create a new, empty StylesTable |
|
StylesTable(PackagePart part,
PackageRelationship rel)
|
Method Summary | |
---|---|
int |
_getDXfsSize()
|
int |
_getNumberFormatSize()
For unit testing only |
int |
_getStyleXfsSize()
For unit testing only |
int |
_getXfsSize()
For unit testing only |
protected void |
commit()
Save the content in the underlying package part. |
XSSFCellStyle |
createCellStyle()
|
XSSFFont |
findFont(short boldWeight,
short color,
short fontHeight,
java.lang.String name,
boolean italic,
boolean strikeout,
short typeOffset,
byte underline)
Finds a font that matches the one with the supplied attributes |
XSSFCellBorder |
getBorderAt(int idx)
|
java.util.List<XSSFCellBorder> |
getBorders()
|
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf |
getCellStyleXfAt(int idx)
|
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf |
getCellXfAt(int idx)
|
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTStylesheet |
getCTStylesheet()
For unit testing only! |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf |
getDxfAt(int idx)
|
XSSFCellFill |
getFillAt(int idx)
|
java.util.List<XSSFCellFill> |
getFills()
|
XSSFFont |
getFontAt(int idx)
|
java.util.List<XSSFFont> |
getFonts()
|
java.lang.String |
getNumberFormatAt(int idx)
|
java.util.Map<java.lang.Integer,java.lang.String> |
getNumberFormats()
|
int |
getNumCellStyles()
get the size of cell styles |
XSSFCellStyle |
getStyleAt(int idx)
|
ThemesTable |
getTheme()
|
int |
putBorder(XSSFCellBorder border)
|
int |
putCellStyleXf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellStyleXf)
|
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(java.lang.String fmt)
|
int |
putStyle(XSSFCellStyle style)
|
protected void |
readFrom(java.io.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 |
setTheme(ThemesTable theme)
|
void |
writeTo(java.io.OutputStream out)
Write this table out as XML. |
Methods inherited from class org.apache.poi.POIXMLDocumentPart |
---|
addRelation, createRelationship, createRelationship, createRelationship, getPackagePart, getPackageRelationship, getParent, getRelationById, 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 |
---|
public static final int FIRST_CUSTOM_STYLE_ID
Constructor Detail |
---|
public StylesTable()
public StylesTable(PackagePart part, PackageRelationship rel) throws java.io.IOException
java.io.IOException
Method Detail |
---|
public ThemesTable getTheme()
public void setTheme(ThemesTable theme)
protected void readFrom(java.io.InputStream is) throws java.io.IOException
is
- The input stream containing the XML document.
java.io.IOException
- if an error occurs while reading.public java.lang.String getNumberFormatAt(int idx)
public int putNumberFormat(java.lang.String fmt)
public XSSFFont getFontAt(int idx)
public int putFont(XSSFFont font, boolean forceRegistration)
XSSFFont.registerTo(StylesTable)
public int putFont(XSSFFont font)
public XSSFCellStyle getStyleAt(int idx)
public int putStyle(XSSFCellStyle style)
public XSSFCellBorder getBorderAt(int idx)
public int putBorder(XSSFCellBorder border)
public XSSFCellFill getFillAt(int idx)
public java.util.List<XSSFCellBorder> getBorders()
public java.util.List<XSSFCellFill> getFills()
public java.util.List<XSSFFont> getFonts()
public java.util.Map<java.lang.Integer,java.lang.String> getNumberFormats()
public int putFill(XSSFCellFill fill)
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf getCellXfAt(int idx)
public int putCellXf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellXf)
public void replaceCellXfAt(int idx, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellXf)
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf getCellStyleXfAt(int idx)
public int putCellStyleXf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellStyleXf)
public void replaceCellStyleXfAt(int idx, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf cellStyleXf)
public int getNumCellStyles()
public int _getNumberFormatSize()
public int _getXfsSize()
public int _getStyleXfsSize()
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTStylesheet getCTStylesheet()
public int _getDXfsSize()
public void writeTo(java.io.OutputStream out) throws java.io.IOException
out
- The stream to write to.
java.io.IOException
- if an error occurs while writing.protected void commit() throws java.io.IOException
POIXMLDocumentPart
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();
}
commit
in class POIXMLDocumentPart
java.io.IOException
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf getDxfAt(int idx)
public int putDxf(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxf dxf)
public XSSFCellStyle createCellStyle()
public XSSFFont findFont(short boldWeight, short color, short fontHeight, java.lang.String name, boolean italic, boolean strikeout, short typeOffset, byte underline)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |