io.keikai.model.impl.sys.formula

Class ParsingBook

java.lang.Object

io.keikai.model.impl.sys.formula.ParsingBook

All Implemented Interfaces:

Serializable, FormulaParsingWorkbook, FormulaRenderingWorkbook

public class ParsingBook
extends Object
implements FormulaParsingWorkbook, FormulaRenderingWorkbook, Serializable

A pseudo formula parsing workbook for parsing only.

Since:

3.5.0

Author:

Pao

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
ParsingBook(SBook book)

Method Summary

Modifier and Type	Method and Description
TablePtg	createTablePtg(String tableName, Object[] specifiers, int sheetIndex, int rowIdx, int colIdx)
int	findExternalSheetIndex(String sheetName)
int	findExternalSheetIndex(String workbookName, String sheetName)
EvaluationWorkbook.ExternalSheet	getAnyExternalSheet(int externSheetIndex)
String	getBookNameFromExternalLinkIndex(String externalLinkIndex) Return the associated book name of the specified ExternalLink index.
String	getExternalLinkIndexFromBookName(String bookname)
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()
String	getFullNameText(NamePtg namePtg) Return the full qualified expression.
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
Object[]	getNameInfo(NamePtg namePtg)
String	getNameText(NamePtg namePtg)
NameXPtg	getNameXPtg(String name)
EvaluationName	getOrCreateName(String name, int sheetIndex) named range name matching is case insensitive
String	getSheetNameByExternSheet(int externSheetIndex)
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.
boolean	isAllowedDeferredNamePtg() In HSSF, we need to render a formula string from stored Ptg, so a formula cannot be parsed to DeferredNamePtg.
void	renameName(int sheetIndex, String oldName, String newName)
void	renameSheet(String bookName, String oldName, String newName) rename a sheet in this parsing book directly.
void	reorderSheet(String bookName, int oldIndex, int newIndex) reorder a sheet in this parsing book directly.
Object[]	resolveNameXInfo(NameXPtg nameXPtg)
String	resolveNameXText(NameXPtg nameXPtg)

Methods inherited from class java.lang.Object

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

Constructor Detail

ParsingBook

public ParsingBook(SBook book)

Method Detail

renameName

public void renameName(int sheetIndex,
                       String oldName,
                       String newName)

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 FormulaParsingWorkbook

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

findExternalSheetIndex

public int findExternalSheetIndex(String sheetName)

Parameters:

sheetName - sheet name or 3D sheet name (e.g "Sheet1:Sheet3")

Returns:

the external sheet index or -1 if not found

findExternalSheetIndex

public int findExternalSheetIndex(String workbookName,
                                  String sheetName)

Parameters:

workbookName - book name or null

sheetName - sheet name or 3D sheet name (e.g "Sheet1:Sheet3")

Returns:

the external sheet index or -1 if not found

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

getNameText

public String getNameText(NamePtg namePtg)

Specified by:

getNameText in interface FormulaRenderingWorkbook

getFullNameText

public String getFullNameText(NamePtg namePtg)

Description copied from interface: FormulaRenderingWorkbook

Return the full qualified expression.

Specified by:

getFullNameText in interface FormulaRenderingWorkbook

Returns:

getNameInfo

public Object[] getNameInfo(NamePtg namePtg)

resolveNameXText

public String resolveNameXText(NameXPtg nameXPtg)

Specified by:

resolveNameXText in interface FormulaRenderingWorkbook

resolveNameXInfo

public Object[] resolveNameXInfo(NameXPtg nameXPtg)

getAnyExternalSheet

public EvaluationWorkbook.ExternalSheet getAnyExternalSheet(int externSheetIndex)

Returns:

internal or external sheet.

getExternalSheet

public EvaluationWorkbook.ExternalSheet getExternalSheet(int externSheetIndex)

Specified by:

getExternalSheet in interface FormulaRenderingWorkbook

Returns:

null if externSheetIndex refers to a sheet inside the current workbook

getSheetNameByExternSheet

public String getSheetNameByExternSheet(int externSheetIndex)

Specified by:

getSheetNameByExternSheet in interface FormulaRenderingWorkbook

getExternalLinkIndexFromBookName

public String getExternalLinkIndexFromBookName(String bookname)

Specified by:

getExternalLinkIndexFromBookName in interface FormulaRenderingWorkbook

renameSheet

public void renameSheet(String bookName,
                        String oldName,
                        String newName)

rename a sheet in this parsing book directly. if it can't find a sheet with old name, it won't create a sheet for the new name.

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

reorderSheet

public void reorderSheet(String bookName,
                         int oldIndex,
                         int newIndex)

reorder a sheet in this parsing book directly.

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