A B C D E F G H I K M N O P R S T V W

A

addService(Object, String, Object) - Static method in class net.sf.excelutils.ExcelUtils

addService(String, Object) - Static method in class net.sf.excelutils.ExcelUtils

addValue(Object, String, Object) - Static method in class net.sf.excelutils.ExcelUtils

add a object to context

addValue(String, Object) - Static method in class net.sf.excelutils.ExcelUtils

add a object to default context

B

buildContextObject(OgnlValueStack) - Method in class net.sf.excelutils.webwork.ExcelManager

C

CallTag - class net.sf.excelutils.tags.CallTag.

CallTag is a class which parse the #call tag

CallTag() - Constructor for class net.sf.excelutils.tags.CallTag

contentType - Variable in class net.sf.excelutils.webwork.ExcelResult

context - Static variable in class net.sf.excelutils.ExcelUtils

copyRow(HSSFSheet, int, int, int) - Static method in class net.sf.excelutils.WorkbookUtils

copy row

D

doExecute(String, ActionInvocation) - Method in class net.sf.excelutils.webwork.ExcelResult

Execute this result, using the specified template location.

E

EachTag - class net.sf.excelutils.tags.EachTag.

EachTag is a class which parse the #each tag

EachTag() - Constructor for class net.sf.excelutils.tags.EachTag

ExcelException - exception net.sf.excelutils.ExcelException.

ExcelException

ExcelException() - Constructor for class net.sf.excelutils.ExcelException

ExcelException(String) - Constructor for class net.sf.excelutils.ExcelException

ExcelException constructor

ExcelLoader - interface net.sf.excelutils.webwork.ExcelLoader.

ExcelLoader.javaget excel's inputstream

ExcelManager - class net.sf.excelutils.webwork.ExcelManager.

ExcelManager() - Constructor for class net.sf.excelutils.webwork.ExcelManager

ExcelParser - class net.sf.excelutils.ExcelParser.

ExcelParser is a class which can parse the Excel template
to genrate reports.

ExcelParser() - Constructor for class net.sf.excelutils.ExcelParser

ExcelResult - class net.sf.excelutils.webwork.ExcelResult.

ExcelResult is a webwork's excel result

ExcelResult() - Constructor for class net.sf.excelutils.webwork.ExcelResult

ExcelUtils - class net.sf.excelutils.ExcelUtils.

ExcelUtils is a class which parse the excel report template

ExcelUtils() - Constructor for class net.sf.excelutils.ExcelUtils

excelLoader - Variable in class net.sf.excelutils.webwork.ExcelManager

export(ServletContext, String, Object, OutputStream) - Static method in class net.sf.excelutils.ExcelUtils

parse the excel template and output excel to outputStream.

export(ServletContext, String, int, Object, OutputStream) - Static method in class net.sf.excelutils.ExcelUtils

parse the excel template in a sheet and output excel to outputStream.

export(ServletContext, String, OutputStream) - Static method in class net.sf.excelutils.ExcelUtils

parse the excel template and output excel to outputStream in default context.

export(ServletContext, String, int, OutputStream) - Static method in class net.sf.excelutils.ExcelUtils

parse the excel template in a sheet and output excel to outputStream in default context.

export(String, Object, OutputStream) - Static method in class net.sf.excelutils.ExcelUtils

parse excel and export

export(String, int, Object, OutputStream) - Static method in class net.sf.excelutils.ExcelUtils

parse exel and export

export(String, OutputStream) - Static method in class net.sf.excelutils.ExcelUtils

parse excel and export excel

export(String, int, OutputStream) - Static method in class net.sf.excelutils.ExcelUtils

parse excel and export excel

export(InputStream, Object, OutputStream) - Static method in class net.sf.excelutils.ExcelUtils

F

ForeachTag - class net.sf.excelutils.tags.ForeachTag.

ForeachTag is a class which parse the #foreach tag

ForeachTag() - Constructor for class net.sf.excelutils.tags.ForeachTag

FormulaTag - class net.sf.excelutils.tags.FormulaTag.

FormulaTag is a class which can output excel formula

FormulaTag() - Constructor for class net.sf.excelutils.tags.FormulaTag

G

get(String) - Method in class net.sf.excelutils.webwork.OgnlDynaBean

Implementation of get(), overriding LazyDynaBean implementation.

get(String, String) - Method in class net.sf.excelutils.webwork.OgnlDynaBean

get(String, int) - Method in class net.sf.excelutils.webwork.OgnlDynaBean

getBeanProperties(Class) - Static method in class net.sf.excelutils.ExcelParser

get properties of the JavaBean

getBeanProperties(DynaClass) - Static method in class net.sf.excelutils.ExcelParser

getBooleanCellValue(HSSFSheet, int, int) - Static method in class net.sf.excelutils.WorkbookUtils

get value of the cell

getCell(HSSFRow, int) - Static method in class net.sf.excelutils.WorkbookUtils

get Cell, if not exists, create

getCell(HSSFSheet, int, int) - Static method in class net.sf.excelutils.WorkbookUtils

get cell, if not exists, create

getContext() - Static method in class net.sf.excelutils.ExcelUtils

get a global context, it's thread safe

getDateCellValue(HSSFSheet, int, int) - Static method in class net.sf.excelutils.WorkbookUtils

get value of the cell

getDynaProperty(String) - Method in class net.sf.excelutils.webwork.OgnlDynaClass

getDynaProperty

getExcel(String) - Method in interface net.sf.excelutils.webwork.ExcelLoader

getExcel(ServletContext, String) - Method in class net.sf.excelutils.webwork.ExcelManager

getExcel(String) - Method in class net.sf.excelutils.webwork.MutiExcelLoader

getExcel(String) - Method in class net.sf.excelutils.webwork.WebappExcelLoader

getExcelLoader(ServletContext) - Method in class net.sf.excelutils.webwork.ExcelManager

getInstance() - Static method in class net.sf.excelutils.webwork.ExcelManager

getIterator(Object) - Static method in class net.sf.excelutils.ExcelParser

get Iterator from the object

getNumericCellValue(HSSFSheet, int, int) - Static method in class net.sf.excelutils.WorkbookUtils

get value of the cell

getRow(int, HSSFSheet) - Static method in class net.sf.excelutils.WorkbookUtils

get Row, if not exists, create

getShiftNum(int, int) - Static method in class net.sf.excelutils.ExcelParser

get shift Num

getSkipNum(int, int) - Static method in class net.sf.excelutils.ExcelParser

get Skip Num

getStringCellValue(HSSFSheet, int, int) - Static method in class net.sf.excelutils.WorkbookUtils

get value of the cell

getTagClass(String) - Static method in class net.sf.excelutils.ExcelParser

get a instance by the tag name.

getTagName() - Method in class net.sf.excelutils.tags.CallTag

getTagName() - Method in class net.sf.excelutils.tags.EachTag

getTagName() - Method in class net.sf.excelutils.tags.ForeachTag

getTagName() - Method in class net.sf.excelutils.tags.FormulaTag

getTagName() - Method in interface net.sf.excelutils.tags.ITag

get the tag name

getTagName() - Method in class net.sf.excelutils.tags.IfTag

getTagName() - Method in class net.sf.excelutils.tags.PageTag

getTagName() - Method in class net.sf.excelutils.tags.SumTag

getTemplate(ActionInvocation, String, OgnlValueStack) - Method in class net.sf.excelutils.webwork.ExcelResult

getValue(Object, String) - Static method in class net.sf.excelutils.ExcelParser

get the value from context by the expression

H

hasEndTag() - Method in class net.sf.excelutils.tags.CallTag

hasEndTag() - Method in class net.sf.excelutils.tags.EachTag

hasEndTag() - Method in class net.sf.excelutils.tags.ForeachTag

hasEndTag() - Method in class net.sf.excelutils.tags.FormulaTag

hasEndTag() - Method in interface net.sf.excelutils.tags.ITag

tag has #end flag

hasEndTag() - Method in class net.sf.excelutils.tags.IfTag

hasEndTag() - Method in class net.sf.excelutils.tags.PageTag

hasEndTag() - Method in class net.sf.excelutils.tags.SumTag

I

ITag - interface net.sf.excelutils.tags.ITag.

ITag is a interface which define the tag

IfTag - class net.sf.excelutils.tags.IfTag.

IfTag is a class which parse #if #else #end

IfTag() - Constructor for class net.sf.excelutils.tags.IfTag

isCanShowType(Object) - Static method in class net.sf.excelutils.ExcelUtils

can value be show

K

KEY_CALL - Static variable in class net.sf.excelutils.tags.CallTag

KEY_EACH - Static variable in class net.sf.excelutils.tags.EachTag

KEY_END - Static variable in class net.sf.excelutils.tags.ForeachTag

KEY_END - Static variable in class net.sf.excelutils.tags.IfTag

KEY_FOREACH - Static variable in class net.sf.excelutils.tags.ForeachTag

KEY_FORMULA - Static variable in class net.sf.excelutils.tags.FormulaTag

KEY_IF - Static variable in class net.sf.excelutils.tags.IfTag

KEY_PAGE - Static variable in class net.sf.excelutils.tags.PageTag

KEY_SUM - Static variable in class net.sf.excelutils.tags.SumTag

KEY_TAG - Static variable in class net.sf.excelutils.ExcelParser

M

MutiExcelLoader - class net.sf.excelutils.webwork.MutiExcelLoader.

MutiExcelLoader(ExcelLoader[]) - Constructor for class net.sf.excelutils.webwork.MutiExcelLoader

main(String[]) - Static method in class net.sf.excelutils.tags.IfTag

N

net.sf.excelutils - package net.sf.excelutils

net.sf.excelutils.tags - package net.sf.excelutils.tags

net.sf.excelutils.webwork - package net.sf.excelutils.webwork

O

OgnlDynaBean - class net.sf.excelutils.webwork.OgnlDynaBean.

OnglDynaBean is a class which extends LazyDynaBean

OgnlDynaBean(OgnlValueStack) - Constructor for class net.sf.excelutils.webwork.OgnlDynaBean

Constructs an instance of OgnlValueStackShadowMap.

OgnlDynaClass - class net.sf.excelutils.webwork.OgnlDynaClass.

OnglDynaClass is a class which extends LazyDynaClass

OgnlDynaClass(OgnlValueStack) - Constructor for class net.sf.excelutils.webwork.OgnlDynaClass

Constructor

openWorkbook(ServletContext, String) - Static method in class net.sf.excelutils.WorkbookUtils

Open Excel File

openWorkbook(String) - Static method in class net.sf.excelutils.WorkbookUtils

Open an excel file by real fileName

openWorkbook(InputStream) - Static method in class net.sf.excelutils.WorkbookUtils

Open an excel from InputStream

P

PageTag - class net.sf.excelutils.tags.PageTag.

PageTag is a class which parse the #page tag Because a bug in POI, you must place a split char in your sheet near the #page tag

PageTag() - Constructor for class net.sf.excelutils.tags.PageTag

parse(Object, HSSFSheet, int, int) - Static method in class net.sf.excelutils.ExcelParser

parse the Excel template

parseCell(Object, HSSFSheet, HSSFRow, HSSFCell) - Static method in class net.sf.excelutils.ExcelParser

parse the cell

parseExpr(Object, String) - Static method in class net.sf.excelutils.ExcelParser

parse the expression ${model[${index}]} only one ${} and startWith ${ endWith }

parseSheet(Object, HSSFSheet) - Static method in class net.sf.excelutils.ExcelUtils

parse Excel Template File

parseStr(Object, String) - Static method in class net.sf.excelutils.ExcelParser

parse complex expression ${${}}aaa${}

parseStr(Object, String, boolean) - Static method in class net.sf.excelutils.ExcelParser

parse complex expression ${${}}aaa${}

parseTag(Object, HSSFSheet, HSSFRow, HSSFCell) - Method in class net.sf.excelutils.tags.CallTag

parseTag(Object, HSSFSheet, HSSFRow, HSSFCell) - Method in class net.sf.excelutils.tags.EachTag

parseTag(Object, HSSFSheet, HSSFRow, HSSFCell) - Method in class net.sf.excelutils.tags.ForeachTag

parseTag(Object, HSSFSheet, HSSFRow, HSSFCell) - Method in class net.sf.excelutils.tags.FormulaTag

parseTag(Object, HSSFSheet, HSSFRow, HSSFCell) - Method in interface net.sf.excelutils.tags.ITag

parse the tag

parseTag(Object, HSSFSheet, HSSFRow, HSSFCell) - Method in class net.sf.excelutils.tags.IfTag

parseTag(Object, HSSFSheet, HSSFRow, HSSFCell) - Method in class net.sf.excelutils.tags.PageTag

parseTag(Object, HSSFSheet, HSSFRow, HSSFCell) - Method in class net.sf.excelutils.tags.SumTag

parseWorkbook(Object, HSSFWorkbook) - Static method in class net.sf.excelutils.ExcelUtils

parse workbook

parseWorkbook(Object, HSSFWorkbook, int) - Static method in class net.sf.excelutils.ExcelUtils

parse Workbook

R

registerTagPackage(String) - Static method in class net.sf.excelutils.ExcelUtils

register extended tag package, default is net.sf.excelutils.tags

S

SaveWorkbook(HSSFWorkbook, OutputStream) - Static method in class net.sf.excelutils.WorkbookUtils

Save the Excel to OutputStream

SumTag - class net.sf.excelutils.tags.SumTag.

SumTag is a class which parse the #sum tag

SumTag() - Constructor for class net.sf.excelutils.tags.SumTag

setCellValue(HSSFSheet, int, int, String) - Static method in class net.sf.excelutils.WorkbookUtils

Set value of the cell

setCellValue(HSSFSheet, int, int, String, short) - Static method in class net.sf.excelutils.WorkbookUtils

set value of the cell

setCellValue(HSSFSheet, int, int, double) - Static method in class net.sf.excelutils.WorkbookUtils

set value of the cell

setCellValue(HSSFSheet, int, int, Date) - Static method in class net.sf.excelutils.WorkbookUtils

set value of the cell

setCellValue(HSSFSheet, int, int, boolean) - Static method in class net.sf.excelutils.WorkbookUtils

set value of the cell

setContext(DynaBean) - Static method in class net.sf.excelutils.ExcelUtils

set global context

shiftCell(HSSFSheet, HSSFRow, HSSFCell, int, int) - Static method in class net.sf.excelutils.WorkbookUtils

T

tagPackageMap - Static variable in class net.sf.excelutils.ExcelParser

V

VALUED_DELIM - Static variable in class net.sf.excelutils.ExcelParser

VALUED_DELIM2 - Static variable in class net.sf.excelutils.ExcelParser

valueStack - Variable in class net.sf.excelutils.webwork.OgnlDynaBean

valueStack reference

valueStack - Variable in class net.sf.excelutils.webwork.OgnlDynaClass

W

WebappExcelLoader - class net.sf.excelutils.webwork.WebappExcelLoader.

WebappExcelLoader(ServletContext) - Constructor for class net.sf.excelutils.webwork.WebappExcelLoader

WorkbookUtils - class net.sf.excelutils.WorkbookUtils.

WorkbookUtils is a helper of Microsoft Excel,it's based on POI project

WorkbookUtils() - Constructor for class net.sf.excelutils.WorkbookUtils

A B C D E F G H I K M N O P R S T V W