Example usage for Java org.apache.poi.xssf.usermodel XSSFCellStyle fields, constructors, methods, implement or subclass
The text is from its open source code.
| XSSFCellStyle(int cellXfId, int cellStyleXfId, StylesTable stylesSource, ThemesTable theme) Creates a Cell Style from the supplied parts |
| Object | clone() Make a copy of this style. |
| void | cloneStyleFrom(CellStyle source) Clones all the style information from another XSSFCellStyle, onto this one. |
| HorizontalAlignment | getAlignment() |
| HorizontalAlignment | getAlignmentEnum() |
| BorderStyle | getBorderBottom() |
| BorderStyle | getBorderBottomEnum() |
| BorderStyle | getBorderLeft() |
| BorderStyle | getBorderLeftEnum() |
| BorderStyle | getBorderRight() |
| BorderStyle | getBorderRightEnum() |
| BorderStyle | getBorderTop() |
| BorderStyle | getBorderTopEnum() |
| 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 |
| 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. |
| String | getDataFormatString() Get the contents of the format string, by looking up the StylesSource |
| short | getFillBackgroundColor() Get the background fill color. |
| XSSFColor | getFillBackgroundColorColor() |
| XSSFColor | getFillBackgroundXSSFColor() Get the background fill color. |
| short | getFillForegroundColor() Get the foreground fill color. |
| XSSFColor | getFillForegroundColorColor() |
| XSSFColor | getFillForegroundXSSFColor() Get the foreground fill color. |
| FillPatternType | getFillPattern() |
| FillPatternType | getFillPatternEnum() |
| 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 | 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 Expressed in degrees. |
| short | getTopBorderColor() Get the color to use for the top border |
| XSSFColor | getTopBorderXSSFColor() Get the color to use for the top border |
| VerticalAlignment | getVerticalAlignment() |
| VerticalAlignment | getVerticalAlignmentEnum() |
| boolean | getWrapText() Whether the text should be wrapped |
| void | setAlignment(HorizontalAlignment align) Set the type of horizontal alignment for the cell |
| void | setBorderBottom(BorderStyle border) Set the type of border to use for the bottom border of the cell |
| void | setBorderColor(BorderSide side, XSSFColor color) Set the color to use for the selected border |
| void | setBorderLeft(BorderStyle border) Set the type of border to use for the left border of the cell |
| void | setBorderRight(BorderStyle border) Set the type of border to use for the right border of the cell |
| void | setBorderTop(BorderStyle 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 | setDataFormat(int fmt) Set the index of a data format |
| void | setFillBackgroundColor(XSSFColor color) Set the background fill color represented as a XSSFColor value. |
| void | setFillBackgroundColor(short bg) Set the background fill color represented as a indexed color value. |
| void | setFillForegroundColor(XSSFColor color) Set the foreground 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 | setFillPattern(FillPatternType pattern) This element is used to specify cell fill information for pattern and solid color cell fills. |
| void | setFont(Font font) Set the font for this style |
| 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 | 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 Expressed in degrees. |
| void | setShrinkToFit(boolean shrinkToFit) |
| 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(VerticalAlignment align) Set the type of vertical alignment for the cell |
| void | setWrapText(boolean wrapped) Set whether the text should be wrapped. |