Package | Description |
---|---|
io.keikai.range.impl.imexp |
Keikai Spreadsheet Internal Range API Implementation classes.
|
org.zkoss.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.zkoss.poi.hssf.util |
util package contains tools needed for writing HSSF files that are not necessarily "real"
HSSF concepts.
|
org.zkoss.poi.ss.usermodel | |
org.zkoss.poi.xssf.usermodel | |
org.zkoss.poi.xssf.usermodel.extensions |
Modifier and Type | Field and Description |
---|---|
protected Map<SColor,Color> |
AbstractExcelExporter.colorTable |
Modifier and Type | Method and Description |
---|---|
static Color |
BookHelper.HTMLToColor(Workbook book,
String color) |
protected Color |
AbstractExcelExporter.toPOIColor(SColor color) |
Modifier and Type | Method and Description |
---|---|
static String |
BookHelper.colorToBackgroundHTML(Workbook book,
Color color) |
static String |
BookHelper.colorToBorderHTML(Workbook book,
Color color) |
static String |
BookHelper.colorToForegroundHTML(Workbook book,
Color color) |
static String |
BookHelper.colorToHTML(Workbook book,
Color color) |
static void |
BookHelper.setBottomBorderColor(CellStyle style,
Color color) |
static void |
BookHelper.setFillBackgroundColor(CellStyle newCellStyle,
Color xlsColor) |
static void |
BookHelper.setFillForegroundColor(CellStyle newCellStyle,
Color xlsColor) |
static void |
BookHelper.setFontColor(Workbook book,
Font font,
Color color) |
static void |
BookHelper.setLeftBorderColor(CellStyle style,
Color color) |
static void |
BookHelper.setRightBorderColor(CellStyle style,
Color color) |
static void |
BookHelper.setTopBorderColor(CellStyle style,
Color color) |
Modifier and Type | Method and Description |
---|---|
Color |
HSSFNamedStyle.getBottomBorderColorColor() |
Color |
HSSFNamedStyle.getDiagonalBorderColorColor() |
Color |
HSSFCellStyle.getDiagonalBorderColorColor() |
Color |
HSSFNamedStyle.getFillBackgroundColorColor() |
Color |
HSSFNamedStyle.getFillForegroundColorColor() |
Color |
HSSFNamedStyle.getLeftBorderColorColor() |
Color |
HSSFNamedStyle.getRightBorderColorColor() |
Color |
HSSFNamedStyle.getTopBorderColorColor() |
Modifier and Type | Method and Description |
---|---|
void |
HSSFNamedStyle.setBorder(short left,
Color leftColor,
short top,
Color topColor,
short right,
Color rightColor,
short bottom,
Color bottomColor) |
void |
HSSFCellStyle.setBorder(short left,
Color leftColor,
short top,
Color topColor,
short right,
Color rightColor,
short bottom,
Color bottomColor) |
void |
HSSFNamedStyle.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 |
HSSFCellStyle.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 |
HSSFNamedStyle.setFill(Color fillColor,
Color backColor,
short pattern) |
void |
HSSFCellStyle.setFill(Color fillColor,
Color backColor,
short pattern) |
void |
HSSFNamedStyle.setFontColorColor(Color fontColor) |
void |
HSSFCellStyle.setFontColorColor(Color color) |
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.
|
static class |
HSSFColor.AQUA
Class AQUA
|
static class |
HSSFColor.AUTOMATIC
Special Default/Normal/Automatic color.
|
static class |
HSSFColor.BLACK
Class BLACK
|
static class |
HSSFColor.BLUE
Class BLUE
|
static class |
HSSFColor.BLUE_GREY
Class BLUE_GREY
|
static class |
HSSFColor.BRIGHT_GREEN
Class BRIGHT_GREEN
|
static class |
HSSFColor.BROWN
Class BROWN
|
static class |
HSSFColor.CORAL
Class CORAL
|
static class |
HSSFColor.CORNFLOWER_BLUE
Class CORNFLOWER_BLUE
|
static class |
HSSFColor.DARK_BLUE
Class DARK_BLUE
|
static class |
HSSFColor.DARK_GREEN
Class DARK_GREEN
|
static class |
HSSFColor.DARK_RED
Class DARK_RED
|
static class |
HSSFColor.DARK_TEAL
Class DARK_TEAL
|
static class |
HSSFColor.DARK_YELLOW
Class DARK_YELLOW
|
static class |
HSSFColor.GOLD
Class GOLD
|
static class |
HSSFColor.GREEN
Class GREEN
|
static class |
HSSFColor.GREY_25_PERCENT
Class GREY_25_PERCENT
|
static class |
HSSFColor.GREY_40_PERCENT
Class GREY_40_PERCENT
|
static class |
HSSFColor.GREY_50_PERCENT
Class GREY_50_PERCENT
|
static class |
HSSFColor.GREY_80_PERCENT
Class GREY_80_PERCENT
|
static class |
HSSFColor.INDIGO
Class INDIGO
|
static class |
HSSFColor.LAVENDER
Class LAVENDER
|
static class |
HSSFColor.LEMON_CHIFFON
Class LEMON_CHIFFON
|
static class |
HSSFColor.LIGHT_BLUE
Class LIGHT_BLUE
|
static class |
HSSFColor.LIGHT_CORNFLOWER_BLUE
Class LIGHT_CORNFLOWER_BLUE
|
static class |
HSSFColor.LIGHT_GREEN
Class LIGHT_GREEN
|
static class |
HSSFColor.LIGHT_ORANGE
Class LIGHT_ORANGE
|
static class |
HSSFColor.LIGHT_TURQUOISE
Class LIGHT_TURQUOISE
|
static class |
HSSFColor.LIGHT_YELLOW
Class LIGHT_YELLOW
|
static class |
HSSFColor.LIME
Class LIME
|
static class |
HSSFColor.MAROON
Class MAROON
|
static class |
HSSFColor.OLIVE_GREEN
Class OLIVE_GREEN
|
static class |
HSSFColor.ORANGE
Class ORANGE
|
static class |
HSSFColor.ORCHID
Class ORCHID
|
static class |
HSSFColor.PALE_BLUE
Class PALE_BLUE
|
static class |
HSSFColor.PINK
Class PINK
|
static class |
HSSFColor.PLUM
Class PLUM
|
static class |
HSSFColor.RED
Class RED
|
static class |
HSSFColor.ROSE
Class ROSE
|
static class |
HSSFColor.ROYAL_BLUE
Class ROYAL_BLUE
|
static class |
HSSFColor.SEA_GREEN
Class SEA_GREEN
|
static class |
HSSFColor.SKY_BLUE
Class SKY_BLUE
|
static class |
HSSFColor.TAN
Class TAN
|
static class |
HSSFColor.TEAL
Class TEAL
|
static class |
HSSFColor.TURQUOISE
Class TURQUOISE
|
static class |
HSSFColor.VIOLET
Class VIOLET
|
static class |
HSSFColor.WHITE
Class WHITE
|
static class |
HSSFColor.YELLOW
Class YELLOW
|
class |
HSSFColorExt
HSSFColor that wrap FullColorExt.
|
Modifier and Type | Method and Description |
---|---|
Color |
CellStyle.getBottomBorderColorColor() |
Color |
CellStyle.getDiagonalBorderColorColor() |
Color |
CellStyle.getFillBackgroundColorColor()
Gets the color object representing the current
background fill, resolving indexes using
the supplied workbook.
|
Color |
CellStyle.getFillForegroundColorColor()
Gets the color object representing the current
foreground fill, resolving indexes using
the supplied workbook.
|
Color |
DxfCellStyle.getHorizontalBorderColorColor() |
Color |
CellStyle.getLeftBorderColorColor() |
Color |
DxfCellStyle.getRawBorderBottomColor()
Returns the embedded border line color in this DxfCellStyle; could be null.
|
Color |
DxfCellStyle.getRawBorderDiagonalColor()
Returns the embedded border line color in this DxfCellStyle; could be null.
|
Color |
DxfCellStyle.getRawBorderHorizontalColor()
Returns the embedded border line color in this DxfCellStyle; could be null.
|
Color |
DxfCellStyle.getRawBorderLeftColor()
Returns the embedded border line color in this DxfCellStyle; could be null.
|
Color |
DxfCellStyle.getRawBorderRightColor()
Returns the embedded border line color in this DxfCellStyle; could be null.
|
Color |
DxfCellStyle.getRawBorderTopColor()
Returns the embedded border line color in this DxfCellStyle; could be null.
|
Color |
DxfCellStyle.getRawBorderVerticalColor()
Returns the embedded border line color in this DxfCellStyle; could be null.
|
Color |
DxfCellStyle.getRawFillBackgroundColor()
Returns the embedded fill background color in this DxfCellStyle; could be null.
|
Color |
DxfCellStyle.getRawFillForegroundColor()
Returns the embedded fill forground color in this DxfCellStyle; could be null.
|
Color |
CellStyle.getRightBorderColorColor() |
Color |
CellStyle.getTopBorderColorColor() |
Color |
DxfCellStyle.getVerticalBorderColorColor() |
Modifier and Type | Method and Description |
---|---|
void |
CellStyle.setBorder(short left,
Color leftColor,
short top,
Color topColor,
short right,
Color rightColor,
short bottom,
Color bottomColor) |
void |
CellStyle.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 |
CellStyle.setFill(Color fillColor,
Color backColor,
short pattern) |
void |
CellStyle.setFontColorColor(Color fontColor) |
Modifier and Type | Class and Description |
---|---|
class |
XSSFColor
Represents a color in SpreadsheetML
|
Modifier and Type | Method and Description |
---|---|
void |
XSSFNamedStyle.setBorder(short left,
Color leftColor,
short top,
Color topColor,
short right,
Color rightColor,
short bottom,
Color bottomColor) |
void |
XSSFDxfCellStyle.setBorder(short left,
Color leftColor,
short top,
Color topColor,
short right,
Color rightColor,
short bottom,
Color bottomColor) |
void |
XSSFCellStyle.setBorder(short left,
Color leftColor,
short top,
Color topColor,
short right,
Color rightColor,
short bottom,
Color bottomColor) |
void |
XSSFNamedStyle.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 |
XSSFDxfCellStyle.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 |
XSSFCellStyle.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 |
XSSFNamedStyle.setFill(Color fillColor,
Color backColor,
short pattern) |
void |
XSSFDxfCellStyle.setFill(Color fillColor,
Color backColor,
short patternType) |
void |
XSSFCellStyle.setFill(Color fillColor,
Color backColor,
short patternType) |
void |
XSSFNamedStyle.setFontColorColor(Color fontColor) |
void |
XSSFDxfCellStyle.setFontColorColor(Color fontColor) |
void |
XSSFCellStyle.setFontColorColor(Color color) |
Modifier and Type | Method and Description |
---|---|
void |
XSSFCellBorder.prepareBorder(short left,
Color leftColor,
short top,
Color topColor,
short right,
Color rightColor,
short bottom,
Color bottomColor) |
void |
XSSFCellFill.prepareFill(Color fillColor,
Color backColor,
short patternType) |
Copyright © 2023. All rights reserved.