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

A

ABSOLUTE_REFERENCE_MARKER - Static variable in class org.jxls.util.CellRefUtil

The character ($) that signifies a row or column value is absolute instead of relative

AbstractCommand - Class in org.jxls.command

Implements basic command methods and is a convenient base class for other commands

AbstractCommand() - Constructor for class org.jxls.command.AbstractCommand

AbstractTransformer - Class in org.jxls.transform

Base transformer class providing basic implementation for some of the Transformer interface methods

AbstractTransformer() - Constructor for class org.jxls.transform.AbstractTransformer

add(Size) - Method in class org.jxls.common.Size

addArea(Area) - Method in class org.jxls.command.AbstractCommand

addArea(Area) - Method in interface org.jxls.command.Command

Adds an area to this command

addArea(Area) - Method in class org.jxls.command.EachCommand

addArea(Area) - Method in class org.jxls.command.GridCommand

addArea(Area) - Method in class org.jxls.command.IfCommand

addArea(Area) - Method in class org.jxls.command.ImageCommand

addAreaListener(AreaListener) - Method in interface org.jxls.area.Area

addAreaListener(AreaListener) - Method in class org.jxls.area.XlsArea

addCellData(CellData) - Method in class org.jxls.common.RowData

addCommand(AreaRef, Command) - Method in interface org.jxls.area.Area

addCommand(AreaRef, Command) - Method in class org.jxls.area.XlsArea

addCommand(String, Command) - Method in class org.jxls.area.XlsArea

addCommandMapping(String, Class) - Static method in class org.jxls.builder.xls.XlsCommentAreaBuilder

addImage(AreaRef, byte[], ImageType) - Method in interface org.jxls.transform.Transformer

addImplicitRules(Interpreter) - Method in class org.jxls.builder.xml.SimpleConfigurator

addInstanceRules(RuleStore) - Method in class org.jxls.builder.xml.SimpleConfigurator

addRowData(RowData) - Method in class org.jxls.common.SheetData

addTargetParentAreaRef(AreaRef) - Method in class org.jxls.common.CellData

addTargetPos(CellRef) - Method in class org.jxls.common.CellData

ADJACENT_SHIFT_MODE - Static variable in interface org.jxls.command.Command

AdjacentCellShiftStrategy - Class in org.jxls.common.cellshift

Shifts not only cells impacted by shifting area but also the adjacent area cells

AdjacentCellShiftStrategy() - Constructor for class org.jxls.common.cellshift.AdjacentCellShiftStrategy

afterApplyAtCell(CellRef, Context) - Method in interface org.jxls.common.AreaListener

afterTransformCell(CellRef, CellRef, Context) - Method in interface org.jxls.common.AreaListener

append(int, int) - Method in class org.jxls.common.Size

append(Size) - Method in class org.jxls.common.Size

appendFormat(StringBuilder, String) - Static method in class org.jxls.util.CellRefUtil

applyAt(CellRef, Context) - Method in interface org.jxls.area.Area

applyAt(CellRef, Context) - Method in class org.jxls.area.XlsArea

applyAt(CellRef, Context) - Method in class org.jxls.builder.xls.AreaCommand

applyAt(CellRef, Context) - Method in interface org.jxls.command.Command

Applies a command at the given cell reference

applyAt(CellRef, Context) - Method in class org.jxls.command.EachCommand

applyAt(CellRef, Context) - Method in class org.jxls.command.GridCommand

applyAt(CellRef, Context) - Method in class org.jxls.command.IfCommand

applyAt(CellRef, Context) - Method in class org.jxls.command.ImageCommand

Area - Interface in org.jxls.area

Generic interface for excel area processing

area - Variable in class org.jxls.common.CellData

AreaAction - Class in org.jxls.builder.xml

Builds AreaCommand from XML

AreaAction(Transformer) - Constructor for class org.jxls.builder.xml.AreaAction

AreaBuilder - Interface in org.jxls.builder

An area builder interface

AreaCommand - Class in org.jxls.builder.xls

A container area command used in XlsCommentAreaBuilder to enclose other commands

AreaCommand() - Constructor for class org.jxls.builder.xls.AreaCommand

AreaListener - Interface in org.jxls.common

Defines callback methods to be called during area processing

AreaRef - Class in org.jxls.common

Defines area bounds

AreaRef(CellRef, CellRef) - Constructor for class org.jxls.common.AreaRef

AreaRef(CellRef, Size) - Constructor for class org.jxls.common.AreaRef

AreaRef(String) - Constructor for class org.jxls.common.AreaRef

ATTR - Static variable in class org.jxls.builder.xml.UserCommandAction

B

beforeApplyAtCell(CellRef, Context) - Method in interface org.jxls.common.AreaListener

beforeTransformCell(CellRef, CellRef, Context) - Method in interface org.jxls.common.AreaListener

begin(InterpretationContext, String, Attributes) - Method in class org.jxls.builder.xml.AreaAction

begin(InterpretationContext, String, Attributes) - Method in class org.jxls.builder.xml.EachAction

begin(InterpretationContext, String, Attributes) - Method in class org.jxls.builder.xml.GridAction

begin(InterpretationContext, String, Attributes) - Method in class org.jxls.builder.xml.IfAction

begin(InterpretationContext, String, Attributes) - Method in class org.jxls.builder.xml.UserCommandAction

build() - Method in interface org.jxls.builder.AreaBuilder

build() - Method in class org.jxls.builder.xls.XlsCommentAreaBuilder

Builds a list of XlsArea objects defined by top level AreaCommand markup ("jx:area") containing a tree of all nested commands

build(InputStream) - Method in class org.jxls.builder.xml.XmlAreaBuilder

build() - Method in class org.jxls.builder.xml.XmlAreaBuilder

buildExpressionNotation(String, String) - Method in class org.jxls.transform.TransformationConfig

buildExpressionNotation(String, String) - Method in class org.jxls.util.JxlsHelper

C

calculateHeight() - Method in class org.jxls.common.CellRange

calculateWidth() - Method in class org.jxls.common.CellRange

CaseInsensitiveHashMap - Class in org.jxls.jdbc

This class is taken from Apache Commons DbUtils library (https://commons.apache.org/proper/commons-dbutils/) A Map that converts all keys to lowercase Strings for case insensitive lookups.

CaseInsensitiveHashMap() - Constructor for class org.jxls.jdbc.CaseInsensitiveHashMap

cellComment - Variable in class org.jxls.common.CellData

CellData - Class in org.jxls.common

Represents an excel cell data holder and cell value evaluator

CellData(CellRef) - Constructor for class org.jxls.common.CellData

CellData(String, int, int, CellData.CellType, Object) - Constructor for class org.jxls.common.CellData

CellData(CellRef, CellData.CellType, Object) - Constructor for class org.jxls.common.CellData

CellData(String, int, int) - Constructor for class org.jxls.common.CellData

CellData.CellType - Enum in org.jxls.common

CellData.FormulaStrategy - Enum in org.jxls.common

cellDataList - Variable in class org.jxls.common.RowData

CellRange - Class in org.jxls.common

Represents an excel cell range

CellRange(CellRef, int, int) - Constructor for class org.jxls.common.CellRange

cellRef - Variable in class org.jxls.common.CellData

CellRef - Class in org.jxls.common

Represents cell reference

CellRef(String, int, int) - Constructor for class org.jxls.common.CellRef

CellRef(int, int) - Constructor for class org.jxls.common.CellRef

CellRef(String) - Constructor for class org.jxls.common.CellRef

CellRefColPrecedenceComparator - Class in org.jxls.common

Cell comparator used to order cells first by columns and then by rows

CellRefColPrecedenceComparator() - Constructor for class org.jxls.common.CellRefColPrecedenceComparator

cellReferenceIsWithinRange(String, String, int, int) - Static method in class org.jxls.util.CellRefUtil

Used to decide whether a name of the form "[A-Z]*[0-9]*" that appears in a formula can be interpreted as a cell reference.

CellRefGenerator - Interface in org.jxls.command

Defines generic method for generating new cell references during EachCommand command iteration

CellRefRowPrecedenceComparator - Class in org.jxls.common

Cell comparator used to order cell by rows first and then by columns

CellRefRowPrecedenceComparator() - Constructor for class org.jxls.common.CellRefRowPrecedenceComparator

CellRefUtil - Class in org.jxls.util

This is a class to convert Excel cell names to (sheet,row,col) representations and vice versa The current code is taken from Apache POI CellReference class (@link http://poi.apache.org/apidocs/org/apache/poi/ss/util/CellReference.html)

CellRefUtil() - Constructor for class org.jxls.util.CellRefUtil

CellShiftStrategy - Interface in org.jxls.common.cellshift

Defines cell shift strategy

cellType - Variable in class org.jxls.common.CellData

cellValue - Variable in class org.jxls.common.CellData

CLEAR_CELLS_ATTR - Static variable in class org.jxls.builder.xml.AreaAction

clearCell(CellRef) - Method in interface org.jxls.transform.Transformer

clearCells() - Method in class org.jxls.area.XlsArea

columnWidth - Variable in class org.jxls.common.SheetData

Command - Interface in org.jxls.command

A command interface defines a transformation of a list of areas at a specified cell Date: Mar 13, 2009

COMMAND_CLASS_ATTR - Static variable in class org.jxls.builder.xml.UserCommandAction

COMMAND_NAME - Static variable in class org.jxls.command.GridCommand

COMMAND_PREFIX - Static variable in class org.jxls.builder.xls.XlsCommentAreaBuilder

CommandData - Class in org.jxls.area

A command holder class

CommandData(AreaRef, Command) - Constructor for class org.jxls.area.CommandData

CommandData(String, Command) - Constructor for class org.jxls.area.CommandData

CommandData(CellRef, Size, Command) - Constructor for class org.jxls.area.CommandData

compare(CellRef, CellRef) - Method in class org.jxls.common.CellRefColPrecedenceComparator

compare(CellRef, CellRef) - Method in class org.jxls.common.CellRefRowPrecedenceComparator

compareTo(CellRef) - Method in class org.jxls.common.CellRef

CONDITION_ATTR - Static variable in class org.jxls.builder.xml.IfAction

Config() - Constructor for class org.jxls.common.Context.Config

contains(CellRef) - Method in class org.jxls.common.AreaRef

contains(int, int) - Method in class org.jxls.common.AreaRef

contains(AreaRef) - Method in class org.jxls.common.AreaRef

containsKey(Object) - Method in class org.jxls.jdbc.CaseInsensitiveHashMap

Context - Class in org.jxls.common

Map bean context Date: Nov 2, 2009

Context() - Constructor for class org.jxls.common.Context

Context(Map<String, Object>) - Constructor for class org.jxls.common.Context

Context.Config - Class in org.jxls.common

Special config class to use in Area processing

convertColStringToIndex(String) - Static method in class org.jxls.util.CellRefUtil

takes in a column reference portion of a CellRef and converts it from ALPHA-26 number format to 0-based base 10.

convertNumToColString(int) - Static method in class org.jxls.util.CellRefUtil

Takes in a 0-based base-10 column and returns a ALPHA-26 representation.

createInitialContext() - Method in class org.jxls.transform.AbstractTransformer

createInitialContext() - Method in interface org.jxls.transform.Transformer

createTargetCellRef(List<CellRef>) - Static method in class org.jxls.util.Util

createTargetCellRefListByColumn(CellRef, List<CellRef>, List<CellRef>) - Static method in class org.jxls.util.Util

createTransformer(InputStream, OutputStream) - Static method in class org.jxls.util.TransformerFactory

D

DATA_ATTR - Static variable in class org.jxls.builder.xml.GridAction

DATA_VAR - Static variable in class org.jxls.command.GridCommand

DEFAULT_EXPRESSION_BEGIN - Static variable in class org.jxls.transform.TransformationConfig

DEFAULT_EXPRESSION_END - Static variable in class org.jxls.transform.TransformationConfig

DEFAULT_REGEX_EXPRESSION - Static variable in class org.jxls.transform.TransformationConfig

DEFAULT_VALUE - Static variable in class org.jxls.common.CellData

defaultValue - Variable in class org.jxls.common.CellData

deleteSheet(String) - Method in class org.jxls.transform.AbstractTransformer

deleteSheet(String) - Method in interface org.jxls.transform.Transformer

DIRECTION_ATTR - Static variable in class org.jxls.builder.xml.EachAction

E

EachAction - Class in org.jxls.builder.xml

Builds EachCommand from XML

EachAction() - Constructor for class org.jxls.builder.xml.EachAction

EachCommand - Class in org.jxls.command

Implements iteration over collection of items 'items' is a bean name of the collection in context 'var' is a name of a collection item to put into the context during the iteration 'direction' defines expansion by rows (DOWN) or by columns (RIGHT).

EachCommand() - Constructor for class org.jxls.command.EachCommand

EachCommand(String, String, EachCommand.Direction) - Constructor for class org.jxls.command.EachCommand

EachCommand(String, String, Area) - Constructor for class org.jxls.command.EachCommand

EachCommand(String, String, Area, EachCommand.Direction) - Constructor for class org.jxls.command.EachCommand

EachCommand(String, String, Area, CellRefGenerator) - Constructor for class org.jxls.command.EachCommand

EachCommand.Direction - Enum in org.jxls.command

EMPTY_AREA - Static variable in class org.jxls.area.XlsArea

end(InterpretationContext, String) - Method in class org.jxls.builder.xml.AreaAction

end(InterpretationContext, String) - Method in class org.jxls.builder.xml.EachAction

end(InterpretationContext, String) - Method in class org.jxls.builder.xml.GridAction

end(InterpretationContext, String) - Method in class org.jxls.builder.xml.IfAction

end(InterpretationContext, String) - Method in class org.jxls.builder.xml.UserCommandAction

equals(Object) - Method in class org.jxls.common.AreaRef

equals(Object) - Method in class org.jxls.common.CellData

equals(Object) - Method in class org.jxls.common.CellRef

equals(Object) - Method in class org.jxls.common.Size

evaluate(Context) - Method in class org.jxls.common.CellData

evaluate(String, Map<String, Object>) - Method in interface org.jxls.expression.ExpressionEvaluator

evaluate(String, Map<String, Object>) - Method in class org.jxls.expression.JexlExpressionEvaluator

evaluate(Map<String, Object>) - Method in class org.jxls.expression.JexlExpressionEvaluator

EvaluationException - Exception in org.jxls.expression

Custom exception class for exceptions thrown during evaluation of expressions Date: Nov 2, 2009

EvaluationException() - Constructor for exception org.jxls.expression.EvaluationException

EvaluationException(String) - Constructor for exception org.jxls.expression.EvaluationException

EvaluationException(String, Throwable) - Constructor for exception org.jxls.expression.EvaluationException

EvaluationException(Throwable) - Constructor for exception org.jxls.expression.EvaluationException

evaluationResult - Variable in class org.jxls.common.CellData

excludeCells(int, int, int, int) - Method in class org.jxls.common.CellRange

EXPRESSION_PART - Static variable in class org.jxls.transform.TransformationConfig

ExpressionEvaluator - Interface in org.jxls.expression

An interface to evaluate expressions Date: Nov 2, 2009

F

FastFormulaProcessor - Class in org.jxls.formula

Fast formula processor implementation.

FastFormulaProcessor() - Constructor for class org.jxls.formula.FastFormulaProcessor

findCommandByName(String) - Method in interface org.jxls.area.Area

findCommandByName(String) - Method in class org.jxls.area.XlsArea

formula - Variable in class org.jxls.common.CellData

FORMULA_STRATEGY_PARAM - Static variable in class org.jxls.common.CellData

formulaContainsJointedCellRef(String) - Static method in class org.jxls.util.Util

FormulaProcessor - Interface in org.jxls.formula

Defines formula processing for Area

formulaStrategy - Variable in class org.jxls.common.CellData

G

generateCellRef(int, Context) - Method in interface org.jxls.command.CellRefGenerator

get(Object) - Method in class org.jxls.jdbc.CaseInsensitiveHashMap

getArea() - Method in class org.jxls.common.CellData

getAreaBuilder() - Method in class org.jxls.util.JxlsHelper

getAreaList() - Method in class org.jxls.builder.xml.AreaAction

getAreaList() - Method in class org.jxls.command.AbstractCommand

getAreaList() - Method in interface org.jxls.command.Command

getAreaListeners() - Method in interface org.jxls.area.Area

getAreaListeners() - Method in class org.jxls.area.XlsArea

getAreaRef() - Method in interface org.jxls.area.Area

getAreaRef() - Method in class org.jxls.area.CommandData

getAreaRef() - Method in class org.jxls.area.XlsArea

getAttrMap() - Method in class org.jxls.common.CellData

getCell(int, int) - Method in class org.jxls.common.CellRange

getCellComment() - Method in class org.jxls.common.CellData

getCellData(int) - Method in class org.jxls.common.RowData

getCellData(CellRef) - Method in class org.jxls.transform.AbstractTransformer

getCellData(CellRef) - Method in interface org.jxls.transform.Transformer

getCellName() - Method in class org.jxls.common.CellRef

getCellRef() - Method in class org.jxls.common.CellData

getCellRefGenerator() - Method in class org.jxls.command.EachCommand

Gets defined cell ref generator

getCellRefsFromJointedCellRef(String) - Static method in class org.jxls.util.Util

getCellShiftStrategy() - Method in interface org.jxls.area.Area

getCellShiftStrategy() - Method in class org.jxls.area.XlsArea

getCellShiftStrategy() - Method in class org.jxls.common.CellRange

getCellStyleMap() - Method in class org.jxls.common.Context.Config

getCellType() - Method in class org.jxls.common.CellData

getCellValue() - Method in class org.jxls.common.CellData

getClearCells() - Method in class org.jxls.builder.xls.AreaCommand

getCol() - Method in class org.jxls.common.CellData

getCol() - Method in class org.jxls.common.CellRef

getColumnWidth(int) - Method in class org.jxls.common.SheetData

getCommand() - Method in class org.jxls.area.CommandData

getCommandDataList() - Method in interface org.jxls.area.Area

getCommandDataList() - Method in class org.jxls.area.XlsArea

getCommentedCells() - Method in interface org.jxls.transform.Transformer

getCondition() - Method in class org.jxls.command.IfCommand

Gets test condition as JEXL expression string

getConfig() - Method in class org.jxls.common.Context

getData() - Method in class org.jxls.command.GridCommand

getDefaultValue() - Method in class org.jxls.common.CellData

getDirection() - Method in class org.jxls.command.EachCommand

Gets iteration directino

getElseArea() - Method in class org.jxls.command.IfCommand

Gets an area to render when the condition is evaluated to 'false'

getExpressionEvaluator() - Method in class org.jxls.transform.TransformationConfig

getExpressionNotationBegin() - Method in class org.jxls.transform.TransformationConfig

getExpressionNotationEnd() - Method in class org.jxls.transform.TransformationConfig

getExpressionNotationPattern() - Method in class org.jxls.transform.TransformationConfig

getFirstCellRef() - Method in class org.jxls.common.AreaRef

getFormatCells() - Method in class org.jxls.command.GridCommand

getFormattedSheetName() - Method in class org.jxls.common.CellRef

getFormula() - Method in class org.jxls.common.CellData

getFormulaCellRefs(String) - Static method in class org.jxls.util.Util

getFormulaCells() - Method in class org.jxls.transform.AbstractTransformer

getFormulaCells() - Method in interface org.jxls.transform.Transformer

getFormulaProcessor() - Method in interface org.jxls.area.Area

getFormulaProcessor() - Method in class org.jxls.area.XlsArea

getFormulaStrategy() - Method in class org.jxls.common.CellData

getHeaders() - Method in class org.jxls.command.GridCommand

getHeight() - Method in class org.jxls.common.RowData

getHeight() - Method in class org.jxls.common.Size

getIfArea() - Method in class org.jxls.command.IfCommand

Gets an area to render when the condition is evaluated to 'true'

getInstance() - Static method in class org.jxls.util.JxlsHelper

getItem() - Method in class org.jxls.common.GroupData

getItems() - Method in class org.jxls.command.EachCommand

Gets collection bean name

getItems() - Method in class org.jxls.common.GroupData

getJexlEngine() - Method in class org.jxls.expression.JexlExpressionEvaluator

getJexlExpression() - Method in class org.jxls.expression.JexlExpressionEvaluator

getJointedCellRefs(String) - Static method in class org.jxls.util.Util

getLastCellRef() - Method in class org.jxls.common.AreaRef

getName() - Method in class org.jxls.builder.xls.AreaCommand

getName() - Method in interface org.jxls.command.Command

getName() - Method in class org.jxls.command.EachCommand

getName() - Method in class org.jxls.command.GridCommand

getName() - Method in class org.jxls.command.IfCommand

getName() - Method in class org.jxls.command.ImageCommand

getNumberOfCells() - Method in class org.jxls.common.RowData

getNumberOfRows() - Method in class org.jxls.common.SheetData

getObjectProperty(Object, String, boolean) - Static method in class org.jxls.util.Util

getObjectProperty(Object, String) - Static method in class org.jxls.util.Util

getProps() - Method in class org.jxls.command.GridCommand

getRow() - Method in class org.jxls.common.CellData

getRow() - Method in class org.jxls.common.CellRef

getRowData(int) - Method in class org.jxls.common.SheetData

getSelect() - Method in class org.jxls.command.EachCommand

Gets current 'select' expression for filtering out collection items

getSheetName() - Method in class org.jxls.common.AreaRef

getSheetName() - Method in class org.jxls.common.CellData

getSheetName() - Method in class org.jxls.common.CellRef

getSheetName() - Method in class org.jxls.common.SheetData

getShiftMode() - Method in class org.jxls.command.AbstractCommand

getShiftMode() - Method in interface org.jxls.command.Command

getSize() - Method in interface org.jxls.area.Area

getSize() - Method in class org.jxls.area.CommandData

getSize() - Method in class org.jxls.area.XlsArea

getSize() - Method in class org.jxls.common.AreaRef

getSourceSize() - Method in class org.jxls.area.CommandData

getSourceStartCellRef() - Method in class org.jxls.area.CommandData

getSrc() - Method in class org.jxls.command.ImageCommand

getStartCell() - Method in class org.jxls.common.CellRange

getStartCellRef() - Method in interface org.jxls.area.Area

getStartCellRef() - Method in class org.jxls.area.CommandData

getStartCellRef() - Method in class org.jxls.area.XlsArea

getTargetCellRef(CellRef) - Method in class org.jxls.transform.AbstractTransformer

getTargetCellRef(CellRef) - Method in interface org.jxls.transform.Transformer

getTargetParentAreaRef() - Method in class org.jxls.common.CellData

getTargetPos() - Method in class org.jxls.common.CellData

getTransformationConfig() - Method in class org.jxls.command.AbstractCommand

getTransformationConfig() - Method in class org.jxls.transform.AbstractTransformer

getTransformationConfig() - Method in interface org.jxls.transform.Transformer

getTransformer() - Method in interface org.jxls.area.Area

getTransformer() - Method in class org.jxls.area.XlsArea

getTransformer() - Method in interface org.jxls.builder.AreaBuilder

getTransformer() - Method in class org.jxls.builder.xls.XlsCommentAreaBuilder

getTransformer() - Method in class org.jxls.builder.xml.XmlAreaBuilder

getTransformer() - Method in class org.jxls.command.AbstractCommand

getTransformer() - Method in class org.jxls.common.CellData

getTransformer() - Method in class org.jxls.common.RowData

getTransformer() - Method in class org.jxls.common.SheetData

getTransformerName() - Static method in class org.jxls.util.TransformerFactory

getVar() - Method in class org.jxls.command.EachCommand

Gets current variable name for collection item in the context during iteration

getVar(String) - Method in class org.jxls.common.Context

getWidth() - Method in class org.jxls.common.Size

GRID_TEMPLATE_XLS - Static variable in class org.jxls.template.SimpleExporter

GridAction - Class in org.jxls.builder.xml

Defines Grid command via xml

GridAction() - Constructor for class org.jxls.builder.xml.GridAction

GridCommand - Class in org.jxls.command

The command implements a grid with dynamic columns and rows

GridCommand() - Constructor for class org.jxls.command.GridCommand

GridCommand(String, String) - Constructor for class org.jxls.command.GridCommand

GridCommand(String, String, String, Area, Area) - Constructor for class org.jxls.command.GridCommand

GridCommand(String, String, Area, Area) - Constructor for class org.jxls.command.GridCommand

gridExport(Iterable, Iterable, String, OutputStream) - Method in class org.jxls.template.SimpleExporter

gridExport(Collection, Collection, String, OutputStream) - Method in class org.jxls.util.JxlsHelper

groupByColRange(List<CellRef>) - Static method in class org.jxls.util.Util

groupByRanges(List<CellRef>, int) - Static method in class org.jxls.util.Util

groupByRowRange(List<CellRef>) - Static method in class org.jxls.util.Util

groupCollection(Collection, String, String) - Static method in class org.jxls.util.Util

GroupData - Class in org.jxls.common

Used in collection grouping to hold group data

GroupData(Object, Collection) - Constructor for class org.jxls.common.GroupData

H

hasChanged(int, int) - Method in class org.jxls.common.CellRange

hashCode() - Method in class org.jxls.common.AreaRef

hashCode() - Method in class org.jxls.common.CellData

hashCode() - Method in class org.jxls.common.CellRef

hashCode() - Method in class org.jxls.common.Size

HEADER_ATTR - Static variable in class org.jxls.builder.xml.GridAction

HEADER_VAR - Static variable in class org.jxls.command.GridCommand

height - Variable in class org.jxls.common.RowData

I

IfAction - Class in org.jxls.builder.xml

Builds IfCommand from XML

IfAction() - Constructor for class org.jxls.builder.xml.IfAction

IfCommand - Class in org.jxls.command

Implements if-else logic Date: Sep 11, 2009

IfCommand() - Constructor for class org.jxls.command.IfCommand

IfCommand(String) - Constructor for class org.jxls.command.IfCommand

IfCommand(String, Area, Area) - Constructor for class org.jxls.command.IfCommand

IfCommand(String, XlsArea) - Constructor for class org.jxls.command.IfCommand

ImageCommand - Class in org.jxls.command

Implements image rendering Image is specified with image index in the workbook or by providing image bytes and type

ImageCommand() - Constructor for class org.jxls.command.ImageCommand

ImageCommand(String, ImageType) - Constructor for class org.jxls.command.ImageCommand

ImageCommand(byte[], ImageType) - Constructor for class org.jxls.command.ImageCommand

ImageType - Enum in org.jxls.common

Represents possible image types

INIT_METHOD - Static variable in class org.jxls.util.TransformerFactory

INNER_SHIFT_MODE - Static variable in interface org.jxls.command.Command

InnerCellShiftStrategy - Class in org.jxls.common.cellshift

InnerCellShiftStrategy() - Constructor for class org.jxls.common.cellshift.InnerCellShiftStrategy

isColAbs() - Method in class org.jxls.common.CellRef

isColumnWithnRange(String, int) - Static method in class org.jxls.util.CellRefUtil

isCommandString(String) - Static method in class org.jxls.builder.xls.XlsCommentAreaBuilder

isConditionTrue(ExpressionEvaluator, String, Context) - Static method in class org.jxls.util.Util

isConditionTrue(JexlExpressionEvaluator, Context) - Static method in class org.jxls.util.Util

isDeleteTemplateSheet() - Method in class org.jxls.util.JxlsHelper

isExcluded(int, int) - Method in class org.jxls.common.CellRange

isFormulaCell() - Method in class org.jxls.common.CellData

isFormulaProcessingRequired() - Method in class org.jxls.common.Context.Config

isHideTemplateSheet() - Method in class org.jxls.util.JxlsHelper

isIgnoreColumnProps() - Method in class org.jxls.transform.AbstractTransformer

isIgnoreRowProps() - Method in class org.jxls.transform.AbstractTransformer

isIgnoreSheetNameInFormat() - Method in class org.jxls.common.CellRef

isIgnoreSourceCellStyle() - Method in class org.jxls.common.Context.Config

isJxlsParamsComment(String) - Method in class org.jxls.common.CellData

isPlainColumn(String) - Static method in class org.jxls.util.CellRefUtil

isProcessFormulas() - Method in class org.jxls.util.JxlsHelper

isRowAbs() - Method in class org.jxls.common.CellRef

isRowWithnRange(String, int) - Static method in class org.jxls.util.CellRefUtil

isUseFastFormulaProcessor() - Method in class org.jxls.util.JxlsHelper

isUserFormula(String) - Static method in class org.jxls.common.CellData

isValid() - Method in class org.jxls.common.CellRef

ITEMS_ATTR - Static variable in class org.jxls.builder.xml.EachAction

iterator() - Method in class org.jxls.common.RowData

iterator() - Method in class org.jxls.common.SheetData

J

JdbcHelper - Class in org.jxls.jdbc

A class to help execute SQL queries via JDBC

JdbcHelper(Connection) - Constructor for class org.jxls.jdbc.JdbcHelper

JEXCEL_CLASS_NAME - Static variable in class org.jxls.util.TransformerFactory

JEXCEL_TRANSFORMER - Static variable in class org.jxls.util.TransformerFactory

JexlExpressionEvaluator - Class in org.jxls.expression

Date: Nov 2, 2009

JexlExpressionEvaluator() - Constructor for class org.jxls.expression.JexlExpressionEvaluator

JexlExpressionEvaluator(String) - Constructor for class org.jxls.expression.JexlExpressionEvaluator

JexlExpressionEvaluator(Map<String, Object>) - Constructor for class org.jxls.expression.JexlExpressionEvaluator

JexlExpressionEvaluator(JexlContext) - Constructor for class org.jxls.expression.JexlExpressionEvaluator

joinStrings(List<String>, String) - Static method in class org.jxls.util.Util

JX_PARAMS_PREFIX - Static variable in class org.jxls.common.CellData

JxlsException - Exception in org.jxls.common

This is just a wrapper for non-runtime exceptions

JxlsException() - Constructor for exception org.jxls.common.JxlsException

JxlsException(String) - Constructor for exception org.jxls.common.JxlsException

JxlsException(String, Throwable) - Constructor for exception org.jxls.common.JxlsException

JxlsException(Throwable) - Constructor for exception org.jxls.common.JxlsException

JxlsException(String, Throwable, boolean, boolean) - Constructor for exception org.jxls.common.JxlsException

JxlsHelper - Class in org.jxls.util

Common utilities

M

minus(Size) - Method in class org.jxls.common.Size

O

org.jxls.area - package org.jxls.area

org.jxls.builder - package org.jxls.builder

org.jxls.builder.xls - package org.jxls.builder.xls

org.jxls.builder.xml - package org.jxls.builder.xml

org.jxls.command - package org.jxls.command

org.jxls.common - package org.jxls.common

org.jxls.common.cellshift - package org.jxls.common.cellshift

org.jxls.expression - package org.jxls.expression

org.jxls.formula - package org.jxls.formula

org.jxls.jdbc - package org.jxls.jdbc

org.jxls.template - package org.jxls.template

org.jxls.transform - package org.jxls.transform

org.jxls.util - package org.jxls.util

P

parseSheetName(String, int) - Static method in class org.jxls.util.CellRefUtil

POI_CLASS_NAME - Static variable in class org.jxls.util.TransformerFactory

POI_TRANSFORMER - Static variable in class org.jxls.util.TransformerFactory

processAreaFormulas(Transformer) - Method in class org.jxls.formula.FastFormulaProcessor

processAreaFormulas(Transformer) - Method in interface org.jxls.formula.FormulaProcessor

processAreaFormulas(Transformer) - Method in class org.jxls.formula.StandardFormulaProcessor

processFormulas() - Method in interface org.jxls.area.Area

processFormulas() - Method in class org.jxls.area.XlsArea

processGridTemplate(InputStream, OutputStream, Context, String) - Method in class org.jxls.util.JxlsHelper

processGridTemplateAtCell(InputStream, OutputStream, Context, String, String) - Method in class org.jxls.util.JxlsHelper

processJxlsParams(String) - Method in class org.jxls.common.CellData

processTemplate(InputStream, OutputStream, Context) - Method in class org.jxls.util.JxlsHelper

processTemplateAtCell(InputStream, OutputStream, Context, String) - Method in class org.jxls.util.JxlsHelper

put(String, Object) - Method in class org.jxls.jdbc.CaseInsensitiveHashMap

putAll(Map<? extends String, ?>) - Method in class org.jxls.jdbc.CaseInsensitiveHashMap

putVar(String, Object) - Method in class org.jxls.common.Context

Q

query(String, Object...) - Method in class org.jxls.jdbc.JdbcHelper

R

REF_ATTR - Static variable in class org.jxls.builder.xml.AreaAction

REF_ATTR - Static variable in class org.jxls.builder.xml.EachAction

REF_ATTR - Static variable in class org.jxls.builder.xml.GridAction

REF_ATTR - Static variable in class org.jxls.builder.xml.IfAction

REF_ATTR - Static variable in class org.jxls.builder.xml.UserCommandAction

regexAreaRef - Static variable in class org.jxls.util.Util

regexAreaRefPattern - Static variable in class org.jxls.util.Util

regexCellRef - Static variable in class org.jxls.util.Util

regexCellRefExcludingJointed - Static variable in class org.jxls.util.Util

regexJointedCellRef - Static variable in class org.jxls.util.Util

regexJointedLookBehind - Static variable in class org.jxls.util.Util

regexSimpleCellRef - Static variable in class org.jxls.util.Util

registerGridTemplate(InputStream) - Method in class org.jxls.template.SimpleExporter

registerGridTemplate(InputStream) - Method in class org.jxls.util.JxlsHelper

remove(Object) - Method in class org.jxls.jdbc.CaseInsensitiveHashMap

removeVar(String) - Method in class org.jxls.common.Context

requiresColShifting(CellRef, int, int, int) - Method in class org.jxls.common.CellRange

requiresColShifting(CellRef, int, int, int) - Method in class org.jxls.common.cellshift.AdjacentCellShiftStrategy

requiresColShifting(CellRef, int, int, int) - Method in interface org.jxls.common.cellshift.CellShiftStrategy

requiresColShifting(CellRef, int, int, int) - Method in class org.jxls.common.cellshift.InnerCellShiftStrategy

requiresRowShifting(CellRef, int, int, int) - Method in class org.jxls.common.CellRange

requiresRowShifting(CellRef, int, int, int) - Method in class org.jxls.common.cellshift.AdjacentCellShiftStrategy

requiresRowShifting(CellRef, int, int, int) - Method in interface org.jxls.common.cellshift.CellShiftStrategy

requiresRowShifting(CellRef, int, int, int) - Method in class org.jxls.common.cellshift.InnerCellShiftStrategy

reset() - Method in interface org.jxls.area.Area

reset() - Method in class org.jxls.area.XlsArea

reset() - Method in class org.jxls.command.AbstractCommand

reset() - Method in interface org.jxls.command.Command

Resets command data for repeatable command usage

resetArea(AreaRef) - Method in interface org.jxls.transform.Transformer

resetChangeMatrix() - Method in class org.jxls.common.CellRange

resetTargetCellRefs() - Method in class org.jxls.transform.AbstractTransformer

resetTargetCellRefs() - Method in interface org.jxls.transform.Transformer

resetTargetPos() - Method in class org.jxls.common.CellData

RowData - Class in org.jxls.common

Represents an excel row data holder

RowData() - Constructor for class org.jxls.common.RowData

rowDataList - Variable in class org.jxls.common.SheetData

S

separateAreaRefs(String) - Static method in class org.jxls.util.CellRefUtil

Separates Area refs in two parts and returns them as separate elements in a String array, each qualified with the sheet name (if present)

separateRefParts(String) - Static method in class org.jxls.util.CellRefUtil

setArea(XlsArea) - Method in class org.jxls.common.CellData

setAreaBuilder(AreaBuilder) - Method in class org.jxls.util.JxlsHelper

setAttrMap(Map<String, String>) - Method in class org.jxls.common.CellData

setCellComment(String) - Method in class org.jxls.common.CellData

setCellRefGenerator(CellRefGenerator) - Method in class org.jxls.command.EachCommand

setCellShiftStrategy(CellShiftStrategy) - Method in interface org.jxls.area.Area

setCellShiftStrategy(CellShiftStrategy) - Method in class org.jxls.area.XlsArea

setCellShiftStrategy(CellShiftStrategy) - Method in class org.jxls.common.CellRange

setCellStyleMap(Map<String, String>) - Method in class org.jxls.common.Context.Config

setCellType(CellData.CellType) - Method in class org.jxls.common.CellData

setClearCells(String) - Method in class org.jxls.builder.xls.AreaCommand

setCol(int) - Method in class org.jxls.common.CellRef

setCondition(String) - Method in class org.jxls.command.IfCommand

Sets test condition as JEXL expression string

setData(String) - Method in class org.jxls.command.GridCommand

setDefaultValue(String) - Method in class org.jxls.common.CellData

setDeleteTemplateSheet(boolean) - Method in class org.jxls.util.JxlsHelper

setDirection(EachCommand.Direction) - Method in class org.jxls.command.EachCommand

Sets iteration direction

setDirection(String) - Method in class org.jxls.command.EachCommand

setExpressionEvaluator(ExpressionEvaluator) - Method in class org.jxls.transform.TransformationConfig

setFormatCells(String) - Method in class org.jxls.command.GridCommand

setFormula(String) - Method in class org.jxls.common.CellData

setFormula(CellRef, String) - Method in interface org.jxls.transform.Transformer

setFormulaProcessor(FormulaProcessor) - Method in interface org.jxls.area.Area

setFormulaProcessor(FormulaProcessor) - Method in class org.jxls.area.XlsArea

setFormulaStrategy(CellData.FormulaStrategy) - Method in class org.jxls.common.CellData

setHeaders(String) - Method in class org.jxls.command.GridCommand

setHeight(int) - Method in class org.jxls.common.Size

setHidden(String, boolean) - Method in interface org.jxls.transform.Transformer

setHideTemplateSheet(boolean) - Method in class org.jxls.util.JxlsHelper

setIgnoreColumnProps(boolean) - Method in class org.jxls.transform.AbstractTransformer

setIgnoreRowProps(boolean) - Method in class org.jxls.transform.AbstractTransformer

setIgnoreSheetNameInFormat(boolean) - Method in class org.jxls.common.CellRef

setIgnoreSourceCellStyle(boolean) - Method in class org.jxls.common.Context.Config

setImageType(String) - Method in class org.jxls.command.ImageCommand

setIsColAbs(boolean) - Method in class org.jxls.common.CellRef

setIsFormulaProcessingRequired(boolean) - Method in class org.jxls.common.Context.Config

setIsRowAbs(boolean) - Method in class org.jxls.common.CellRef

setItem(Object) - Method in class org.jxls.common.GroupData

setItems(String) - Method in class org.jxls.command.EachCommand

Sets collection bean name

setItems(Collection) - Method in class org.jxls.common.GroupData

setObjectProperty(Object, String, String, boolean) - Static method in class org.jxls.util.Util

setObjectProperty(Object, String, String) - Static method in class org.jxls.util.Util

setProcessFormulas(boolean) - Method in class org.jxls.util.JxlsHelper

setProps(String) - Method in class org.jxls.command.GridCommand

setRow(int) - Method in class org.jxls.common.CellRef

setSelect(String) - Method in class org.jxls.command.EachCommand

Sets current 'select' expression for filtering collection

setSheetName(String) - Method in class org.jxls.common.CellRef

setShiftMode(String) - Method in class org.jxls.command.AbstractCommand

setShiftMode(String) - Method in interface org.jxls.command.Command

setSourceSize(Size) - Method in class org.jxls.area.CommandData

setSourceStartCellRef(CellRef) - Method in class org.jxls.area.CommandData

setSrc(String) - Method in class org.jxls.command.ImageCommand

setStartCellRef(CellRef) - Method in class org.jxls.area.CommandData

setTransformationConfig(TransformationConfig) - Method in class org.jxls.transform.AbstractTransformer

setTransformationConfig(TransformationConfig) - Method in interface org.jxls.transform.Transformer

setTransformer(Transformer) - Method in class org.jxls.area.XlsArea

setTransformer(Transformer) - Method in interface org.jxls.builder.AreaBuilder

setTransformer(Transformer) - Method in class org.jxls.builder.xls.XlsCommentAreaBuilder

setTransformer(Transformer) - Method in class org.jxls.builder.xml.XmlAreaBuilder

setTransformer(Transformer) - Method in class org.jxls.common.CellData

setTransformer(Transformer) - Method in class org.jxls.common.RowData

setTransformer(Transformer) - Method in class org.jxls.common.SheetData

setUseFastFormulaProcessor(boolean) - Method in class org.jxls.util.JxlsHelper

setVar(String) - Method in class org.jxls.command.EachCommand

Sets current variable name for collection item in the context during iteration

setWidth(int) - Method in class org.jxls.common.Size

SHEET_NAME_DELIMITER - Static variable in class org.jxls.util.CellRefUtil

The character (!) that separates sheet names from cell references

SheetData - Class in org.jxls.common

Represents an excel sheet data holder

SheetData() - Constructor for class org.jxls.common.SheetData

sheetMap - Variable in class org.jxls.transform.AbstractTransformer

sheetName - Variable in class org.jxls.common.SheetData

sheetNameRegex(Map.Entry<CellRef, List<CellRef>>) - Static method in class org.jxls.util.Util

shiftCellsWithColBlock(int, int, int, int, boolean) - Method in class org.jxls.common.CellRange

shiftCellsWithRowBlock(int, int, int, int, boolean) - Method in class org.jxls.common.CellRange

SimpleConfigurator - Class in org.jxls.builder.xml

Configurator used by XmlAreaBuilder to configure building rules

SimpleConfigurator(Map<ElementSelector, Action>) - Constructor for class org.jxls.builder.xml.SimpleConfigurator

SimpleConfigurator(Map<ElementSelector, Action>, List<ImplicitAction>) - Constructor for class org.jxls.builder.xml.SimpleConfigurator

SimpleExporter - Class in org.jxls.template

Helper class for grid export

SimpleExporter() - Constructor for class org.jxls.template.SimpleExporter

Size - Class in org.jxls.common

Date: Mar 13, 2009

Size() - Constructor for class org.jxls.common.Size

Size(int, int) - Constructor for class org.jxls.common.Size

StandardFormulaProcessor - Class in org.jxls.formula

This is a standard formula processor implementation which takes into account all performed cell transformations to properly evaluate all the formulas even for complex templates.

StandardFormulaProcessor() - Constructor for class org.jxls.formula.StandardFormulaProcessor

T

targetCellType - Variable in class org.jxls.common.CellData

toByteArray(InputStream) - Static method in class org.jxls.util.Util

Reads all the data from the input stream, and returns the bytes read.

toMap() - Method in class org.jxls.common.Context

toString() - Method in class org.jxls.common.AreaRef

toString() - Method in class org.jxls.common.CellData

toString(boolean) - Method in class org.jxls.common.CellRef

toString() - Method in class org.jxls.common.CellRef

toString() - Method in class org.jxls.common.Context

toString() - Method in class org.jxls.common.Size

transform(CellRef, CellRef, Context) - Method in interface org.jxls.transform.Transformer

TransformationConfig - Class in org.jxls.transform

Transformation configuration class

TransformationConfig() - Constructor for class org.jxls.transform.TransformationConfig

Transformer - Interface in org.jxls.transform

Defines interface methods for excel operations

TRANSFORMER_SYSTEM_PROPERTY - Static variable in class org.jxls.util.TransformerFactory

TransformerFactory - Class in org.jxls.util

TransformerFactory() - Constructor for class org.jxls.util.TransformerFactory

transformToCollectionObject(ExpressionEvaluator, String, Context) - Static method in class org.jxls.util.Util

U

updateFormulaValue() - Method in class org.jxls.common.CellData

USER_FORMULA_PREFIX - Static variable in class org.jxls.common.CellData

USER_FORMULA_SUFFIX - Static variable in class org.jxls.common.CellData

UserCommandAction - Class in org.jxls.builder.xml

Builds custom user command from XML

UserCommandAction() - Constructor for class org.jxls.builder.xml.UserCommandAction

Util - Class in org.jxls.util

Utility class with various helper methods used by other classes

Util() - Constructor for class org.jxls.util.Util

V

valueOf(String) - Static method in enum org.jxls.command.EachCommand.Direction

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.jxls.common.CellData.CellType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.jxls.common.CellData.FormulaStrategy

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.jxls.common.ImageType

Returns the enum constant of this type with the specified name.

values() - Static method in enum org.jxls.command.EachCommand.Direction

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.jxls.common.CellData.CellType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.jxls.common.CellData.FormulaStrategy

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.jxls.common.ImageType

Returns an array containing the constants of this enum type, in the order they are declared.

VAR_ATTR - Static variable in class org.jxls.builder.xml.EachAction

varMap - Variable in class org.jxls.common.Context

W

write() - Method in interface org.jxls.transform.Transformer

X

XlsArea - Class in org.jxls.area

Core implementation of Area interface

XlsArea(AreaRef, Transformer) - Constructor for class org.jxls.area.XlsArea

XlsArea(String, Transformer) - Constructor for class org.jxls.area.XlsArea

XlsArea(CellRef, CellRef, Transformer) - Constructor for class org.jxls.area.XlsArea

XlsArea(CellRef, Size, List<CommandData>, Transformer) - Constructor for class org.jxls.area.XlsArea

XlsArea(CellRef, Size) - Constructor for class org.jxls.area.XlsArea

XlsArea(CellRef, Size, Transformer) - Constructor for class org.jxls.area.XlsArea

XlsCommentAreaBuilder - Class in org.jxls.builder.xls

Builds XlsArea from excel comments in the excel template A command is specified in a cell comment like the following jx:COMMAND_NAME(attr1="value1" attr2="value2" ...

XlsCommentAreaBuilder() - Constructor for class org.jxls.builder.xls.XlsCommentAreaBuilder

XlsCommentAreaBuilder(Transformer) - Constructor for class org.jxls.builder.xls.XlsCommentAreaBuilder

XlsCommentAreaBuilder(Transformer, boolean) - Constructor for class org.jxls.builder.xls.XlsCommentAreaBuilder

XmlAreaBuilder - Class in org.jxls.builder.xml

Creates an area through XML definition

XmlAreaBuilder(Transformer) - Constructor for class org.jxls.builder.xml.XmlAreaBuilder

XmlAreaBuilder(InputStream, Transformer) - Constructor for class org.jxls.builder.xml.XmlAreaBuilder

XmlAreaBuilder(InputStream, Transformer, boolean) - Constructor for class org.jxls.builder.xml.XmlAreaBuilder

Z

ZERO_SIZE - Static variable in class org.jxls.common.Size

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