A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _

A

anchor(String) - Method in StringExtension

anchorColumn(String) - Method in StringExtension

anchorRow(String) - Method in StringExtension

applyBorderToRegion(CellRangeBorderStyleApplier, Map) - Method in CellStyleBuilder

applyColor(XSSFColor) - Method in BorderStyleApplier

applyColor(XSSFColor) - Method in CellRangeBorderStyleApplier

applyColor(XSSFColor) - Method in CellStyleBorderStyleApplier

applyColor(BorderSide, XSSFColor) - Method in ColumnCellRangeBorderStyleApplier

applyColor(BorderSide, XSSFColor) - Method in RowCellRangeBorderStyleApplier

applyStyle(BorderStyle) - Method in BorderStyleApplier

applyStyle(BorderStyle) - Method in CellRangeBorderStyleApplier

applyStyle(BorderStyle) - Method in CellStyleBorderStyleApplier

applyStyle(BorderSide, BorderStyle) - Method in ColumnCellRangeBorderStyleApplier

applyStyle(BorderSide, BorderStyle) - Method in RowCellRangeBorderStyleApplier

B

BACKGROUND_COLOR - Field in CellStyleBuilder

BORDER - Field in CellStyleBuilder

BorderStyleApplier - Interface in com.jameskleeh.excel.style

An interface used to apply colors and styles to borders

BOTTOM - Field in CellStyleBuilder

bottomRight - Field in CellRangeBorderStyleApplier

build(Closure) - Method in ExcelBuilder

Builds an excel document

buildStyle(Object, Map) - Method in CellStyleBuilder

A method to build a style object based on a map of parameters

C

cell(Object, Map) - Method in CreatesCells

Creates a new cell with a value and style

CellFinder - Class in com.jameskleeh.excel

A class to get references to cells for use in other functions

CellFinder(XSSFCell, Map<Object, Integer>) - Constructor in CellFinder

CellRangeBorderStyleApplier - Class in com.jameskleeh.excel.style

Applys styles and borders to a range of cells (merged).

CellRangeBorderStyleApplier(CellRangeAddress, XSSFSheet) - Constructor in CellRangeBorderStyleApplier

CellStyleBorderStyleApplier - Class in com.jameskleeh.excel.style

Applys styles and borders to a cell style object

CellStyleBuilder - Class in com.jameskleeh.excel

A class to build an org.apache.poi.xssf.usermodel.XSSFCellStyle from a map

CellStyleBuilder(XSSFWorkbook) - Constructor in CellStyleBuilder

COLOR - Field in CellStyleBuilder

Column - Class in com.jameskleeh.excel

A class designed to be a delegate when a column is created

Column(XSSFSheet, Map, Map<Object, Integer>, CellStyleBuilder, int, int) - Constructor in Column

column(String, Object, Map) - Method in CreatesCells

Creates a header cell

column(Closure) - Method in Sheet

Output data by column

ColumnCellRangeBorderStyleApplier - Class in com.jameskleeh.excel.style

Applys styles and borders to a single column of merged cells.

columnIndexes - Field in CreatesCells

columns(Map, Closure) - Method in Sheet

Used to define headers for a sheet

containsFont(Object) - Method in WorkbookCache

Determines if a font has been built for a given set of options

containsStyle(Object) - Method in WorkbookCache

Determines if a style has been built for a given set of options

convertSimpleOptions(Map) - Method in CellStyleBuilder

A method to convert global options into specific options.

CreatesCells - Class in com.jameskleeh.excel.internal

A base class used to create cells

CreatesCells(XSSFSheet, Map, Map<Object, Integer>, CellStyleBuilder) - Constructor in CreatesCells

D

defaultOptions - Field in CreatesCells

defaultStyle(Map) - Method in CreatesCells

Sets the default styles to use for the given row or column

defaultStyle(Map) - Method in Sheet

Sets the default styling for the sheet

E

exactCell(String) - Method in CellFinder

Retrieves an exact cell reference based on a previously defined column definition (created by CreatesCells.column

Excel - Class in com.jameskleeh.excel

A class to store cell renderers and formatters used to set cell data and format

ExcelBuilder - Class in com.jameskleeh.excel

The main class used to start building an excel document

F

FILL - Field in CellStyleBuilder

Font - Enum in com.jameskleeh.excel

Text decoration to apply to cell styles

FONT_BOLD - Field in CellStyleBuilder

FONT - Field in CellStyleBuilder

FONT_COLOR - Field in CellStyleBuilder

FONT_ITALIC - Field in CellStyleBuilder

FONT_NAME - Field in CellStyleBuilder

FONT_SIZE - Field in CellStyleBuilder

FONT_STRIKEOUT - Field in CellStyleBuilder

FONT_UNDERLINE - Field in CellStyleBuilder

FOREGROUND_COLOR - Field in CellStyleBuilder

FORMAT - Field in CellStyleBuilder

FORMAT_SEQUENCE - Field in Excel

formatEntries - Field in Excel

formula(Map, Closure) - Method in CreatesCells

Assigns a formula to a new cell

G

getBorderStyleApplier(CellRangeAddress, XSSFSheet) - Method in Column

getBorderStyleApplier(CellRangeAddress, XSSFSheet) - Method in CreatesCells

getBorderStyleApplier(CellRangeAddress, XSSFSheet) - Method in Row

getColumn() - Method in CellFinder

@return The current column (A..Z)

getFont(Object) - Method in WorkbookCache

@param obj Font options

getFormat(Class) - Method in Excel

Queries the formats registered

getMergeIndex() - Method in Column

getMergeIndex() - Method in CreatesCells

getMergeIndex() - Method in Row

getRange(int, int) - Method in Column

getRange(int, int) - Method in CreatesCells

getRange(int, int) - Method in Row

getRenderer(Class) - Method in Excel

Queries the renderers registered

getRow() - Method in CellFinder

@return The current row number (1 based)

getSheetName() - Method in CellFinder

@return The current sheet name

getStyle(Object) - Method in WorkbookCache

@param obj Style options

H

handleLink(XSSFCell, String, HyperlinkType) - Method in CreatesCells

HIDDEN - Field in CellStyleBuilder

HORIZONTAL_ALIGNMENT - Field in CellStyleBuilder

I

INDENT - Field in CellStyleBuilder

J

K

L

LEFT - Field in CellStyleBuilder

leftTop - Field in CellRangeBorderStyleApplier

link(Object, Closure) - Method in CreatesCells

Creates a cell with a hyperlink to another cell in the document

LINK_OPTIONS - Field in CreatesCells

LOCKED - Field in CellStyleBuilder

M

merge(Map) - Method in CellStyleBuilder

Merges multiple maps

merge(Closure) - Method in Column

@see CreatesCells#merge(Closure callable)

merge(Object, Integer, Map) - Method in CreatesCells

Merges cells

merge(Closure) - Method in Row

@see CreatesCells#merge(Closure callable)

middle - Field in CellRangeBorderStyleApplier

N

nextCell() - Method in Column

nextCell() - Method in CreatesCells

nextCell() - Method in Row

O

output(OutputStream, Closure) - Method in ExcelBuilder

Builds an excel document and sends the data to an output stream.

P

performMerge(Map, Closure) - Method in CreatesCells

putFont(Object, XSSFFont) - Method in WorkbookCache

Adds a font to the cache

putStyle(Object, XSSFCellStyle) - Method in WorkbookCache

Adds a style to the cache

Q

R

registerCellFormat(Class, int) - Method in Excel

Registers a cell format

registerCellRenderer(Class, Closure) - Method in Excel

Registers a cell renderer.

relativeCell(int) - Method in CellFinder

Retrieves a cell relative to the current cell.

RENDERER_SEQUENCE - Field in Excel

rendererEntries - Field in Excel

RIGHT - Field in CellStyleBuilder

ROTATION - Field in CellStyleBuilder

Row - Class in com.jameskleeh.excel

A class used to create a row in an excel document

Row(XSSFRow, Map, Map<Object, Integer>, CellStyleBuilder) - Constructor in Row

row(Map, Closure) - Method in Sheet

Creates a row

RowCellRangeBorderStyleApplier - Class in com.jameskleeh.excel.style

Applys styles and borders to a single row of merged cells.

S

setStyle(XSSFRow, Map, Map) - Method in CellStyleBuilder

A method to set a style to a row based on a map of options and a map of default options

setStyle(Object, XSSFCell, Map) - Method in CreatesCells

setStyles() - Method in CellRangeBorderStyleApplier

Sheet - Class in com.jameskleeh.excel

A class used to create a sheet in an excel document

sheet - Field in CreatesCells

Sheet(XSSFSheet, CellStyleBuilder) - Constructor in Sheet

sheet(Map, Closure) - Method in Workbook

Creates a sheet

skipCells(int) - Method in Column

@see CreatesCells#skipCells

skipCells(int) - Method in CreatesCells

Skips cells

skipCells(int) - Method in Row

@see CreatesCells#skipCells

skipColumns(int) - Method in Sheet

Skips columns

skipRows(int) - Method in Sheet

Skips rows

skipTo(Object) - Method in Row

Skip to a previously defined column created by CreatesCells.column

skipTo(Object) - Method in Sheet

Skip to a previously defined column created by column

StringExtension - Class in com.jameskleeh.excel.extensions

A class to create anchored column references

STYLE - Field in CellStyleBuilder

styleBuilder - Field in CreatesCells

T

TOP - Field in CellStyleBuilder

U

V

VERTICAL_ALIGNMENT - Field in CellStyleBuilder

W

Workbook - Class in com.jameskleeh.excel

A class used to create a workbook in an excel document

workbook - Field in CreatesCells

Workbook(XSSFWorkbook) - Constructor in Workbook

WorkbookCache - Class in com.jameskleeh.excel

A class used to store fonts and styles for reuse in workbooks

WorkbookCache(XSSFWorkbook) - Constructor in WorkbookCache

WRAPPED - Field in CellStyleBuilder

X

Y

Z

_