Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
org.apache.poi.hssf.util |
The util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
|
org.apache.poi.ss.usermodel | |
org.apache.poi.xssf.model | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Class and Description |
---|---|
class |
HSSFExtendedColor
The HSSF file format normally stores Color information in the
Palette (see PaletteRecord), but for a few cases (eg Conditional
Formatting, Sheet Extensions), this XSSF-style color record
can be used.
|
Modifier and Type | Method and Description |
---|---|
Color |
HSSFBorderFormatting.getHorizontalBorderColorColor()
HSSF Doesn't support table borders, so always
HSSFColor.HSSFColorPredefined.AUTOMATIC |
Color |
HSSFBorderFormatting.getVerticalBorderColorColor()
HSSF Doesn't support table borders, so always
HSSFColor.HSSFColorPredefined.AUTOMATIC |
Modifier and Type | Method and Description |
---|---|
void |
HSSFBorderFormatting.setBottomBorderColor(Color color) |
void |
HSSFDataBarFormatting.setColor(Color color) |
void |
HSSFColorScaleFormatting.setColors(Color[] colors) |
void |
HSSFBorderFormatting.setDiagonalBorderColor(Color color) |
void |
HSSFPatternFormatting.setFillBackgroundColor(Color bg) |
void |
HSSFPatternFormatting.setFillForegroundColor(Color fg) |
void |
HSSFFontFormatting.setFontColor(Color color) |
void |
HSSFBorderFormatting.setHorizontalBorderColor(Color color)
Not available for HSSF.
|
void |
HSSFBorderFormatting.setLeftBorderColor(Color color) |
void |
HSSFBorderFormatting.setRightBorderColor(Color color) |
void |
HSSFBorderFormatting.setTopBorderColor(Color color) |
void |
HSSFBorderFormatting.setVerticalBorderColor(Color color)
Not available for HSSF.
|
Modifier and Type | Class and Description |
---|---|
class |
HSSFColor
Intends to provide support for the very evil index to triplet issue and
will likely replace the color constants interface for HSSF 2.0.
|
Modifier and Type | Method and Description |
---|---|
static HSSFColor |
HSSFColor.toHSSFColor(Color color)
Checked type cast color to an HSSFColor.
|
Modifier and Type | Class and Description |
---|---|
class |
ExtendedColor
Represents a XSSF-style color (based on either a
XSSFColor or a
ExtendedColor |
Modifier and Type | Method and Description |
---|---|
Color |
BorderFormatting.getBottomBorderColorColor() |
Color |
DataBarFormatting.getColor() |
Color[] |
ColorScaleFormatting.getColors()
Gets the list of colours that are interpolated
between.
|
Color |
BorderFormatting.getDiagonalBorderColorColor() |
Color |
CellStyle.getFillBackgroundColorColor()
Gets the color object representing the current
background fill, resolving indexes using
the supplied workbook.
|
Color |
PatternFormatting.getFillBackgroundColorColor() |
Color |
CellStyle.getFillForegroundColorColor()
Gets the color object representing the current
foreground fill, resolving indexes using
the supplied workbook.
|
Color |
PatternFormatting.getFillForegroundColorColor() |
Color |
FontFormatting.getFontColor() |
Color |
BorderFormatting.getHorizontalBorderColorColor()
Range internal borders.
|
Color |
BorderFormatting.getLeftBorderColorColor() |
Color |
BorderFormatting.getRightBorderColorColor() |
Color |
BorderFormatting.getTopBorderColorColor() |
Color |
BorderFormatting.getVerticalBorderColorColor()
Range internal borders.
|
Modifier and Type | Method and Description |
---|---|
void |
BorderFormatting.setBottomBorderColor(Color color) |
void |
DataBarFormatting.setColor(Color color) |
void |
ColorScaleFormatting.setColors(Color[] colors)
Sets the list of colours that are interpolated
between.
|
void |
BorderFormatting.setDiagonalBorderColor(Color color) |
void |
PatternFormatting.setFillBackgroundColor(Color bg) |
void |
PatternFormatting.setFillForegroundColor(Color fg) |
void |
FontFormatting.setFontColor(Color color)
Sets the colour to use
|
void |
BorderFormatting.setHorizontalBorderColor(Color color)
Range internal border color, such as table styles
|
void |
BorderFormatting.setLeftBorderColor(Color color) |
void |
BorderFormatting.setRightBorderColor(Color color) |
void |
BorderFormatting.setTopBorderColor(Color color) |
void |
BorderFormatting.setVerticalBorderColor(Color color)
Range internal border color, such as table styles
|
Modifier and Type | Method and Description |
---|---|
XSSFFont |
StylesTable.findFont(boolean bold,
Color color,
short fontHeight,
java.lang.String name,
boolean italic,
boolean strikeout,
short typeOffset,
byte underline)
Finds a font that matches the one with the supplied attributes,
where color is the actual Color-value, not the indexed color
|
Modifier and Type | Class and Description |
---|---|
class |
XSSFColor
Represents a color in SpreadsheetML
|
Modifier and Type | Method and Description |
---|---|
void |
XSSFBorderFormatting.setBottomBorderColor(Color color) |
void |
XSSFDataBarFormatting.setColor(Color color) |
void |
XSSFColorScaleFormatting.setColors(Color[] colors) |
void |
XSSFBorderFormatting.setDiagonalBorderColor(Color color) |
void |
XSSFPatternFormatting.setFillBackgroundColor(Color bg) |
void |
XSSFPatternFormatting.setFillForegroundColor(Color fg) |
void |
XSSFFontFormatting.setFontColor(Color color) |
void |
XSSFBorderFormatting.setHorizontalBorderColor(Color color) |
void |
XSSFBorderFormatting.setLeftBorderColor(Color color) |
void |
XSSFBorderFormatting.setRightBorderColor(Color color) |
void |
XSSFBorderFormatting.setTopBorderColor(Color color) |
void |
XSSFBorderFormatting.setVerticalBorderColor(Color color) |
static XSSFColor |
XSSFColor.toXSSFColor(Color color)
Checked type cast color to an XSSFColor.
|
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.