io.keikai.model.impl.sys.formula

Class EvalBook

java.lang.Object

io.keikai.model.impl.sys.formula.EvalBook

All Implemented Interfaces:

Serializable, EvaluationWorkbook, FormulaParsingWorkbook

public final class EvalBook
extends Object
implements EvaluationWorkbook, FormulaParsingWorkbook, Serializable

modified from org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook

Author:

Josh Micich, Pao

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from interface org.zkoss.poi.ss.formula.EvaluationWorkbook

EvaluationWorkbook.ExternalName, EvaluationWorkbook.ExternalSheet

Constructor Summary

Constructors

Constructor and Description
EvalBook(SBook book)

Method Summary

Modifier and Type	Method and Description
int	convertFromExternSheetIndex(int externSheetIndex)
int	convertLastIndexFromExternSheetIndex(int externSheetIndex)
TablePtg	createTablePtg(String tableName, Object[] specifiers, int sheetIndex, int rowIdx, int colIdx)
String	getBookNameFromExternalLinkIndex(String externalLinkIndex) Return the associated book name of the specified ExternalLink index.
EvaluationWorkbook.ExternalName	getExternalName(int externSheetIndex, int externNameIndex)
EvaluationWorkbook.ExternalSheet	getExternalSheet(int externSheetIndex)
int	getExternalSheetIndex(String sheetName) gets the externSheet index for a sheet from this workbook
int	getExternalSheetIndex(String workbookName, String sheetName) gets the externSheet index for a sheet from an external workbook
Map<String,Formula>	getFormulaParsingCache()
Ptg[]	getFormulaTokens(EvaluationCell cell)
Ptg[]	getFormulaTokens(int sheetIndex, String formula)
EvaluationName	getName(NamePtg namePtg)
EvaluationName	getName(NamePtg namePtg, int contextSheetIndex)
EvaluationName	getName(String name, int sheetIndex) named range name matching is case insensitive
EvaluationName	getName(String name, String sheetName) named range name matching is case insensitive
NameXPtg	getNameXPtg(String name)
SBook	getNBook()
EvaluationName	getOrCreateName(String name, int sheetIndex) named range name matching is case insensitive
EvaluationSheet	getSheet(int sheetIndex)
int	getSheetIndex(EvaluationSheet evalSheet)
int	getSheetIndex(String sheetName) Finds a sheet index by case insensitive name.
String	getSheetName(int sheetIndex)
SpreadsheetVersion	getSpreadsheetVersion() Returns an enum holding spreadhseet properties specific to an Excel version ( max column and row numbers, max arguments to a function, etc.)
String	getTableName(String name) Given a name and return the real table name(consider uppercase/lowecase); It can be used to check whether the specified name is a table name if the returned name is null.
UDFFinder	getUDFFinder()
boolean	isAllowedDeferredNamePtg() In HSSF, we need to render a formula string from stored Ptg, so a formula cannot be parsed to DeferredNamePtg.
String	resolveNameXText(NameXPtg n)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

EvalBook

public EvalBook(SBook book)

Method Detail

getNBook

public SBook getNBook()

getFormulaTokens

public Ptg[] getFormulaTokens(EvaluationCell cell)

Specified by:

getFormulaTokens in interface EvaluationWorkbook

getFormulaTokens

public Ptg[] getFormulaTokens(int sheetIndex,
                              String formula)

Specified by:

getFormulaTokens in interface EvaluationWorkbook

getName

public EvaluationName getName(String name,
                              int sheetIndex)

Description copied from interface: FormulaParsingWorkbook

named range name matching is case insensitive

Specified by:

getName in interface EvaluationWorkbook

Specified by:

getName in interface FormulaParsingWorkbook

getName

public EvaluationName getName(NamePtg namePtg)

Specified by:

getName in interface EvaluationWorkbook

getName

public EvaluationName getName(NamePtg namePtg,
                              int contextSheetIndex)

Specified by:

getName in interface EvaluationWorkbook

Returns:

getExternalName

public EvaluationWorkbook.ExternalName getExternalName(int externSheetIndex,
                                                       int externNameIndex)

Specified by:

getExternalName in interface EvaluationWorkbook

getUDFFinder

public UDFFinder getUDFFinder()

Specified by:

getUDFFinder in interface EvaluationWorkbook

getSheet

public EvaluationSheet getSheet(int sheetIndex)

Specified by:

getSheet in interface EvaluationWorkbook

getSheetIndex

public int getSheetIndex(EvaluationSheet evalSheet)

Specified by:

getSheetIndex in interface EvaluationWorkbook

Returns:

-1 if the specified sheet is from a different book

getSheetIndex

public int getSheetIndex(String sheetName)

Description copied from interface: EvaluationWorkbook

Finds a sheet index by case insensitive name.

Specified by:

getSheetIndex in interface EvaluationWorkbook

Returns:

the index of the sheet matching the specified name. -1 if not found

getSheetName

public String getSheetName(int sheetIndex)

Specified by:

getSheetName in interface EvaluationWorkbook

getExternalSheet

public EvaluationWorkbook.ExternalSheet getExternalSheet(int externSheetIndex)

Specified by:

getExternalSheet in interface EvaluationWorkbook

Returns:

null if externSheetIndex refers to a sheet inside the current workbook

resolveNameXText

public String resolveNameXText(NameXPtg n)

Specified by:

resolveNameXText in interface EvaluationWorkbook

convertFromExternSheetIndex

public int convertFromExternSheetIndex(int externSheetIndex)

Specified by:

convertFromExternSheetIndex in interface EvaluationWorkbook

Returns:

the sheet index of the sheet with the given external index.

convertLastIndexFromExternSheetIndex

public int convertLastIndexFromExternSheetIndex(int externSheetIndex)

Specified by:

convertLastIndexFromExternSheetIndex in interface EvaluationWorkbook

getNameXPtg

public NameXPtg getNameXPtg(String name)

Specified by:

getNameXPtg in interface FormulaParsingWorkbook

getExternalSheetIndex

public int getExternalSheetIndex(String sheetName)

Description copied from interface: FormulaParsingWorkbook

gets the externSheet index for a sheet from this workbook

Specified by:

getExternalSheetIndex in interface FormulaParsingWorkbook

getExternalSheetIndex

public int getExternalSheetIndex(String workbookName,
                                 String sheetName)

Description copied from interface: FormulaParsingWorkbook

gets the externSheet index for a sheet from an external workbook

Specified by:

getExternalSheetIndex in interface FormulaParsingWorkbook

Parameters:

workbookName - e.g. "Budget.xls"

sheetName - a name of a sheet in that workbook

getSpreadsheetVersion

public SpreadsheetVersion getSpreadsheetVersion()

Description copied from interface: FormulaParsingWorkbook

Returns an enum holding spreadhseet properties specific to an Excel version ( max column and row numbers, max arguments to a function, etc.)

Specified by:

getSpreadsheetVersion in interface FormulaParsingWorkbook

getBookNameFromExternalLinkIndex

public String getBookNameFromExternalLinkIndex(String externalLinkIndex)

Description copied from interface: FormulaParsingWorkbook

Return the associated book name of the specified ExternalLink index. Excel stores ExternalLink index in place of the [].(e.g. [1]Sheet1:Sheet3!xxx)

Specified by:

getBookNameFromExternalLinkIndex in interface FormulaParsingWorkbook

Parameters:

externalLinkIndex - external link index

Returns:

the associated book name of the specified ExternalLink index.

getOrCreateName

public EvaluationName getOrCreateName(String name,
                                      int sheetIndex)

Description copied from interface: FormulaParsingWorkbook

named range name matching is case insensitive

Specified by:

getOrCreateName in interface FormulaParsingWorkbook

isAllowedDeferredNamePtg

public boolean isAllowedDeferredNamePtg()

Description copied from interface: FormulaParsingWorkbook

In HSSF, we need to render a formula string from stored Ptg, so a formula cannot be parsed to DeferredNamePtg. Because DeferredNamePtg will be read as UnknownPtg for it's not written out.

Specified by:

isAllowedDeferredNamePtg in interface FormulaParsingWorkbook

Returns:

true for using DeferredNamePtg to represent a non-existed defined name during formula parsing. If false, parser will create a defined name for a non-existed one.

getName

public EvaluationName getName(String name,
                              String sheetName)

Description copied from interface: FormulaParsingWorkbook

named range name matching is case insensitive

Specified by:

getName in interface FormulaParsingWorkbook

createTablePtg

public TablePtg createTablePtg(String tableName,
                               Object[] specifiers,
                               int sheetIndex,
                               int rowIdx,
                               int colIdx)

Specified by:

createTablePtg in interface FormulaParsingWorkbook

Returns:

getTableName

public String getTableName(String name)

Description copied from interface: FormulaParsingWorkbook

Given a name and return the real table name(consider uppercase/lowecase); It can be used to check whether the specified name is a table name if the returned name is null.

Specified by:

getTableName in interface FormulaParsingWorkbook

Returns:

getFormulaParsingCache

public Map<String,Formula> getFormulaParsingCache()

Specified by:

getFormulaParsingCache in interface FormulaParsingWorkbook