A B C E G M O P R S

A

afterPropertiesSet() - Method in class org.gageot.excel.core.ExcelTemplate

B

BeanCellCallbackHandler - Class in org.gageot.excel.core

CallbackHandler implementation that creates a bean of the given class for each row, representing all columns as bean properties.

BeanCellCallbackHandler(Class) - Constructor for class org.gageot.excel.core.BeanCellCallbackHandler

BeanSetter - Interface in org.gageot.excel.beans

Interface of ExcelTemplate's low-level JavaBeans infrastructure.

BeanSetterImpl - Class in org.gageot.excel.beans

Simple BeanSetter implementation based on BeanWrapperImpl Spring class.

BeanSetterImpl() - Constructor for class org.gageot.excel.beans.BeanSetterImpl

C

CellCallbackHandler - Interface in org.gageot.excel.core

Callback interface used by ExcelTemplate's query methods.

CellMapper - Interface in org.gageot.excel.core

An interface used by ExcelTemplate for mapping cells.

checkDaoConfig() - Method in class org.gageot.excel.core.ExcelTemplateDaoSupport

ColumnMapRowMapper - Class in org.gageot.excel.core

RowMapper implementation that creates a java.util.Map for each row, representing all columns as key-value pairs: one entry for each column, with the column name as key.

ColumnMapRowMapper(String[]) - Constructor for class org.gageot.excel.core.ColumnMapRowMapper

createBean(Class) - Method in class org.gageot.excel.core.BeanCellCallbackHandler

Create a bean for a given class.

createCellMapper(int) - Method in class org.gageot.excel.core.ColumnMapRowMapper

Create a CellMapper instance to be used to map cells content.

createColumnMap(int) - Method in class org.gageot.excel.core.ColumnMapRowMapper

Create a Map instance to be used as column map.

createExcelTemplate(Resource) - Method in class org.gageot.excel.core.ExcelTemplateDaoSupport

E

ExcelTemplate - Class in org.gageot.excel.core

This is the central class in the Excel core package.

ExcelTemplate() - Constructor for class org.gageot.excel.core.ExcelTemplate

Construct a new ExcelTemplate for bean usage.

ExcelTemplate(Resource) - Constructor for class org.gageot.excel.core.ExcelTemplate

Construct a new ExcelTemplate, given a Resource to obtain the Excel stream from.

ExcelTemplate(File) - Constructor for class org.gageot.excel.core.ExcelTemplate

Construct a new ExcelTemplate, given an Excel File.

ExcelTemplate(String, Class) - Constructor for class org.gageot.excel.core.ExcelTemplate

Construct a new ExcelTemplate, given a path to an Excel file.

ExcelTemplateDaoSupport - Class in org.gageot.excel.core

TODO.

ExcelTemplateDaoSupport() - Constructor for class org.gageot.excel.core.ExcelTemplateDaoSupport

extractData(HSSFSheet) - Method in class org.gageot.excel.core.RowMapperSheetExtractor

extractData(HSSFSheet) - Method in interface org.gageot.excel.core.SheetExtractor

Implementations must implement this method to process all rows in the HSSFSheet.

G

getBeans() - Method in class org.gageot.excel.core.BeanCellCallbackHandler

getExcelTemplate() - Method in class org.gageot.excel.core.ExcelTemplateDaoSupport

getResource() - Method in class org.gageot.excel.core.ExcelTemplate

Set the Resource to obtain the Excel stream from.

getResource() - Method in class org.gageot.excel.core.ExcelTemplateDaoSupport

getTabName() - Method in class org.gageot.excel.core.ExcelTemplateDaoSupport

getWrapper(Object) - Method in class org.gageot.excel.beans.BeanSetterImpl

M

mapCell(HSSFCell, int, int) - Method in interface org.gageot.excel.core.CellMapper

Implementations must implement this method to map each cell of data in the HSSFSheet.

mapCell(HSSFCell, int, int) - Method in class org.gageot.excel.core.ObjectCellMapper

mapCell(HSSFCell, int, int) - Method in class org.gageot.excel.core.StringCellMapper

mapRow(HSSFRow, int) - Method in class org.gageot.excel.core.ColumnMapRowMapper

mapRow(HSSFRow, int) - Method in interface org.gageot.excel.core.RowMapper

Implementations must implement this method to map each row of data in the HSSFSheet.

O

ObjectCellMapper - Class in org.gageot.excel.core

CellMapper implementation that creates a java.lang.Object for each cell.

ObjectCellMapper() - Constructor for class org.gageot.excel.core.ObjectCellMapper

org.gageot.excel.beans - package org.gageot.excel.beans

Provides Bean management utilities for use in ExcelTemplate.

org.gageot.excel.core - package org.gageot.excel.core

Provides the core Excel framework, based on ExcelTemplate and its associated callback interfaces and helper objects.

P

processCell(HSSFCell, int, int) - Method in class org.gageot.excel.core.BeanCellCallbackHandler

processCell(HSSFCell, int, int) - Method in interface org.gageot.excel.core.CellCallbackHandler

Implementations must implement this method to process each cell of data in the HSSFSheet.

processRow(HSSFRow, int) - Method in interface org.gageot.excel.core.RowCallbackHandler

Implementations must implement this method to process each row of data in the HSSFSheet.

R

read(String, SheetExtractor) - Method in class org.gageot.excel.core.ExcelTemplate

Read the content of an Excel file for a given sheet name.

read(String) - Method in class org.gageot.excel.core.ExcelTemplate

read(String, CellMapper) - Method in class org.gageot.excel.core.ExcelTemplate

read(String, CellMapper, Class) - Method in class org.gageot.excel.core.ExcelTemplate

read(String, RowCallbackHandler) - Method in class org.gageot.excel.core.ExcelTemplate

read(String, CellCallbackHandler) - Method in class org.gageot.excel.core.ExcelTemplate

readBeans(String, Class) - Method in class org.gageot.excel.core.ExcelTemplate

readList(String, RowMapper) - Method in class org.gageot.excel.core.ExcelTemplate

readList(String) - Method in class org.gageot.excel.core.ExcelTemplate

readList(String, CellMapper) - Method in class org.gageot.excel.core.ExcelTemplate

RowCallbackHandler - Interface in org.gageot.excel.core

Callback interface used by ExcelTemplate's query methods.

RowMapper - Interface in org.gageot.excel.core

An interface used by ExcelTemplate for mapping rows.

RowMapperSheetExtractor - Class in org.gageot.excel.core

Adapter implementation of the SheetExtractor interface that delegates to a RowMapper which is supposed to create an object for each row.

RowMapperSheetExtractor(RowMapper) - Constructor for class org.gageot.excel.core.RowMapperSheetExtractor

Create a new RowMapperSheetExtractor.

S

setExcelTemplate(ExcelTemplate) - Method in class org.gageot.excel.core.ExcelTemplateDaoSupport

setProperty(Object, String, Object) - Method in interface org.gageot.excel.beans.BeanSetter

Set the value of a property on the current bean.

setProperty(Object, String, Object) - Method in class org.gageot.excel.beans.BeanSetterImpl

Set the value of a property on the current bean.

setResource(Resource) - Method in class org.gageot.excel.core.ExcelTemplate

Return the Resource used by this template.

setResource(Resource) - Method in class org.gageot.excel.core.ExcelTemplateDaoSupport

setTabName(String) - Method in class org.gageot.excel.core.ExcelTemplateDaoSupport

SheetExtractor - Interface in org.gageot.excel.core

Callback interface used by ExcelTemplate's query methods.

StringCellMapper - Class in org.gageot.excel.core

CellMapper implementation that creates a java.lang.String for each cell.

StringCellMapper() - Constructor for class org.gageot.excel.core.StringCellMapper

A B C E G M O P R S