HSSFCellStyle
, XSSFCellStyle
public interface CellStyle
Modifier and Type | Field | Description |
---|---|---|
static short |
ALIGN_CENTER |
center horizontal alignment
|
static short |
ALIGN_CENTER_SELECTION |
center-selection? horizontal alignment
|
static short |
ALIGN_FILL |
fill? horizontal alignment
|
static short |
ALIGN_GENERAL |
general (normal) horizontal alignment
|
static short |
ALIGN_JUSTIFY |
justified horizontal alignment
|
static short |
ALIGN_LEFT |
left-justified horizontal alignment
|
static short |
ALIGN_RIGHT |
right-justified horizontal alignment
|
static short |
ALT_BARS |
Wide dots
|
static short |
BIG_SPOTS |
Large spots
|
static short |
BORDER_DASH_DOT |
dash-dot border
|
static short |
BORDER_DASH_DOT_DOT |
dash-dot-dot border
|
static short |
BORDER_DASHED |
dash border
|
static short |
BORDER_DOTTED |
hair-line border
|
static short |
BORDER_DOUBLE |
double-line border
|
static short |
BORDER_HAIR |
dot border
|
static short |
BORDER_MEDIUM |
Medium border
|
static short |
BORDER_MEDIUM_DASH_DOT |
medium dash-dot border
|
static short |
BORDER_MEDIUM_DASH_DOT_DOT |
medium dash-dot-dot border
|
static short |
BORDER_MEDIUM_DASHED |
Medium dashed border
|
static short |
BORDER_NONE |
No border
|
static short |
BORDER_SLANTED_DASH_DOT |
slanted dash-dot border
|
static short |
BORDER_THICK |
Thick border
|
static short |
BORDER_THIN |
Thin border
|
static short |
BRICKS |
Brick-like layout
|
static short |
DIAMONDS |
Diamonds
|
static short |
FINE_DOTS |
Small fine dots
|
static short |
LEAST_DOTS |
Least Dots
|
static short |
LESS_DOTS |
Less Dots
|
static short |
NO_FILL |
No background
|
static short |
SOLID_FOREGROUND |
Solidly filled
|
static short |
SPARSE_DOTS |
Sparse dots
|
static short |
SQUARES |
Squares
|
static short |
THICK_BACKWARD_DIAG |
Thick backward facing diagonals
|
static short |
THICK_FORWARD_DIAG |
Thick forward facing diagonals
|
static short |
THICK_HORZ_BANDS |
Thick horizontal bands
|
static short |
THICK_VERT_BANDS |
Thick vertical bands
|
static short |
THIN_BACKWARD_DIAG |
Thin backward diagonal
|
static short |
THIN_FORWARD_DIAG |
Thin forward diagonal
|
static short |
THIN_HORZ_BANDS |
Thin horizontal bands
|
static short |
THIN_VERT_BANDS |
Thin vertical bands
|
static short |
VERTICAL_BOTTOM |
bottom-aligned vertical alignment
|
static short |
VERTICAL_CENTER |
center-aligned vertical alignment
|
static short |
VERTICAL_JUSTIFY |
vertically justified vertical alignment
|
static short |
VERTICAL_TOP |
top-aligned vertical alignment
|
Modifier and Type | Method | Description |
---|---|---|
void |
cloneStyleFrom(CellStyle source) |
Clones all the style information from another
CellStyle, onto this one.
|
short |
getAlignment() |
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
|
short |
getBorderLeft() |
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
|
short |
getBorderTop() |
get the type of border to use for the top border of the cell
|
short |
getBottomBorderColor() |
get the color to use for the left border
|
short |
getDataFormat() |
get the index of the format
|
java.lang.String |
getDataFormatString() |
Get the format string
|
short |
getFillBackgroundColor() |
get the background fill color, if the fill
is defined with an indexed color.
|
Color |
getFillBackgroundColorColor() |
Gets the color object representing the current
background fill, resolving indexes using
the supplied workbook.
|
short |
getFillForegroundColor() |
get the foreground fill color, if the fill
is defined with an indexed color.
|
Color |
getFillForegroundColorColor() |
Gets the color object representing the current
foreground fill, resolving indexes using
the supplied workbook.
|
short |
getFillPattern() |
get the fill pattern (??) - set to 1 to fill with foreground color
|
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 Workbook (sequence within the collection of ExtnededFormat objects)
|
short |
getLeftBorderColor() |
get the color to use for the left border
|
boolean |
getLocked() |
get whether the cell's using this style are to be locked
|
short |
getRightBorderColor() |
get the color to use for the left border
|
short |
getRotation() |
get the degree of rotation for the text in the cell
|
boolean |
getShrinkToFit() |
Should the Cell be auto-sized by Excel to shrink
it to fit if this text is too long?
|
short |
getTopBorderColor() |
get the color to use for the top border
|
short |
getVerticalAlignment() |
get the type of vertical alignment for the cell
|
boolean |
getWrapText() |
get whether the text should be wrapped
|
void |
setAlignment(short align) |
set the type of horizontal alignment for the cell
|
void |
setBorderBottom(short border) |
set the type of border to use for the bottom border of the cell
|
void |
setBorderLeft(short border) |
set the type of border to use for the left border of the cell
|
void |
setBorderRight(short border) |
set the type of border to use for the right 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 |
setDataFormat(short fmt) |
set the data format (must be a valid format)
|
void |
setFillBackgroundColor(short bg) |
set the background fill color.
|
void |
setFillForegroundColor(short bg) |
set the foreground fill color
Note: Ensure Foreground color is set prior to background color.
|
void |
setFillPattern(short fp) |
setting to one fills the cell with the foreground color...
|
void |
setFont(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
|
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 |
setRotation(short rotation) |
set the degree of rotation for the text in the cell
|
void |
setShrinkToFit(boolean shrinkToFit) |
Controls if the Cell should be auto-sized
to shrink to fit if the text is too long
|
void |
setTopBorderColor(short color) |
set the color to use for the top border
|
void |
setVerticalAlignment(short align) |
set the type of vertical alignment for the cell
|
void |
setWrapText(boolean wrapped) |
Set whether the text should be wrapped.
|
static final short ALIGN_GENERAL
static final short ALIGN_LEFT
static final short ALIGN_CENTER
static final short ALIGN_RIGHT
static final short ALIGN_FILL
static final short ALIGN_JUSTIFY
static final short ALIGN_CENTER_SELECTION
static final short VERTICAL_TOP
static final short VERTICAL_CENTER
static final short VERTICAL_BOTTOM
static final short VERTICAL_JUSTIFY
static final short BORDER_NONE
static final short BORDER_THIN
static final short BORDER_MEDIUM
static final short BORDER_DASHED
static final short BORDER_HAIR
static final short BORDER_THICK
static final short BORDER_DOUBLE
static final short BORDER_DOTTED
static final short BORDER_MEDIUM_DASHED
static final short BORDER_DASH_DOT
static final short BORDER_MEDIUM_DASH_DOT
static final short BORDER_DASH_DOT_DOT
static final short BORDER_MEDIUM_DASH_DOT_DOT
static final short BORDER_SLANTED_DASH_DOT
static final short NO_FILL
static final short SOLID_FOREGROUND
static final short FINE_DOTS
static final short ALT_BARS
static final short SPARSE_DOTS
static final short THICK_HORZ_BANDS
static final short THICK_VERT_BANDS
static final short THICK_BACKWARD_DIAG
static final short THICK_FORWARD_DIAG
static final short BIG_SPOTS
static final short BRICKS
static final short THIN_HORZ_BANDS
static final short THIN_VERT_BANDS
static final short THIN_BACKWARD_DIAG
static final short THIN_FORWARD_DIAG
static final short SQUARES
static final short DIAMONDS
static final short LESS_DOTS
static final short LEAST_DOTS
short getIndex()
void setDataFormat(short fmt)
DataFormat
short getDataFormat()
DataFormat
java.lang.String getDataFormatString()
void setFont(Font font)
font
- a font object created or retreived from the Workbook objectWorkbook.createFont()
,
Workbook.getFontAt(short)
short getFontIndex()
Workbook.getFontAt(short)
void setHidden(boolean hidden)
hidden
- - whether the cell using this style should be hiddenboolean getHidden()
void setLocked(boolean locked)
locked
- - whether the cell using this style should be lockedboolean getLocked()
void setAlignment(short align)
align
- - the type of alignmentALIGN_GENERAL
,
ALIGN_LEFT
,
ALIGN_CENTER
,
ALIGN_RIGHT
,
ALIGN_FILL
,
ALIGN_JUSTIFY
,
ALIGN_CENTER_SELECTION
short getAlignment()
ALIGN_GENERAL
,
ALIGN_LEFT
,
ALIGN_CENTER
,
ALIGN_RIGHT
,
ALIGN_FILL
,
ALIGN_JUSTIFY
,
ALIGN_CENTER_SELECTION
void setWrapText(boolean wrapped)
true
make all content visible
whithin a cell by displaying it on multiple lineswrapped
- wrap text or notboolean getWrapText()
void setVerticalAlignment(short align)
align
- the type of alignmentVERTICAL_TOP
,
VERTICAL_CENTER
,
VERTICAL_BOTTOM
,
VERTICAL_JUSTIFY
short getVerticalAlignment()
VERTICAL_TOP
,
VERTICAL_CENTER
,
VERTICAL_BOTTOM
,
VERTICAL_JUSTIFY
void setRotation(short rotation)
rotation
- degrees (between -90 and 90 degrees)short getRotation()
void setIndention(short indent)
indent
- - number of spacesshort getIndention()
void setBorderLeft(short border)
border
- typeBORDER_NONE
,
BORDER_THIN
,
BORDER_MEDIUM
,
BORDER_DASHED
,
BORDER_DOTTED
,
BORDER_THICK
,
BORDER_DOUBLE
,
BORDER_HAIR
,
BORDER_MEDIUM_DASHED
,
BORDER_DASH_DOT
,
BORDER_MEDIUM_DASH_DOT
,
BORDER_DASH_DOT_DOT
,
BORDER_MEDIUM_DASH_DOT_DOT
,
BORDER_SLANTED_DASH_DOT
short getBorderLeft()
BORDER_NONE
,
BORDER_THIN
,
BORDER_MEDIUM
,
BORDER_DASHED
,
BORDER_DOTTED
,
BORDER_THICK
,
BORDER_DOUBLE
,
BORDER_HAIR
,
BORDER_MEDIUM_DASHED
,
BORDER_DASH_DOT
,
BORDER_MEDIUM_DASH_DOT
,
BORDER_DASH_DOT_DOT
,
BORDER_MEDIUM_DASH_DOT_DOT
,
BORDER_SLANTED_DASH_DOT
void setBorderRight(short border)
border
- typeBORDER_NONE
,
BORDER_THIN
,
BORDER_MEDIUM
,
BORDER_DASHED
,
BORDER_DOTTED
,
BORDER_THICK
,
BORDER_DOUBLE
,
BORDER_HAIR
,
BORDER_MEDIUM_DASHED
,
BORDER_DASH_DOT
,
BORDER_MEDIUM_DASH_DOT
,
BORDER_DASH_DOT_DOT
,
BORDER_MEDIUM_DASH_DOT_DOT
,
BORDER_SLANTED_DASH_DOT
short getBorderRight()
BORDER_NONE
,
BORDER_THIN
,
BORDER_MEDIUM
,
BORDER_DASHED
,
BORDER_DOTTED
,
BORDER_THICK
,
BORDER_DOUBLE
,
BORDER_HAIR
,
BORDER_MEDIUM_DASHED
,
BORDER_DASH_DOT
,
BORDER_MEDIUM_DASH_DOT
,
BORDER_DASH_DOT_DOT
,
BORDER_MEDIUM_DASH_DOT_DOT
,
BORDER_SLANTED_DASH_DOT
void setBorderTop(short border)
border
- typeBORDER_NONE
,
BORDER_THIN
,
BORDER_MEDIUM
,
BORDER_DASHED
,
BORDER_DOTTED
,
BORDER_THICK
,
BORDER_DOUBLE
,
BORDER_HAIR
,
BORDER_MEDIUM_DASHED
,
BORDER_DASH_DOT
,
BORDER_MEDIUM_DASH_DOT
,
BORDER_DASH_DOT_DOT
,
BORDER_MEDIUM_DASH_DOT_DOT
,
BORDER_SLANTED_DASH_DOT
short getBorderTop()
BORDER_NONE
,
BORDER_THIN
,
BORDER_MEDIUM
,
BORDER_DASHED
,
BORDER_DOTTED
,
BORDER_THICK
,
BORDER_DOUBLE
,
BORDER_HAIR
,
BORDER_MEDIUM_DASHED
,
BORDER_DASH_DOT
,
BORDER_MEDIUM_DASH_DOT
,
BORDER_DASH_DOT_DOT
,
BORDER_MEDIUM_DASH_DOT_DOT
,
BORDER_SLANTED_DASH_DOT
void setBorderBottom(short border)
border
- typeBORDER_NONE
,
BORDER_THIN
,
BORDER_MEDIUM
,
BORDER_DASHED
,
BORDER_DOTTED
,
BORDER_THICK
,
BORDER_DOUBLE
,
BORDER_HAIR
,
BORDER_MEDIUM_DASHED
,
BORDER_DASH_DOT
,
BORDER_MEDIUM_DASH_DOT
,
BORDER_DASH_DOT_DOT
,
BORDER_MEDIUM_DASH_DOT_DOT
,
BORDER_SLANTED_DASH_DOT
short getBorderBottom()
BORDER_NONE
,
BORDER_THIN
,
BORDER_MEDIUM
,
BORDER_DASHED
,
BORDER_DOTTED
,
BORDER_THICK
,
BORDER_DOUBLE
,
BORDER_HAIR
,
BORDER_MEDIUM_DASHED
,
BORDER_DASH_DOT
,
BORDER_MEDIUM_DASH_DOT
,
BORDER_DASH_DOT_DOT
,
BORDER_MEDIUM_DASH_DOT_DOT
,
BORDER_SLANTED_DASH_DOT
void setLeftBorderColor(short color)
color
- The index of the color definitionshort getLeftBorderColor()
void setRightBorderColor(short color)
color
- The index of the color definitionshort getRightBorderColor()
void setTopBorderColor(short color)
color
- The index of the color definitionshort getTopBorderColor()
void setBottomBorderColor(short color)
color
- The index of the color definitionshort getBottomBorderColor()
void setFillPattern(short fp)
fp
- fill pattern (set to 1 to fill w/foreground color)NO_FILL
,
SOLID_FOREGROUND
,
FINE_DOTS
,
ALT_BARS
,
SPARSE_DOTS
,
THICK_HORZ_BANDS
,
THICK_VERT_BANDS
,
THICK_BACKWARD_DIAG
,
THICK_FORWARD_DIAG
,
BIG_SPOTS
,
BRICKS
,
THIN_HORZ_BANDS
,
THIN_VERT_BANDS
,
THIN_BACKWARD_DIAG
,
THIN_FORWARD_DIAG
,
SQUARES
,
DIAMONDS
short getFillPattern()
void setFillBackgroundColor(short bg)
bg
- colorshort getFillBackgroundColor()
Color getFillBackgroundColorColor()
void setFillForegroundColor(short bg)
bg
- colorshort getFillForegroundColor()
Color getFillForegroundColorColor()
void cloneStyleFrom(CellStyle source)
void setShrinkToFit(boolean shrinkToFit)
boolean getShrinkToFit()
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.