Public Types
enum	Color { AQUA = (HSSFColor.AQUA.index), AUTOMATIC = (HSSFColor.AUTOMATIC.index), BLACK = (HSSFColor.BLACK.index), BLUE = (HSSFColor.BLUE.index), BLUE_GREY = (HSSFColor.BLUE_GREY.index), BRIGHT_GREEN = (HSSFColor.BRIGHT_GREEN.index), BROWN = (HSSFColor.BROWN.index), CORAL = (HSSFColor.CORAL.index), CORNFLOWER_BLUE = (HSSFColor.CORNFLOWER_BLUE.index), DARK_BLUE = (HSSFColor.DARK_BLUE.index), DARK_GREEN = (HSSFColor.DARK_GREEN.index), DARK_RED = (HSSFColor.DARK_RED.index), DARK_TEAL = (HSSFColor.DARK_TEAL.index), DARK_YELLOW = (HSSFColor.DARK_YELLOW.index), GOLD = (HSSFColor.GOLD.index), GREEN = (HSSFColor.GREEN.index), GREY_25_PERCENT = (HSSFColor.GREY_25_PERCENT.index), GREY_40_PERCENT = (HSSFColor.GREY_40_PERCENT.index), GREY_50_PERCENT = (HSSFColor.GREY_50_PERCENT.index), GREY_80_PERCENT = (HSSFColor.GREY_80_PERCENT.index), INDIGO = (HSSFColor.INDIGO.index), LAVENDER = (HSSFColor.LAVENDER.index), LEMON_CHIFFON = (HSSFColor.LEMON_CHIFFON.index), LIGHT_BLUE = (HSSFColor.LIGHT_BLUE.index), LIGHT_CORNFLOWER_BLUE = (HSSFColor.LIGHT_CORNFLOWER_BLUE.index), LIGHT_GREEN = (HSSFColor.LIGHT_GREEN.index), LIGHT_ORANGE = (HSSFColor.LIGHT_ORANGE.index), LIGHT_TURQUOISE = (HSSFColor.LIGHT_TURQUOISE.index), LIGHT_YELLOW = (HSSFColor.LIGHT_YELLOW.index), LIME = (HSSFColor.LIME.index), MAROON = (HSSFColor.MAROON.index), OLIVE_GREEN = (HSSFColor.OLIVE_GREEN.index), ORANGE = (HSSFColor.ORANGE.index), ORCHID = (HSSFColor.ORCHID.index), PALE_BLUE = (HSSFColor.PALE_BLUE.index), PINK = (HSSFColor.PINK.index), PLUM = (HSSFColor.PLUM.index), RED = (HSSFColor.RED.index), ROSE = (HSSFColor.ROSE.index), ROYAL_BLUE = (HSSFColor.ROYAL_BLUE.index), SEA_GREEN = (HSSFColor.SEA_GREEN.index), SKY_BLUE = (HSSFColor.SKY_BLUE.index), TAN = (HSSFColor.TAN.index), TEAL = (HSSFColor.TEAL.index), TURQUOISE = (HSSFColor.TURQUOISE.index), VIOLET = (HSSFColor.VIOLET.index), WHITE = (HSSFColor.WHITE.index), YELLOW = (HSSFColor.YELLOW.index) }
enum	BorderTypes { BORDER_NONE = ((short)0), BORDER_THIN = ((short)1), BORDER_MEDIUM = ((short)2), BORDER_DASHED = ((short)3), BORDER_HAIR = ((short)4), BORDER_THICK = ((short)5), BORDER_DOUBLE = ((short)6), BORDER_DOTTED = ((short)7), BORDER_MEDIUM_DASHED = ((short)8), BORDER_DASH_DOT = ((short)9), BORDER_MEDIUM_DASH_DOT = ((short)10), BORDER_DASH_DOT_DOT = ((short)11), BORDER_MEDIUM_DASH_DOT_DOT = ((short)12), BORDER_SLANTED_DASH_DOT = ((short)13) }
enum	HorizontalAlignment { CENTER = (CellStyle.ALIGN_CENTER), RIGHT = (CellStyle.ALIGN_RIGHT), LEFT = (CellStyle.ALIGN_LEFT) }
enum	VerticalAlignment { CENTER = (CellStyle.VERTICAL_CENTER), BOTTOM = (CellStyle.VERTICAL_BOTTOM), TOP = (CellStyle.VERTICAL_TOP) }
Public Member Functions
void	setBorderStyle (BorderSide borderSide, BorderTypes type)
void	setBorderColor (BorderSide borderSide, Color color)
void	setTextDecoration (boolean isBold, boolean isItalic, boolean isUnderlined, boolean isStrikeOut)
void	setFontStyle (String fontName, short height, Color fontColor)
void	setHAlign (HorizontalAlignment align)
void	setVAlign (VerticalAlignment align)
void	setBackGroundColor (Color backGroundColor)
void	setDataFormat (String dataFormat)

Detailed Description

Representation of an excel cell style.

Member Enumeration Documentation

enum com::mendix::modules::exportmanager::interfaces::excel::IExcelCellStyle::BorderTypes

Enumerator:

BORDER_NONE
BORDER_THIN
BORDER_MEDIUM
BORDER_DASHED
BORDER_HAIR
BORDER_THICK
BORDER_DOUBLE
BORDER_DOTTED
BORDER_MEDIUM_DASHED
BORDER_DASH_DOT
BORDER_MEDIUM_DASH_DOT
BORDER_DASH_DOT_DOT
BORDER_MEDIUM_DASH_DOT_DOT
BORDER_SLANTED_DASH_DOT

enum com::mendix::modules::exportmanager::interfaces::excel::IExcelCellStyle::Color

Enumerator:

AQUA
AUTOMATIC
BLACK
BLUE
BLUE_GREY
BRIGHT_GREEN
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_YELLOW
LIME
MAROON
OLIVE_GREEN
ORANGE
ORCHID
PALE_BLUE
PINK
PLUM
RED
ROSE
ROYAL_BLUE
SEA_GREEN
SKY_BLUE
TAN
TEAL
TURQUOISE
VIOLET
WHITE
YELLOW

enum com::mendix::modules::exportmanager::interfaces::excel::IExcelCellStyle::HorizontalAlignment

Enumerator:

CENTER
RIGHT
LEFT

enum com::mendix::modules::exportmanager::interfaces::excel::IExcelCellStyle::VerticalAlignment

Enumerator:

CENTER
BOTTOM
TOP

Member Function Documentation

void com.mendix.modules.exportmanager.interfaces.excel.IExcelCellStyle.setBackGroundColor ( Color backGroundColor )

Set the background color of a cell

Parameters:

backGroundColor

void com.mendix.modules.exportmanager.interfaces.excel.IExcelCellStyle.setBorderColor	(	BorderSide	borderSide,
		Color	color
	)

Set the border color for a given border side

Parameters:

borderSide	the border side
color	the color

void com.mendix.modules.exportmanager.interfaces.excel.IExcelCellStyle.setBorderStyle	(	BorderSide	borderSide,
		BorderTypes	type
	)

Set a border style for a given border side

Parameters:

borderSide	the border side
type	the border type

void com.mendix.modules.exportmanager.interfaces.excel.IExcelCellStyle.setDataFormat ( String dataFormat )

Set the data format of a cell

Parameters:

dataFormat

void com.mendix.modules.exportmanager.interfaces.excel.IExcelCellStyle.setFontStyle	(	String	fontName,
		short	height,
		Color	fontColor
	)

Set the font style

Parameters:

fontName
height
fontColor

void com.mendix.modules.exportmanager.interfaces.excel.IExcelCellStyle.setHAlign ( HorizontalAlignment align )

Set horizontal alignment of text in a cell

Parameters:

align

void com.mendix.modules.exportmanager.interfaces.excel.IExcelCellStyle.setTextDecoration	(	boolean	isBold,
		boolean	isItalic,
		boolean	isUnderlined,
		boolean	isStrikeOut
	)

Set text decoration

Parameters:

isBold
isItalic
isUnderlined
isStrikeOut

void com.mendix.modules.exportmanager.interfaces.excel.IExcelCellStyle.setVAlign ( VerticalAlignment align )

Set vertical alignment of text in a cell

Parameters:

align

The documentation for this interface was generated from the following file:

IExcelCellStyle.java

Public Types

Public Member Functions

Detailed Description

Member Enumeration Documentation

Member Function Documentation