com.northconcepts.datapipeline.excel

Enum ExcelColorPalette

java.lang.Object

java.lang.Enum<ExcelColorPalette>

com.northconcepts.datapipeline.excel.ExcelColorPalette

All Implemented Interfaces:

Serializable, Comparable<ExcelColorPalette>

public enum ExcelColorPalette
extends Enum<ExcelColorPalette>

Excel-compatible indexed color palette (BIFF legacy)

Enum Constant Summary

Enum Constants

Enum Constant and Description
AQUA
AUTOMATIC
BLACK
BLACK1
BLUE
BLUE_GREY
BLUE1
BRIGHT_GREEN
BRIGHT_GREEN1
BROWN
CORAL
CORNFLOWER_BLUE
DARK_BLUE
DARK_GREEN
DARK_RED
DARK_TEAL
DARK_YELLOW
GOLD
GREEN
GREY_25_PERCENT
GREY_40_PERCENT
GREY_50_PERCENT
GREY_80_PERCENT
INDIGO
LAVENDER
LEMON_CHIFFON
LIGHT_BLUE
LIGHT_CORNFLOWER_BLUE
LIGHT_GREEN
LIGHT_ORANGE
LIGHT_TURQUOISE
LIGHT_TURQUOISE1
LIGHT_YELLOW
LIME
MAROON
OLIVE_GREEN
ORANGE
ORCHID
PALE_BLUE
PINK
PINK1
PLUM
RED
RED1
ROSE
ROYAL_BLUE
SEA_GREEN
SKY_BLUE
TAN
TEAL
TURQUOISE
TURQUOISE1
VIOLET
WHITE
WHITE1
YELLOW
YELLOW1

Method Summary

Modifier and Type	Method and Description
static ExcelColorPalette	fromHex(String hex) Finds a palette color by its hexadecimal representation.
static ExcelColorPalette	fromIndex(int index) Finds a palette color by its index.
static ExcelColorPalette	fromRgb(int red, int green, int blue) Finds a palette color by its RGB components.
Integer	getBlue() Gets the blue component of the color.
String	getDescription() Gets the description of the color.
ExcelColor	getExcelColor() Gets the ExcelColor instance for this palette color.
Integer	getGreen() Gets the green component of the color.
String	getHex() Gets the color as a hexadecimal string (e.g., "#RRGGBB").
Integer	getIndex() Gets the Excel color palette index.
Integer	getRed() Gets the red component of the color.
Integer	getRgb() Gets the RGB value as a single integer (0xRRGGBB format).
static ExcelColorPalette	valueOf(String name) Returns the enum constant of this type with the specified name.
static ExcelColorPalette[]	values() Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

BLACK1

public static final ExcelColorPalette BLACK1

WHITE1

public static final ExcelColorPalette WHITE1

RED1

public static final ExcelColorPalette RED1

BRIGHT_GREEN1

public static final ExcelColorPalette BRIGHT_GREEN1

BLUE1

public static final ExcelColorPalette BLUE1

YELLOW1

public static final ExcelColorPalette YELLOW1

PINK1

public static final ExcelColorPalette PINK1

TURQUOISE1

public static final ExcelColorPalette TURQUOISE1

BLACK

public static final ExcelColorPalette BLACK

WHITE

public static final ExcelColorPalette WHITE

RED

public static final ExcelColorPalette RED

BRIGHT_GREEN

public static final ExcelColorPalette BRIGHT_GREEN

BLUE

public static final ExcelColorPalette BLUE

YELLOW

public static final ExcelColorPalette YELLOW

PINK

public static final ExcelColorPalette PINK

TURQUOISE

public static final ExcelColorPalette TURQUOISE

DARK_RED

public static final ExcelColorPalette DARK_RED

GREEN

public static final ExcelColorPalette GREEN

DARK_BLUE

public static final ExcelColorPalette DARK_BLUE

DARK_YELLOW

public static final ExcelColorPalette DARK_YELLOW

VIOLET

public static final ExcelColorPalette VIOLET

TEAL

public static final ExcelColorPalette TEAL

GREY_25_PERCENT

public static final ExcelColorPalette GREY_25_PERCENT

GREY_50_PERCENT

public static final ExcelColorPalette GREY_50_PERCENT

CORNFLOWER_BLUE

public static final ExcelColorPalette CORNFLOWER_BLUE

MAROON

public static final ExcelColorPalette MAROON

LEMON_CHIFFON

public static final ExcelColorPalette LEMON_CHIFFON

LIGHT_TURQUOISE1

public static final ExcelColorPalette LIGHT_TURQUOISE1

ORCHID

public static final ExcelColorPalette ORCHID

CORAL

public static final ExcelColorPalette CORAL

ROYAL_BLUE

public static final ExcelColorPalette ROYAL_BLUE

LIGHT_CORNFLOWER_BLUE

public static final ExcelColorPalette LIGHT_CORNFLOWER_BLUE

SKY_BLUE

public static final ExcelColorPalette SKY_BLUE

LIGHT_TURQUOISE

public static final ExcelColorPalette LIGHT_TURQUOISE

LIGHT_GREEN

public static final ExcelColorPalette LIGHT_GREEN

LIGHT_YELLOW

public static final ExcelColorPalette LIGHT_YELLOW

PALE_BLUE

public static final ExcelColorPalette PALE_BLUE

ROSE

public static final ExcelColorPalette ROSE

LAVENDER

public static final ExcelColorPalette LAVENDER

TAN

public static final ExcelColorPalette TAN

LIGHT_BLUE

public static final ExcelColorPalette LIGHT_BLUE

AQUA

public static final ExcelColorPalette AQUA

LIME

public static final ExcelColorPalette LIME

GOLD

public static final ExcelColorPalette GOLD

LIGHT_ORANGE

public static final ExcelColorPalette LIGHT_ORANGE

ORANGE

public static final ExcelColorPalette ORANGE

BLUE_GREY

public static final ExcelColorPalette BLUE_GREY

GREY_40_PERCENT

public static final ExcelColorPalette GREY_40_PERCENT

DARK_TEAL

public static final ExcelColorPalette DARK_TEAL

SEA_GREEN

public static final ExcelColorPalette SEA_GREEN

DARK_GREEN

public static final ExcelColorPalette DARK_GREEN

OLIVE_GREEN

public static final ExcelColorPalette OLIVE_GREEN

BROWN

public static final ExcelColorPalette BROWN

PLUM

public static final ExcelColorPalette PLUM

INDIGO

public static final ExcelColorPalette INDIGO

GREY_80_PERCENT

public static final ExcelColorPalette GREY_80_PERCENT

AUTOMATIC

public static final ExcelColorPalette AUTOMATIC

Method Detail

values

public static ExcelColorPalette[] values()

Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:

for (ExcelColorPalette c : ExcelColorPalette.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static ExcelColorPalette valueOf(String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum type has no constant with the specified name

NullPointerException - if the argument is null

getIndex

public Integer getIndex()

Gets the Excel color palette index.

Returns:

the palette index

getRed

public Integer getRed()

Gets the red component of the color.

Returns:

the red component (0-255), or null for AUTOMATIC

getGreen

public Integer getGreen()

Gets the green component of the color.

Returns:

the green component (0-255), or null for AUTOMATIC

getBlue

public Integer getBlue()

Gets the blue component of the color.

Returns:

the blue component (0-255), or null for AUTOMATIC

getDescription

public String getDescription()

Gets the description of the color.

Returns:

the color description

getRgb

public Integer getRgb()

Gets the RGB value as a single integer (0xRRGGBB format).

Returns:

the RGB value, or null for AUTOMATIC

getHex

public String getHex()

Gets the color as a hexadecimal string (e.g., "#RRGGBB").

Returns:

the hex color string, or null for AUTOMATIC

getExcelColor

public ExcelColor getExcelColor()

Gets the ExcelColor instance for this palette color.

Returns:

the ExcelColor instance

fromIndex

public static ExcelColorPalette fromIndex(int index)

Finds a palette color by its index.

Parameters:

index - the palette index to search for

Returns:

the matching ExcelColorPalette, or null if not found

fromRgb

public static ExcelColorPalette fromRgb(int red,
                                        int green,
                                        int blue)

Finds a palette color by its RGB components.

Parameters:

red - the red component (0-255)

green - the green component (0-255)

blue - the blue component (0-255)

Returns:

the matching ExcelColorPalette, or null if not found

fromHex

public static ExcelColorPalette fromHex(String hex)

Finds a palette color by its hexadecimal representation.

Parameters:

hex - the hex color string (e.g., "#RRGGBB" or "RRGGBB")

Returns:

the matching ExcelColorPalette, or null if not found or invalid format