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(Map, 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

_

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 _