public interface CellStyle
Modifier and Type | Field and Description |
---|---|
static short |
ALIGN_CENTER
center horizontal alignment
|
static short |
ALIGN_CENTER_SELECTION
center-selection?
|
static short |
ALIGN_FILL
fill?
|
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
dot border
|
static short |
BORDER_DOUBLE
double-line border
|
static short |
BORDER_HAIR
hair-line 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 and 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 |
getBorderDiagonal()
get the type of border to use for the diagonal 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
|
Color |
getBottomBorderColorColor() |
short |
getDataFormat()
get the index of the format
|
java.lang.String |
getDataFormatString()
Get the format string
|
short |
getDiagonalBorderColor()
get the color to use for the diagonal border
|
Color |
getDiagonalBorderColorColor() |
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 (??)
|
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
|
int |
getIndex()
get the index within the Workbook (sequence within the collection of ExtnededFormat objects)
Note since 3.9.9 we have changed the return value type from short to int because the limit of
distinct cell styles in Excel 2007 and beyond is 64000 while that of Excel 97-2003 is 4000
only; have to extend it to accommodate the capacity.
|
short |
getLeftBorderColor()
get the color to use for the left border
|
Color |
getLeftBorderColorColor() |
boolean |
getLocked()
get whether the cell's using this style are to be locked
|
java.lang.String |
getRawDataFormatString()
Get the raw data format string that are not transfered by ZSS Context Locale
|
short |
getRightBorderColor()
get the color to use for the left border
|
Color |
getRightBorderColorColor() |
short |
getRotation()
get the degree of rotation for the text in the cell
|
short |
getTopBorderColor()
get the color to use for the top border
|
Color |
getTopBorderColorColor() |
short |
getVerticalAlignment()
get the type of vertical alignment for the cell
|
boolean |
getWrapText()
get whether the text should be wrapped
|
boolean |
isBuiltinDataFormat()
Check if the data format is build in format
|
boolean |
isShowDiagonalDownBorder()
Whether show diagonalDown diagonal border
|
boolean |
isShowDiagonalUpBorder()
Whether show diagonalUp diagonal border
|
void |
setAlignment(short align)
set the type of horizontal alignment for the cell
|
void |
setBorder(short left,
Color leftColor,
short top,
Color topColor,
short right,
Color rightColor,
short bottom,
Color bottomColor) |
void |
setBorder(short left,
Color leftColor,
short top,
Color topColor,
short right,
Color rightColor,
short bottom,
Color bottomColor,
short diagonal,
Color diagonalColor,
short horizontal,
Color horizontalColor,
short vertical,
Color verticalColor,
boolean diaUp,
boolean diaDown) |
void |
setBorderBottom(short border)
set the type of border to use for the bottom border of the cell
|
void |
setBorderDiagonal(short border)
set the type of border to use for the diagonal 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 |
setCellAlignment(short hAlign,
short vAlign,
boolean wrapText)
Deprecated.
|
void |
setCellAlignment(short hAlign,
short vAlign,
boolean wrapText,
short rotation) |
void |
setDataFormat(short fmt)
set the data format (must be a valid format)
|
void |
setDiagonalBorderColor(short color)
set the color to use for the diagonal border
|
void |
setFill(Color fillColor,
Color backColor,
short pattern) |
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 |
setFontColorColor(Color fontColor) |
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 |
setProtection(boolean locked,
boolean hidden) |
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 |
setShowDiagonalDownBorder(boolean down)
Whether show diagonalDown diagonal border
|
void |
setShowDiagonalUpBorder(boolean up)
Whether show diagonalUp diagonal border
|
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_DOTTED
static final short BORDER_THICK
static final short BORDER_DOUBLE
static final short BORDER_HAIR
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
int getIndex()
void setDataFormat(short fmt)
DataFormat
short getDataFormat()
DataFormat
java.lang.String getDataFormatString()
java.lang.String getRawDataFormatString()
boolean isBuiltinDataFormat()
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)
Color getTopBorderColorColor()
Color getBottomBorderColorColor()
Color getRightBorderColorColor()
Color getLeftBorderColorColor()
void setFontColorColor(Color fontColor)
void setBorder(short left, Color leftColor, short top, Color topColor, short right, Color rightColor, short bottom, Color bottomColor)
void setBorder(short left, Color leftColor, short top, Color topColor, short right, Color rightColor, short bottom, Color bottomColor, short diagonal, Color diagonalColor, short horizontal, Color horizontalColor, short vertical, Color verticalColor, boolean diaUp, boolean diaDown)
@Deprecated void setCellAlignment(short hAlign, short vAlign, boolean wrapText)
void setCellAlignment(short hAlign, short vAlign, boolean wrapText, short rotation)
void setProtection(boolean locked, boolean hidden)
void setBorderDiagonal(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 getBorderDiagonal()
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
Color getDiagonalBorderColorColor()
void setDiagonalBorderColor(short color)
color
- The index of the color definitionshort getDiagonalBorderColor()
boolean isShowDiagonalUpBorder()
void setShowDiagonalUpBorder(boolean up)
boolean isShowDiagonalDownBorder()
void setShowDiagonalDownBorder(boolean down)
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.