|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.apache.poi.xssf.usermodel.XSSFCellStyle
public class XSSFCellStyle
High level representation of the the possible formatting information for the contents of the cells on a sheet in a SpreadsheetML document.
XSSFWorkbook.createCellStyle(),
XSSFWorkbook.getCellStyleAt(short),
XSSFCell.setCellStyle(org.apache.poi.ss.usermodel.CellStyle)| Field Summary |
|---|
| Fields inherited from interface org.apache.poi.ss.usermodel.CellStyle |
|---|
ALIGN_CENTER, ALIGN_CENTER_SELECTION, ALIGN_FILL, ALIGN_GENERAL, ALIGN_JUSTIFY, ALIGN_LEFT, ALIGN_RIGHT, ALT_BARS, BIG_SPOTS, BORDER_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_DASHED, BORDER_DOTTED, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM, BORDER_MEDIUM_DASH_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_MEDIUM_DASHED, BORDER_NONE, BORDER_SLANTED_DASH_DOT, BORDER_THICK, BORDER_THIN, BRICKS, DIAMONDS, FINE_DOTS, LEAST_DOTS, LESS_DOTS, NO_FILL, SOLID_FOREGROUND, SPARSE_DOTS, SQUARES, THICK_BACKWARD_DIAG, THICK_FORWARD_DIAG, THICK_HORZ_BANDS, THICK_VERT_BANDS, THIN_BACKWARD_DIAG, THIN_FORWARD_DIAG, THIN_HORZ_BANDS, THIN_VERT_BANDS, VERTICAL_BOTTOM, VERTICAL_CENTER, VERTICAL_JUSTIFY, VERTICAL_TOP |
| Constructor Summary | |
|---|---|
XSSFCellStyle(int cellXfId,
int cellStyleXfId,
StylesTable stylesSource,
ThemesTable theme)
Creates a Cell Style from the supplied parts |
|
XSSFCellStyle(StylesTable stylesSource)
Creates an empty Cell Style |
|
| Method Summary | |
|---|---|
java.lang.Object |
clone()
Make a copy of this style. |
void |
cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle source)
Clones all the style information from another XSSFCellStyle, onto this one. |
boolean |
equals(java.lang.Object o)
Checks is the supplied style is equal to this style |
short |
getAlignment()
Get the type of horizontal alignment for the cell |
org.apache.poi.ss.usermodel.HorizontalAlignment |
getAlignmentEnum()
Get the type of horizontal alignment for the cell |
short |
getBorderBottom()
Get the type of border to use for the bottom border of the cell |
org.apache.poi.ss.usermodel.BorderStyle |
getBorderBottomEnum()
Get the type of border to use for the bottom border of the cell |
XSSFColor |
getBorderColor(XSSFCellBorder.BorderSide side)
Gets border color |
short |
getBorderLeft()
Get the type of border to use for the left border of the cell |
org.apache.poi.ss.usermodel.BorderStyle |
getBorderLeftEnum()
Get the type of border to use for the left border of the cell |
short |
getBorderRight()
Get the type of border to use for the right border of the cell |
org.apache.poi.ss.usermodel.BorderStyle |
getBorderRightEnum()
Get the type of border to use for the right border of the cell |
short |
getBorderTop()
Get the type of border to use for the top border of the cell |
org.apache.poi.ss.usermodel.BorderStyle |
getBorderTopEnum()
Get the type of border to use for the top border of the cell |
short |
getBottomBorderColor()
Get the color to use for the bottom border Color is optional. |
XSSFColor |
getBottomBorderXSSFColor()
Get the color to use for the bottom border as a XSSFColor |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf |
getCoreXf()
Used so that StylesSource can figure out our location |
short |
getDataFormat()
Get the index of the number format (numFmt) record used by this cell format. |
java.lang.String |
getDataFormatString()
Get the contents of the format string, by looking up the StylesSource |
short |
getFillBackgroundColor()
Get the background fill color. |
org.apache.poi.ss.usermodel.Color |
getFillBackgroundColorColor()
|
XSSFColor |
getFillBackgroundXSSFColor()
Get the background fill color. |
short |
getFillForegroundColor()
Get the foreground fill color. |
org.apache.poi.ss.usermodel.Color |
getFillForegroundColorColor()
|
XSSFColor |
getFillForegroundXSSFColor()
Get the foreground fill color. |
short |
getFillPattern()
Get the fill pattern |
org.apache.poi.ss.usermodel.FillPatternType |
getFillPatternEnum()
Get the fill pattern |
XSSFFont |
getFont()
Gets the font for this style |
short |
getFontIndex()
Gets the index of the font for this style |
boolean |
getHidden()
Get whether the cell's using this style are to be hidden |
short |
getIndention()
Get the number of spaces to indent the text in the cell |
short |
getIndex()
Get the index within the StylesTable (sequence within the collection of CTXf elements) |
short |
getLeftBorderColor()
Get the color to use for the left border |
XSSFColor |
getLeftBorderXSSFColor()
Get the color to use for the left border |
boolean |
getLocked()
Get whether the cell's using this style are locked |
short |
getRightBorderColor()
Get the color to use for the right border |
XSSFColor |
getRightBorderXSSFColor()
Get the color to use for the right border |
short |
getRotation()
Get the degree of rotation for the text in the cell |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf |
getStyleXf()
Used so that StylesSource can figure out our location |
short |
getTopBorderColor()
Get the color to use for the top border |
XSSFColor |
getTopBorderXSSFColor()
Get the color to use for the top border |
short |
getVerticalAlignment()
Get the type of vertical alignment for the cell |
org.apache.poi.ss.usermodel.VerticalAlignment |
getVerticalAlignmentEnum()
Get the type of vertical alignment for the cell |
boolean |
getWrapText()
Whether the text should be wrapped |
int |
hashCode()
Returns a hash code value for the object. |
void |
setAlignment(org.apache.poi.ss.usermodel.HorizontalAlignment align)
Set the type of horizontal alignment for the cell |
void |
setAlignment(short align)
Set the type of horizontal alignment for the cell |
void |
setBorderBottom(org.apache.poi.ss.usermodel.BorderStyle border)
Set the type of border to use for the bottom border of the cell |
void |
setBorderBottom(short border)
Set the type of border to use for the bottom border of the cell |
void |
setBorderColor(XSSFCellBorder.BorderSide side,
XSSFColor color)
Set the color to use for the selected border |
void |
setBorderLeft(org.apache.poi.ss.usermodel.BorderStyle border)
Set the type of border to use for the left border of the cell |
void |
setBorderLeft(short border)
Set the type of border to use for the left border of the cell |
void |
setBorderRight(org.apache.poi.ss.usermodel.BorderStyle border)
Set the type of border to use for the right border of the cell |
void |
setBorderRight(short border)
Set the type of border to use for the right border of the cell |
void |
setBorderTop(org.apache.poi.ss.usermodel.BorderStyle border)
Set the type of border to use for the top border of the cell |
void |
setBorderTop(short border)
Set the type of border to use for the top border of the cell |
void |
setBottomBorderColor(short color)
Set the color to use for the bottom border |
void |
setBottomBorderColor(XSSFColor color)
Set the color to use for the bottom border |
void |
setDataFormat(short fmt)
Set the index of a data format |
void |
setFillBackgroundColor(short bg)
Set the background fill color represented as a indexed color value. |
void |
setFillBackgroundColor(XSSFColor color)
Set the background fill color represented as a XSSFColor value. |
void |
setFillForegroundColor(short fg)
Set the foreground fill color as a indexed color value Note: Ensure Foreground color is set prior to background color. |
void |
setFillForegroundColor(XSSFColor color)
Set the foreground fill color represented as a XSSFColor value. |
void |
setFillPattern(org.apache.poi.ss.usermodel.FillPatternType ptrn)
This element is used to specify cell fill information for pattern and solid color cell fills. |
void |
setFillPattern(short fp)
This element is used to specify cell fill information for pattern and solid color cell fills. |
void |
setFont(org.apache.poi.ss.usermodel.Font font)
Set the font for this style |
void |
setHidden(boolean hidden)
Set the cell's using this style to be hidden |
void |
setIndention(short indent)
Set the number of spaces to indent the text in the cell |
void |
setLeftBorderColor(short color)
Set the color to use for the left border as a indexed color value |
void |
setLeftBorderColor(XSSFColor color)
Set the color to use for the left border as a XSSFColor value |
void |
setLocked(boolean locked)
Set the cell's using this style to be locked |
void |
setRightBorderColor(short color)
Set the color to use for the right border |
void |
setRightBorderColor(XSSFColor color)
Set the color to use for the right border as a XSSFColor value |
void |
setRotation(short rotation)
Set the degree of rotation for the text in the cell |
void |
setTopBorderColor(short color)
Set the color to use for the top border |
void |
setTopBorderColor(XSSFColor color)
Set the color to use for the top border as a XSSFColor value |
void |
setVerticalAlignment(short align)
Set the type of vertical alignment for the cell |
void |
setVerticalAlignment(org.apache.poi.ss.usermodel.VerticalAlignment align)
Set the type of vertical alignment for the cell |
void |
setWrapText(boolean wrapped)
Set whether the text should be wrapped. |
void |
verifyBelongsToStylesSource(StylesTable src)
Verifies that this style belongs to the supplied Workbook Styles Source. |
| Methods inherited from class java.lang.Object |
|---|
getClass, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
public XSSFCellStyle(int cellXfId,
int cellStyleXfId,
StylesTable stylesSource,
ThemesTable theme)
cellXfId - The main XF for the cell. Must be a valid 0-based index into the XF tablecellStyleXfId - Optional, style xf. A value of -1 means no xf.stylesSource - Styles Source to work offpublic XSSFCellStyle(StylesTable stylesSource)
| Method Detail |
|---|
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf getCoreXf()
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf getStyleXf()
public void verifyBelongsToStylesSource(StylesTable src)
java.lang.IllegalArgumentException - if there's a workbook mis-matchpublic void cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle source)
cloneStyleFrom in interface org.apache.poi.ss.usermodel.CellStylepublic short getAlignment()
getAlignment in interface org.apache.poi.ss.usermodel.CellStyleCellStyle.ALIGN_GENERAL,
CellStyle.ALIGN_LEFT,
CellStyle.ALIGN_CENTER,
CellStyle.ALIGN_RIGHT,
CellStyle.ALIGN_FILL,
CellStyle.ALIGN_JUSTIFY,
CellStyle.ALIGN_CENTER_SELECTIONpublic org.apache.poi.ss.usermodel.HorizontalAlignment getAlignmentEnum()
HorizontalAlignmentpublic short getBorderBottom()
getBorderBottom in interface org.apache.poi.ss.usermodel.CellStyleCellStyle.BORDER_NONE,
CellStyle.BORDER_THIN,
CellStyle.BORDER_MEDIUM,
CellStyle.BORDER_DASHED,
CellStyle.BORDER_DOTTED,
CellStyle.BORDER_THICK,
CellStyle.BORDER_DOUBLE,
CellStyle.BORDER_HAIR,
CellStyle.BORDER_MEDIUM_DASHED,
CellStyle.BORDER_DASH_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT,
CellStyle.BORDER_DASH_DOT_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT,
CellStyle.BORDER_SLANTED_DASH_DOTpublic org.apache.poi.ss.usermodel.BorderStyle getBorderBottomEnum()
BorderStylepublic short getBorderLeft()
getBorderLeft in interface org.apache.poi.ss.usermodel.CellStyleCellStyle.BORDER_NONECellStyle.BORDER_NONE,
CellStyle.BORDER_THIN,
CellStyle.BORDER_MEDIUM,
CellStyle.BORDER_DASHED,
CellStyle.BORDER_DOTTED,
CellStyle.BORDER_THICK,
CellStyle.BORDER_DOUBLE,
CellStyle.BORDER_HAIR,
CellStyle.BORDER_MEDIUM_DASHED,
CellStyle.BORDER_DASH_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT,
CellStyle.BORDER_DASH_DOT_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT,
CellStyle.BORDER_SLANTED_DASH_DOTpublic org.apache.poi.ss.usermodel.BorderStyle getBorderLeftEnum()
BorderStyle.NONEpublic short getBorderRight()
getBorderRight in interface org.apache.poi.ss.usermodel.CellStyleCellStyle.BORDER_NONECellStyle.BORDER_NONE,
CellStyle.BORDER_THIN,
CellStyle.BORDER_MEDIUM,
CellStyle.BORDER_DASHED,
CellStyle.BORDER_DOTTED,
CellStyle.BORDER_THICK,
CellStyle.BORDER_DOUBLE,
CellStyle.BORDER_HAIR,
CellStyle.BORDER_MEDIUM_DASHED,
CellStyle.BORDER_DASH_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT,
CellStyle.BORDER_DASH_DOT_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT,
CellStyle.BORDER_SLANTED_DASH_DOTpublic org.apache.poi.ss.usermodel.BorderStyle getBorderRightEnum()
BorderStyle.NONEpublic short getBorderTop()
getBorderTop in interface org.apache.poi.ss.usermodel.CellStyleCellStyle.BORDER_NONECellStyle.BORDER_NONE,
CellStyle.BORDER_THIN,
CellStyle.BORDER_MEDIUM,
CellStyle.BORDER_DASHED,
CellStyle.BORDER_DOTTED,
#BORDER_THICK,
CellStyle.BORDER_DOUBLE,
CellStyle.BORDER_HAIR,
CellStyle.BORDER_MEDIUM_DASHED,
CellStyle.BORDER_DASH_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT,
CellStyle.BORDER_DASH_DOT_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT,
CellStyle.BORDER_SLANTED_DASH_DOTpublic org.apache.poi.ss.usermodel.BorderStyle getBorderTopEnum()
BorderStyle.NONEpublic short getBottomBorderColor()
getBottomBorderColor in interface org.apache.poi.ss.usermodel.CellStyleIndexedColors.AUTOMATICIndexedColorspublic XSSFColor getBottomBorderXSSFColor()
XSSFColor
null if not setpublic short getDataFormat()
getDataFormat in interface org.apache.poi.ss.usermodel.CellStylepublic java.lang.String getDataFormatString()
getDataFormatString in interface org.apache.poi.ss.usermodel.CellStylepublic short getFillBackgroundColor()
Note - many cells are actually filled with a foreground
fill, not a background fill - see getFillForegroundColor()
getFillBackgroundColor in interface org.apache.poi.ss.usermodel.CellStyleIndexedColors.AUTOMATICIndexedColorspublic org.apache.poi.ss.usermodel.Color getFillBackgroundColorColor()
getFillBackgroundColorColor in interface org.apache.poi.ss.usermodel.CellStylepublic XSSFColor getFillBackgroundXSSFColor()
Note - many cells are actually filled with a foreground
fill, not a background fill - see getFillForegroundColor()
null if not setXSSFColor.getRgb()public short getFillForegroundColor()
Many cells are filled with this, instead of a
background color (getFillBackgroundColor())
getFillForegroundColor in interface org.apache.poi.ss.usermodel.CellStyleIndexedColors.AUTOMATICIndexedColorspublic org.apache.poi.ss.usermodel.Color getFillForegroundColorColor()
getFillForegroundColorColor in interface org.apache.poi.ss.usermodel.CellStylepublic XSSFColor getFillForegroundXSSFColor()
null if not setpublic short getFillPattern()
getFillPattern in interface org.apache.poi.ss.usermodel.CellStyleCellStyle.NO_FILLCellStyle.NO_FILL,
CellStyle.SOLID_FOREGROUND,
CellStyle.FINE_DOTS,
CellStyle.ALT_BARS,
CellStyle.SPARSE_DOTS,
CellStyle.THICK_HORZ_BANDS,
CellStyle.THICK_VERT_BANDS,
CellStyle.THICK_BACKWARD_DIAG,
CellStyle.THICK_FORWARD_DIAG,
CellStyle.BIG_SPOTS,
CellStyle.BRICKS,
CellStyle.THIN_HORZ_BANDS,
CellStyle.THIN_VERT_BANDS,
CellStyle.THIN_BACKWARD_DIAG,
CellStyle.THIN_FORWARD_DIAG,
CellStyle.SQUARES,
CellStyle.DIAMONDSpublic org.apache.poi.ss.usermodel.FillPatternType getFillPatternEnum()
FillPatternType.NO_FILLpublic XSSFFont getFont()
public short getFontIndex()
getFontIndex in interface org.apache.poi.ss.usermodel.CellStyleXSSFWorkbook.getFontAt(short)public boolean getHidden()
getHidden in interface org.apache.poi.ss.usermodel.CellStylepublic short getIndention()
getIndention in interface org.apache.poi.ss.usermodel.CellStylepublic short getIndex()
getIndex in interface org.apache.poi.ss.usermodel.CellStylepublic short getLeftBorderColor()
getLeftBorderColor in interface org.apache.poi.ss.usermodel.CellStyleIndexedColors.BLACKIndexedColorspublic XSSFColor getLeftBorderXSSFColor()
null if not setIndexedColorspublic boolean getLocked()
getLocked in interface org.apache.poi.ss.usermodel.CellStylepublic short getRightBorderColor()
getRightBorderColor in interface org.apache.poi.ss.usermodel.CellStyleIndexedColors.BLACKIndexedColorspublic XSSFColor getRightBorderXSSFColor()
null if not setpublic short getRotation()
Expressed in degrees. Values range from 0 to 180. The first letter of
the text is considered the center-point of the arc.
For 0 - 90, the value represents degrees above horizon. For 91-180 the degrees below the
horizon is calculated as:
[degrees below horizon] = 90 - textRotation.
getRotation in interface org.apache.poi.ss.usermodel.CellStylepublic short getTopBorderColor()
getTopBorderColor in interface org.apache.poi.ss.usermodel.CellStyleIndexedColors.BLACKIndexedColorspublic XSSFColor getTopBorderXSSFColor()
null if not setpublic short getVerticalAlignment()
getVerticalAlignment in interface org.apache.poi.ss.usermodel.CellStyleCellStyle.VERTICAL_BOTTOMCellStyle.VERTICAL_TOP,
CellStyle.VERTICAL_CENTER,
CellStyle.VERTICAL_BOTTOM,
CellStyle.VERTICAL_JUSTIFYpublic org.apache.poi.ss.usermodel.VerticalAlignment getVerticalAlignmentEnum()
VerticalAlignment.BOTTOMVerticalAlignmentpublic boolean getWrapText()
getWrapText in interface org.apache.poi.ss.usermodel.CellStylepublic void setAlignment(short align)
setAlignment in interface org.apache.poi.ss.usermodel.CellStylealign - - the type of alignmentCellStyle.ALIGN_GENERAL,
CellStyle.ALIGN_LEFT,
CellStyle.ALIGN_CENTER,
CellStyle.ALIGN_RIGHT,
CellStyle.ALIGN_FILL,
CellStyle.ALIGN_JUSTIFY,
CellStyle.ALIGN_CENTER_SELECTIONpublic void setAlignment(org.apache.poi.ss.usermodel.HorizontalAlignment align)
align - - the type of alignmentHorizontalAlignmentpublic void setBorderBottom(short border)
setBorderBottom in interface org.apache.poi.ss.usermodel.CellStyleborder - the type of border to useCellStyle.BORDER_NONE,
CellStyle.BORDER_THIN,
CellStyle.BORDER_MEDIUM,
CellStyle.BORDER_DASHED,
CellStyle.BORDER_DOTTED,
CellStyle.BORDER_THICK,
CellStyle.BORDER_DOUBLE,
CellStyle.BORDER_HAIR,
CellStyle.BORDER_MEDIUM_DASHED,
CellStyle.BORDER_DASH_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT,
CellStyle.BORDER_DASH_DOT_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT,
CellStyle.BORDER_SLANTED_DASH_DOTpublic void setBorderBottom(org.apache.poi.ss.usermodel.BorderStyle border)
border - - type of border to useBorderStylepublic void setBorderLeft(short border)
setBorderLeft in interface org.apache.poi.ss.usermodel.CellStyleborder - the type of border to useCellStyle.BORDER_NONE,
CellStyle.BORDER_THIN,
CellStyle.BORDER_MEDIUM,
CellStyle.BORDER_DASHED,
CellStyle.BORDER_DOTTED,
CellStyle.BORDER_THICK,
CellStyle.BORDER_DOUBLE,
CellStyle.BORDER_HAIR,
CellStyle.BORDER_MEDIUM_DASHED,
CellStyle.BORDER_DASH_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT,
CellStyle.BORDER_DASH_DOT_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT,
CellStyle.BORDER_SLANTED_DASH_DOTpublic void setBorderLeft(org.apache.poi.ss.usermodel.BorderStyle border)
border - the type of border to usepublic void setBorderRight(short border)
setBorderRight in interface org.apache.poi.ss.usermodel.CellStyleborder - the type of border to useCellStyle.BORDER_NONE,
CellStyle.BORDER_THIN,
CellStyle.BORDER_MEDIUM,
CellStyle.BORDER_DASHED,
CellStyle.BORDER_DOTTED,
CellStyle.BORDER_THICK,
CellStyle.BORDER_DOUBLE,
CellStyle.BORDER_HAIR,
CellStyle.BORDER_MEDIUM_DASHED,
CellStyle.BORDER_DASH_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT,
CellStyle.BORDER_DASH_DOT_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT,
CellStyle.BORDER_SLANTED_DASH_DOTpublic void setBorderRight(org.apache.poi.ss.usermodel.BorderStyle border)
border - the type of border to usepublic void setBorderTop(short border)
setBorderTop in interface org.apache.poi.ss.usermodel.CellStyleborder - the type of border to useCellStyle.BORDER_NONE,
CellStyle.BORDER_THIN,
CellStyle.BORDER_MEDIUM,
CellStyle.BORDER_DASHED,
CellStyle.BORDER_DOTTED,
CellStyle.BORDER_THICK,
CellStyle.BORDER_DOUBLE,
CellStyle.BORDER_HAIR,
CellStyle.BORDER_MEDIUM_DASHED,
CellStyle.BORDER_DASH_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT,
CellStyle.BORDER_DASH_DOT_DOT,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT,
CellStyle.BORDER_SLANTED_DASH_DOTpublic void setBorderTop(org.apache.poi.ss.usermodel.BorderStyle border)
border - the type of border to usepublic void setBottomBorderColor(short color)
setBottomBorderColor in interface org.apache.poi.ss.usermodel.CellStylecolor - the index of the color definitionIndexedColorspublic void setBottomBorderColor(XSSFColor color)
color - the color to use, null means no colorpublic void setDataFormat(short fmt)
setDataFormat in interface org.apache.poi.ss.usermodel.CellStylefmt - the index of a data formatpublic void setFillBackgroundColor(XSSFColor color)
XSSFColor value.
For example:
cs.setFillPattern(XSSFCellStyle.FINE_DOTS ); cs.setFillBackgroundXSSFColor(new XSSFColor(java.awt.Color.RED));optionally a Foreground and background fill can be applied: Note: Ensure Foreground color is set prior to background
cs.setFillPattern(XSSFCellStyle.FINE_DOTS ); cs.setFillForegroundColor(new XSSFColor(java.awt.Color.BLUE)); cs.setFillBackgroundColor(new XSSFColor(java.awt.Color.GREEN));or, for the special case of SOLID_FILL:
cs.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND ); cs.setFillForegroundColor(new XSSFColor(java.awt.Color.GREEN));It is necessary to set the fill style in order for the color to be shown in the cell.
color - - the color to usepublic void setFillBackgroundColor(short bg)
For example:
cs.setFillPattern(XSSFCellStyle.FINE_DOTS ); cs.setFillBackgroundXSSFColor(IndexedColors.RED.getIndex());optionally a Foreground and background fill can be applied: Note: Ensure Foreground color is set prior to background
cs.setFillPattern(XSSFCellStyle.FINE_DOTS ); cs.setFillForegroundColor(IndexedColors.BLUE.getIndex()); cs.setFillBackgroundColor(IndexedColors.RED.getIndex());or, for the special case of SOLID_FILL:
cs.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND ); cs.setFillForegroundColor(IndexedColors.RED.getIndex());It is necessary to set the fill style in order for the color to be shown in the cell.
setFillBackgroundColor in interface org.apache.poi.ss.usermodel.CellStylebg - - the color to useIndexedColorspublic void setFillForegroundColor(XSSFColor color)
XSSFColor value.
color - the color to use)public void setFillForegroundColor(short fg)
setFillForegroundColor in interface org.apache.poi.ss.usermodel.CellStylefg - the color to useIndexedColorspublic void setFillPattern(short fp)
setFillPattern in interface org.apache.poi.ss.usermodel.CellStylefp - fill pattern (set to CellStyle.SOLID_FOREGROUND to fill w/foreground color)CellStyle.NO_FILL,
CellStyle.SOLID_FOREGROUND,
CellStyle.FINE_DOTS,
CellStyle.ALT_BARS,
CellStyle.SPARSE_DOTS,
CellStyle.THICK_HORZ_BANDS,
CellStyle.THICK_VERT_BANDS,
CellStyle.THICK_BACKWARD_DIAG,
CellStyle.THICK_FORWARD_DIAG,
CellStyle.BIG_SPOTS,
CellStyle.BRICKS,
CellStyle.THIN_HORZ_BANDS,
CellStyle.THIN_VERT_BANDS,
CellStyle.THIN_BACKWARD_DIAG,
CellStyle.THIN_FORWARD_DIAG,
CellStyle.SQUARES,
CellStyle.DIAMONDS,
setFillBackgroundColor(short),
setFillForegroundColor(short)public void setFillPattern(org.apache.poi.ss.usermodel.FillPatternType ptrn)
ptrn - the fill pattern to usesetFillBackgroundColor(short),
setFillForegroundColor(short),
FillPatternTypepublic void setFont(org.apache.poi.ss.usermodel.Font font)
setFont in interface org.apache.poi.ss.usermodel.CellStylefont - a font object created or retreived from the XSSFWorkbook objectXSSFWorkbook.createFont(),
XSSFWorkbook.getFontAt(short)public void setHidden(boolean hidden)
setHidden in interface org.apache.poi.ss.usermodel.CellStylehidden - - whether the cell using this style should be hiddenpublic void setIndention(short indent)
setIndention in interface org.apache.poi.ss.usermodel.CellStyleindent - - number of spacespublic void setLeftBorderColor(short color)
setLeftBorderColor in interface org.apache.poi.ss.usermodel.CellStylecolor - the index of the color definitionIndexedColorspublic void setLeftBorderColor(XSSFColor color)
XSSFColor value
color - the color to usepublic void setLocked(boolean locked)
setLocked in interface org.apache.poi.ss.usermodel.CellStylelocked - - whether the cell using this style should be lockedpublic void setRightBorderColor(short color)
setRightBorderColor in interface org.apache.poi.ss.usermodel.CellStylecolor - the index of the color definitionIndexedColorspublic void setRightBorderColor(XSSFColor color)
XSSFColor value
color - the color to usepublic void setRotation(short rotation)
Expressed in degrees. Values range from 0 to 180. The first letter of
the text is considered the center-point of the arc.
For 0 - 90, the value represents degrees above horizon. For 91-180 the degrees below the
horizon is calculated as:
[degrees below horizon] = 90 - textRotation.
setRotation in interface org.apache.poi.ss.usermodel.CellStylerotation - - the rotation degrees (between 0 and 180 degrees)public void setTopBorderColor(short color)
setTopBorderColor in interface org.apache.poi.ss.usermodel.CellStylecolor - the index of the color definitionIndexedColorspublic void setTopBorderColor(XSSFColor color)
XSSFColor value
color - the color to usepublic void setVerticalAlignment(short align)
setVerticalAlignment in interface org.apache.poi.ss.usermodel.CellStylealign - - align the type of alignmentCellStyle.VERTICAL_TOP,
CellStyle.VERTICAL_CENTER,
CellStyle.VERTICAL_BOTTOM,
CellStyle.VERTICAL_JUSTIFY,
VerticalAlignmentpublic void setVerticalAlignment(org.apache.poi.ss.usermodel.VerticalAlignment align)
align - - the type of alignmentpublic void setWrapText(boolean wrapped)
Setting this flag to true make all content visible
whithin a cell by displaying it on multiple lines
setWrapText in interface org.apache.poi.ss.usermodel.CellStylewrapped - a boolean value indicating if the text in a cell should be line-wrapped within the cell.public XSSFColor getBorderColor(XSSFCellBorder.BorderSide side)
side - the border side
public void setBorderColor(XSSFCellBorder.BorderSide side,
XSSFColor color)
side - - where to apply the color definitioncolor - - the color to usepublic int hashCode()
hashCode in class java.lang.Objectpublic boolean equals(java.lang.Object o)
equals in class java.lang.Objecto - the style to check
public java.lang.Object clone()
clone in class java.lang.Object
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||