Example usage for Java org.apache.poi.hssf.usermodel HSSFCellStyle fields, constructors, methods, implement or subclass
The text is from its open source code.
| void | cloneStyleFrom(CellStyle source) Clones all the style information from another HSSFCellStyle, onto this one. |
| void | cloneStyleFrom(HSSFCellStyle source) |
| 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 left border |
| short | getDataFormat() get the index of the format |
| String | getDataFormatString() Get the contents of the format string, by looking up the DataFormat against the bound workbook |
| short | getFillBackgroundColor() Get the background fill color. |
| HSSFColor | getFillBackgroundColorColor() |
| short | getFillForegroundColor() Get the foreground fill color. |
| HSSFColor | getFillForegroundColorColor() |
| FillPatternType | getFillPattern() |
| FillPatternType | getFillPatternEnum() |
| HSSFFont | getFont(org.apache.poi.ss.usermodel.Workbook parentWorkbook) 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 HSSFWorkbook (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 |
| HSSFCellStyle | getParentStyle() Return the parent style for this cell style. |
| short | getRightBorderColor() get the color to use for the left border |
| short | getRotation() get the degree of rotation for the text in the cell |
| short | getTopBorderColor() get the color to use for the top border |
| String | getUserStyleName() Gets the name of the user defined style. |
| VerticalAlignment | getVerticalAlignment() |
| VerticalAlignment | getVerticalAlignmentEnum() |
| boolean | getWrapText() get 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 | 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 | 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(FillPatternType fp) setting to one fills the cell with the foreground color... |
| void | setFont(Font font) set the font for this style |
| void | setFont(HSSFFont font) |
| 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 Note: HSSF uses values from -90 to 90 degrees, whereas XSSF uses values from 0 to 180 degrees. |
| 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 | setUserStyleName(String styleName) Sets the name of the user defined style. |
| void | setVerticalAlignment(VerticalAlignment align) set the type of vertical alignment for the cell |
| void | setWrapText(boolean wrapped) set whether the text should be wrapped |