jxl.biff.formula
Interface ExternalSheet

All Known Implementing Classes:

WorkbookParser, WritableWorkbookImpl

public interface ExternalSheet

Interface which exposes the methods needed by formulas to access external sheet records

Method Summary

int	getExternalSheetIndex(int index) Gets the index of the first external sheet for the name
int	getExternalSheetIndex(java.lang.String sheetName) Gets the index of the first external sheet for the name
java.lang.String	getExternalSheetName(int index) Gets the name of the external sheet specified by the index
int	getLastExternalSheetIndex(int index) Gets the index of the first external sheet for the name
int	getLastExternalSheetIndex(java.lang.String sheetName) Gets the index of the last external sheet for the name
BOFRecord	getWorkbookBof() Parsing of formulas is only supported for a subset of the available biff version, so we need to test to see if this version is acceptable

Method Detail

getExternalSheetName

public java.lang.String getExternalSheetName(int index)

Gets the name of the external sheet specified by the index

Parameters:

index - the external sheet index

Returns:

the name of the external sheet

getExternalSheetIndex

public int getExternalSheetIndex(java.lang.String sheetName)

Gets the index of the first external sheet for the name

Parameters:

sheetName - the name of the external sheet

Returns:

the index of the external sheet with the specified name

getExternalSheetIndex

public int getExternalSheetIndex(int index)

Gets the index of the first external sheet for the name

Parameters:

index - the external sheet index

Returns:

the sheet index of the external sheet index

getLastExternalSheetIndex

public int getLastExternalSheetIndex(java.lang.String sheetName)

Gets the index of the last external sheet for the name

Parameters:

sheetName - the name of the external sheet

Returns:

the index of the external sheet with the specified name

getLastExternalSheetIndex

public int getLastExternalSheetIndex(int index)

Gets the index of the first external sheet for the name

Parameters:

index - the external sheet index

Returns:

the sheet index of the external sheet index

getWorkbookBof

public BOFRecord getWorkbookBof()

Parsing of formulas is only supported for a subset of the available biff version, so we need to test to see if this version is acceptable

Returns:

the BOF record, which