A C D E F G I O R S T V W

A

addEvaluate(ExcelAntEvaluateCell) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

addFunction(String, String) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Used to add a UDF to the evaluator.

addFunction(String, FreeRefFunction) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Updates the internal HashMap of functions with instance and alias passed in.

addHandler(ExcelAntHandlerTask) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

addPrecision(ExcelAntPrecision) - Method in class org.apache.poi.ss.excelant.ExcelAntTask

addSetDouble(ExcelAntSetDoubleCell) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

addSetFormula(ExcelAntSetFormulaCell) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

addSetString(ExcelAntSetStringCell) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

addTest(ExcelAntTest) - Method in class org.apache.poi.ss.excelant.ExcelAntTask

addUdf(ExcelAntUserDefinedFunction) - Method in class org.apache.poi.ss.excelant.ExcelAntTask

C

cellStr - Variable in class org.apache.poi.ss.excelant.ExcelAntSet

className - Variable in class org.apache.poi.ss.excelant.ExcelAntUserDefinedFunction

D

didTestPass() - Method in class org.apache.poi.ss.excelant.ExcelAntTest

didTestPass() - Method in class org.apache.poi.ss.excelant.util.ExcelAntEvaluationResult

E

evaluateCell(String, double, double) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Uses a String in standard Excel format (SheetName!CellId) to locate a cell and evaluate it.

evaluationCompleteWithError() - Method in class org.apache.poi.ss.excelant.util.ExcelAntEvaluationResult

ExcelAntEvaluateCell - Class in org.apache.poi.ss.excelant

Instances of this class are used to evaluate a single cell.

ExcelAntEvaluateCell() - Constructor for class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

ExcelAntEvaluationResult - Class in org.apache.poi.ss.excelant.util

A simple class that encapsulates information about a cell evaluation from POI.

ExcelAntEvaluationResult(boolean, boolean, double, String, double, String) - Constructor for class org.apache.poi.ss.excelant.util.ExcelAntEvaluationResult

ExcelAntHandlerTask - Class in org.apache.poi.ss.excelant

This is the class that backs the tag in the Ant task.

ExcelAntHandlerTask() - Constructor for class org.apache.poi.ss.excelant.ExcelAntHandlerTask

ExcelAntPrecision - Class in org.apache.poi.ss.excelant

ExcelAntPrecision() - Constructor for class org.apache.poi.ss.excelant.ExcelAntPrecision

ExcelAntSet - Class in org.apache.poi.ss.excelant

ExcelAntSet() - Constructor for class org.apache.poi.ss.excelant.ExcelAntSet

ExcelAntSetDoubleCell - Class in org.apache.poi.ss.excelant

Class for use in an Ant build script that sets the value of an Excel sheet cell using the cell id ('Sheet Name'!cellId).

ExcelAntSetDoubleCell() - Constructor for class org.apache.poi.ss.excelant.ExcelAntSetDoubleCell

ExcelAntSetFormulaCell - Class in org.apache.poi.ss.excelant

Class for use in an Ant build script that sets the formula of an Excel sheet cell using the cell id ('Sheet Name'!cellId).

ExcelAntSetFormulaCell() - Constructor for class org.apache.poi.ss.excelant.ExcelAntSetFormulaCell

ExcelAntSetStringCell - Class in org.apache.poi.ss.excelant

Class for use in an Ant build script that sets the value of an Excel sheet cell using the cell id ('Sheet Name'!cellId).

ExcelAntSetStringCell() - Constructor for class org.apache.poi.ss.excelant.ExcelAntSetStringCell

ExcelAntTask - Class in org.apache.poi.ss.excelant

Ant task class for testing Excel workbook cells.

ExcelAntTask() - Constructor for class org.apache.poi.ss.excelant.ExcelAntTask

ExcelAntTest - Class in org.apache.poi.ss.excelant

This class represents a single test.

ExcelAntTest() - Constructor for class org.apache.poi.ss.excelant.ExcelAntTest

ExcelAntUserDefinedFunction - Class in org.apache.poi.ss.excelant

This class encapsulates the Strings necessary to create the User Defined Function instances that will be passed to POI's Evaluator instance.

ExcelAntUserDefinedFunction() - Constructor for class org.apache.poi.ss.excelant.ExcelAntUserDefinedFunction

ExcelAntWorkbookUtil - Class in org.apache.poi.ss.excelant.util

A general utility class that abstracts the POI details of loading the workbook, accessing and updating cells.

ExcelAntWorkbookUtil(String) - Constructor for class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Constructs an instance using a String that contains the fully qualified path of the Excel file.

ExcelAntWorkbookUtil(Workbook) - Constructor for class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Constructs an instance based on a Workbook instance.

ExcelAntWorkbookUtilFactory - Class in org.apache.poi.ss.excelant.util

This is a factory class maps file names to WorkbookUtil instances.

execute() - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

execute() - Method in class org.apache.poi.ss.excelant.ExcelAntHandlerTask

execute() - Method in class org.apache.poi.ss.excelant.ExcelAntSetDoubleCell

execute() - Method in class org.apache.poi.ss.excelant.ExcelAntSetFormulaCell

execute() - Method in class org.apache.poi.ss.excelant.ExcelAntSetStringCell

execute() - Method in class org.apache.poi.ss.excelant.ExcelAntTask

execute() - Method in class org.apache.poi.ss.excelant.ExcelAntTest

execute() - Method in interface org.apache.poi.ss.excelant.IExcelAntWorkbookHandler

F

functionAlias - Variable in class org.apache.poi.ss.excelant.ExcelAntUserDefinedFunction

G

getCell() - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

getCell() - Method in class org.apache.poi.ss.excelant.ExcelAntSet

getCellAsDouble(String) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Returns the value of the Cell as a double.

getCellAsString(String) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Returns a Cell as a String value.

getCellName() - Method in class org.apache.poi.ss.excelant.util.ExcelAntEvaluationResult

getCellValue() - Method in class org.apache.poi.ss.excelant.ExcelAntSetDoubleCell

Return the cell value as a double.

getCellValue() - Method in class org.apache.poi.ss.excelant.ExcelAntSetFormulaCell

getCellValue() - Method in class org.apache.poi.ss.excelant.ExcelAntSetStringCell

Return the value that will be set into the cell.

getClassName() - Method in class org.apache.poi.ss.excelant.ExcelAntUserDefinedFunction

getDelta() - Method in class org.apache.poi.ss.excelant.util.ExcelAntEvaluationResult

getErrorMessage() - Method in class org.apache.poi.ss.excelant.util.ExcelAntEvaluationResult

getEvaluator(String) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Returns a formula evaluator that is loaded with the functions that have been supplied.

getEvaluators() - Method in class org.apache.poi.ss.excelant.ExcelAntTest

getExpectedValue() - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

getFileName() - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Returns the fileName that was used to initialize this instance.

getFunctionAlias() - Method in class org.apache.poi.ss.excelant.ExcelAntUserDefinedFunction

getFunctions() - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

returns a UDFFinder that contains all of the functions added.

getInstance(String) - Static method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtilFactory

Using the fileName, check the internal map to see if an instance of the WorkbookUtil exists.

getName() - Method in class org.apache.poi.ss.excelant.ExcelAntTest

getPrecision() - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

getResult() - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

getReturnValue() - Method in class org.apache.poi.ss.excelant.util.ExcelAntEvaluationResult

getSheets() - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Returns the list of sheet names.

getValue() - Method in class org.apache.poi.ss.excelant.ExcelAntPrecision

getWorkbook() - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Returns the Workbook instance associated with this WorkbookUtil.

I

IExcelAntWorkbookHandler - Interface in org.apache.poi.ss.excelant

In Excel there are many ways to handle manipulating a workbook based on some arbitrary user action (onChange, etc).

O

org.apache.poi.ss.excelant - package org.apache.poi.ss.excelant

org.apache.poi.ss.excelant.util - package org.apache.poi.ss.excelant.util

R

requiredToPass() - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

S

setCell(String) - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

setCell(String) - Method in class org.apache.poi.ss.excelant.ExcelAntSet

setClassName(String) - Method in class org.apache.poi.ss.excelant.ExcelAntHandlerTask

setClassName(String) - Method in class org.apache.poi.ss.excelant.ExcelAntUserDefinedFunction

setDateValue(String, Date) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Utility method for setting the value of a Cell with a Date.

setDoubleValue(String, double) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

This method uses a String in standard Excel format (SheetName!CellId) to locate the cell and set it to the value of the double in value.

setEAWorkbookUtil(ExcelAntWorkbookUtil) - Method in class org.apache.poi.ss.excelant.ExcelAntHandlerTask

setExpectedValue(double) - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

setFailOnError(boolean) - Method in class org.apache.poi.ss.excelant.ExcelAntTask

setFileName(String) - Method in class org.apache.poi.ss.excelant.ExcelAntTask

setFormulaValue(String, String) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Utility method for setting the value of a Cell with a Formula.

setFunctionAlias(String) - Method in class org.apache.poi.ss.excelant.ExcelAntUserDefinedFunction

setGlobalPrecision(double) - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

setName(String) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

setPrecision(double) - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

setPrecision(double) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

setRequiredToPass(boolean) - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

setShowDelta(boolean) - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

setShowFailureDetail(boolean) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

setShowSuccessDetails(boolean) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

setStringValue(String, String) - Method in class org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil

Utility method for setting the value of a Cell with a String.

setValue(double) - Method in class org.apache.poi.ss.excelant.ExcelAntPrecision

setValue(double) - Method in class org.apache.poi.ss.excelant.ExcelAntSetDoubleCell

Set the value of the specified cell as the double passed in.

setValue(String) - Method in class org.apache.poi.ss.excelant.ExcelAntSetFormulaCell

setValue(String) - Method in class org.apache.poi.ss.excelant.ExcelAntSetStringCell

Set the value of the cell to the String passed in.

setWorkbook(Workbook) - Method in interface org.apache.poi.ss.excelant.IExcelAntWorkbookHandler

setWorkbookUtil(ExcelAntWorkbookUtil) - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

setWorkbookUtil(ExcelAntWorkbookUtil) - Method in class org.apache.poi.ss.excelant.ExcelAntSet

setWorkbookUtil(ExcelAntWorkbookUtil) - Method in class org.apache.poi.ss.excelant.ExcelAntTest

showDelta() - Method in class org.apache.poi.ss.excelant.ExcelAntEvaluateCell

showSuccessDetails() - Method in class org.apache.poi.ss.excelant.ExcelAntTest

T

toString() - Method in class org.apache.poi.ss.excelant.util.ExcelAntEvaluationResult

V

VERSION - Static variable in class org.apache.poi.ss.excelant.ExcelAntTask

W

wbUtil - Variable in class org.apache.poi.ss.excelant.ExcelAntSet

A C D E F G I O R S T V W