Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep
A B C D E F G H I J L M N O P R S T U V W X

A

ALRUNS - Static variable in class jxl.biff.Type
 
ANY - Static variable in class jxl.biff.DVParser
 
ARRAY - Static variable in class jxl.biff.Type
 
add(byte) - Method in class jxl.biff.ByteArray
Adds a byte onto the array
add(byte[]) - Method in class jxl.biff.ByteArray
Adds an array of bytes onto the array
add(DataValiditySettingsRecord) - Method in class jxl.biff.DataValidation
Adds a new settings object to this data validation
addFont(FontRecord) - Method in class jxl.biff.Fonts
Adds a font record to this workbook.
addFormat(DisplayFormat) - Method in class jxl.biff.FormattingRecords
Adds a cell format to the hash map, keyed on its index.
addStyle(XFRecord) - Method in class jxl.biff.FormattingRecords
Adds an extended formatting record to the list.
align - Variable in class jxl.biff.XFRecord
The alignment for this cell (left, right, centre)
append(String) - Method in class jxl.biff.HeaderFooter.Contents
Appends the text to the string buffer
appendDate() - Method in class jxl.biff.HeaderFooter.Contents
Appends the current date
appendInternal(String) - Method in class jxl.biff.HeaderFooter.Contents
Internal method which appends the text to the string buffer
appendInternal(char) - Method in class jxl.biff.HeaderFooter.Contents
Internal method which appends the text to the string buffer
appendPageNumber() - Method in class jxl.biff.HeaderFooter.Contents
Appends the page number
appendTime() - Method in class jxl.biff.HeaderFooter.Contents
Appends the current time
appendTotalPages() - Method in class jxl.biff.HeaderFooter.Contents
Appends the total number of pages
appendWorkSheetName() - Method in class jxl.biff.HeaderFooter.Contents
Appends the worksheet name
appendWorkbookName() - Method in class jxl.biff.HeaderFooter.Contents
Appends the workbook name
arbitrary - Static variable in class jxl.biff.Type
 

B

BACKUP - Static variable in class jxl.biff.Type
 
BELGIUM - Static variable in class jxl.biff.CountryCode
 
BETWEEN - Static variable in class jxl.biff.BaseCellFeatures
 
BETWEEN - Static variable in class jxl.biff.DVParser
 
BIG_BLOCK_DEPOT_BLOCKS_POS - Static variable in class jxl.biff.BaseCompoundFile
 
BIG_BLOCK_SIZE - Static variable in class jxl.biff.BaseCompoundFile
 
BLANK - Static variable in class jxl.biff.Type
 
BOF - Static variable in class jxl.biff.Type
 
BOLD_TOGGLE - Static variable in class jxl.biff.HeaderFooter
Turns bold printing on or off
BOOKBOOL - Static variable in class jxl.biff.Type
 
BOOLERR - Static variable in class jxl.biff.Type
 
BOTTOMMARGIN - Static variable in class jxl.biff.Type
 
BOUNDSHEET - Static variable in class jxl.biff.Type
 
BUTTONPROPERTYSET - Static variable in class jxl.biff.Type
 
BaseCellFeatures - class jxl.biff.BaseCellFeatures.
Container for any additional cell features
BaseCellFeatures() - Constructor for class jxl.biff.BaseCellFeatures
Constructor
BaseCellFeatures(BaseCellFeatures) - Constructor for class jxl.biff.BaseCellFeatures
Copy constructor
BaseCellFeatures.ValidationCondition - class jxl.biff.BaseCellFeatures.ValidationCondition.
 
BaseCellFeatures.ValidationCondition(DVParser.Condition) - Constructor for class jxl.biff.BaseCellFeatures.ValidationCondition
 
BaseCompoundFile - class jxl.biff.BaseCompoundFile.
Contains the common data for a compound file
BaseCompoundFile() - Constructor for class jxl.biff.BaseCompoundFile
Constructor
BaseCompoundFile.PropertyStorage - class jxl.biff.BaseCompoundFile.PropertyStorage.
Inner class to represent the property storage sets.
BaseCompoundFile.PropertyStorage(byte[]) - Constructor for class jxl.biff.BaseCompoundFile.PropertyStorage
Constructs a property set
BaseCompoundFile.PropertyStorage(String) - Constructor for class jxl.biff.BaseCompoundFile.PropertyStorage
Constructs an empty property set.
BuiltInFormat - class jxl.biff.BuiltInFormat.
The excel string for the various built in formats.
BuiltInFormat(String, int) - Constructor for class jxl.biff.BuiltInFormat
Constructor
BuiltInStyle - class jxl.biff.BuiltInStyle.
Represents a built in, rather than a user defined, style.
BuiltInStyle(int, int) - Constructor for class jxl.biff.BuiltInStyle
Constructor
ByteArray - class jxl.biff.ByteArray.
A growable array of bytes
ByteArray() - Constructor for class jxl.biff.ByteArray
Constructor
ByteArray(int) - Constructor for class jxl.biff.ByteArray
Constructor
ByteData - interface jxl.biff.ByteData.
Interface which provides a method for transferring chunks of binary data from one Excel file (read in) to another (written out)
backgroundColour - Variable in class jxl.biff.XFRecord
The background colour
biff7 - Static variable in class jxl.biff.FontRecord
 
biff7 - Static variable in class jxl.biff.FormatRecord
 
biff7 - Static variable in class jxl.biff.XFRecord
 
biff8 - Static variable in class jxl.biff.FormatRecord
 
biff8 - Static variable in class jxl.biff.XFRecord
 
biffType - Variable in class jxl.biff.XFRecord
The biff type
boldWeight - Variable in class jxl.biff.FontRecord
The bold weight for this font (normal or bold)
bottomBorder - Variable in class jxl.biff.XFRecord
The border indicator for the bottom of the cell
bottomBorderColour - Variable in class jxl.biff.XFRecord
The border colour for the bottom of the cell
builtIns - Static variable in class jxl.biff.BuiltInFormat
The list of built in formats
bytes - Variable in class jxl.biff.ByteArray
The current array

C

CALCCOUNT - Static variable in class jxl.biff.Type
 
CALCMODE - Static variable in class jxl.biff.Type
 
CANADA - Static variable in class jxl.biff.CountryCode
 
CENTRE - Static variable in class jxl.biff.HeaderFooter
Centres the characters that follow
CHILD_POS - Static variable in class jxl.biff.BaseCompoundFile
 
CHINA - Static variable in class jxl.biff.CountryCode
 
CODEPAGE - Static variable in class jxl.biff.Type
 
COLINFO - Static variable in class jxl.biff.Type
 
COLOUR_POS - Static variable in class jxl.biff.BaseCompoundFile
 
COMP_OBJ_NAME - Static variable in class jxl.biff.BaseCompoundFile
 
CONTINUE - Static variable in class jxl.biff.Type
 
COUNTRY - Static variable in class jxl.biff.Type
 
CRN - Static variable in class jxl.biff.Type
 
CellReferenceHelper - class jxl.biff.CellReferenceHelper.
A helper to transform between excel cell references and sheet:column:row notation Because this function will be called when generating a string representation of a formula, the cell reference will merely be appened to the string buffer instead of returning a full blooded string, for performance reasons
CellReferenceHelper() - Constructor for class jxl.biff.CellReferenceHelper
Constructor to prevent instantiation
ContinueRecord - class jxl.biff.ContinueRecord.
A continue record - only used explicitly in special circumstances, as the general continuation record is handled directly by the records
ContinueRecord(Record) - Constructor for class jxl.biff.ContinueRecord
Constructor
ContinueRecord(byte[]) - Constructor for class jxl.biff.ContinueRecord
Constructor invoked when creating continue records
CountryCode - class jxl.biff.CountryCode.
Enumeration type for the excel country codes
CountryCode(int, String, String) - Constructor for class jxl.biff.CountryCode
Constructor
CountryCode(int) - Constructor for class jxl.biff.CountryCode
Constructor used to create an arbitrary code with a specified value.
cell - Static variable in class jxl.biff.XFRecord
 
centre - Variable in class jxl.biff.HeaderFooter
The centrally aligned header/footer contents
characterSet - Variable in class jxl.biff.FontRecord
The character set
checkSize(int) - Method in class jxl.biff.ByteArray
Checks to see if there is sufficient space left on the array.
child - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The child for this property set
clear() - Method in class jxl.biff.HeaderFooter.Contents
Clears the contents of this portion
clear() - Method in class jxl.biff.HeaderFooter
Clears the contents of the header/footer
clearValidationSettings() - Method in class jxl.biff.BaseCellFeatures
Clears out any existing validation settings
code - Variable in class jxl.biff.CountryCode
The ISO 3166 two letter country mnemonic (as used by the Locale class)
code - Variable in class jxl.biff.RecordData
The Biff code for this record.
codes - Static variable in class jxl.biff.CountryCode
The array of country codes
col - Variable in class jxl.biff.EmptyCell
The column number of this empty cell
colour - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The colour of the property set
colourIndex - Variable in class jxl.biff.FontRecord
The index into the colour palette
column1 - Variable in class jxl.biff.DVParser
The column number of the cell at the top left of the range
column1 - Variable in class jxl.biff.RangeImpl
The column number of the cell at the top left of the range
column1 - Variable in class jxl.biff.SheetRangeImpl
The column number of the cell at the top left of the range
column2 - Variable in class jxl.biff.DVParser
The column index of the cell at the bottom right
column2 - Variable in class jxl.biff.RangeImpl
The column index of the cell at the bottom right
column2 - Variable in class jxl.biff.SheetRangeImpl
The column index of the cell at the bottom right
comboBox - Variable in class jxl.biff.BaseCellFeatures
A handle to the combo box object
comboBoxObjectId - Variable in class jxl.biff.DataValidation
The object id of the combo box used for drop downs
comment - Variable in class jxl.biff.BaseCellFeatures
The comment
commentDrawing - Variable in class jxl.biff.BaseCellFeatures
A handle to the drawing object
commentHeight - Variable in class jxl.biff.BaseCellFeatures
The comment height in cells
commentWidth - Variable in class jxl.biff.BaseCellFeatures
The comment width in cells
condition - Variable in class jxl.biff.BaseCellFeatures.ValidationCondition
 
condition - Variable in class jxl.biff.DVParser
The condition
contents - Variable in class jxl.biff.HeaderFooter.Contents
The buffer containing the header/footer string
copied - Variable in class jxl.biff.DataValidation
Indicates whether this was copied
copied - Variable in class jxl.biff.XFRecord
Flag to indicate whether this cell was copied.
copyTo(int, int) - Method in class jxl.biff.EmptyCell
Implementation of the deep copy function
createArbitraryCode(int) - Static method in class jxl.biff.CountryCode
Creates an arbitrary country code with the specified value.
createContents() - Method in class jxl.biff.HeaderFooter
Creates internal class of the appropriate type
createContents(String) - Method in class jxl.biff.HeaderFooter
Creates internal class of the appropriate type
createContents(HeaderFooter.Contents) - Method in class jxl.biff.HeaderFooter
Creates internal class of the appropriate type
createType(int) - Static method in class jxl.biff.Type
Used to create an arbitrary record type.
customFormatStartIndex - Static variable in class jxl.biff.FormattingRecords
The start index number for custom format records

D

DATE - Static variable in class jxl.biff.DVParser
 
DATE - Static variable in class jxl.biff.HeaderFooter
Prints the current date
DBCELL - Static variable in class jxl.biff.Type
 
DECIMAL - Static variable in class jxl.biff.DVParser
 
DEFAULTROWHEIGHT - Static variable in class jxl.biff.Type
 
DEFAULT_OBJECT_ID - Static variable in class jxl.biff.DataValidation
 
DEFCOLWIDTH - Static variable in class jxl.biff.Type
 
DELTA - Static variable in class jxl.biff.Type
 
DENMARK - Static variable in class jxl.biff.CountryCode
 
DIMENSION - Static variable in class jxl.biff.Type
 
DIRECTORY_PS_TYPE - Static variable in class jxl.biff.BaseCompoundFile
 
DOCUMENT_SUMMARY_INFORMATION_NAME - Static variable in class jxl.biff.BaseCompoundFile
 
DOUBLE_UNDERLINE_TOGGLE - Static variable in class jxl.biff.HeaderFooter
Turns double-underline printing on or off
DSF - Static variable in class jxl.biff.Type
 
DV - Static variable in class jxl.biff.Type
 
DVAL - Static variable in class jxl.biff.Type
 
DVParser - class jxl.biff.DVParser.
Class which parses the binary data associated with Data Validity (DV) setting
DVParser(byte[], ExternalSheet, WorkbookMethods, WorkbookSettings) - Constructor for class jxl.biff.DVParser
Constructor
DVParser(Collection) - Constructor for class jxl.biff.DVParser
Constructor called when creating a data validation from the API
DVParser(int, int, int, int) - Constructor for class jxl.biff.DVParser
Constructor called when creating a data validation from the API
DVParser(double, double, DVParser.Condition) - Constructor for class jxl.biff.DVParser
Constructor called when creating a data validation from the API
DVParser.Condition - class jxl.biff.DVParser.Condition.
 
DVParser.Condition(int, String) - Constructor for class jxl.biff.DVParser.Condition
 
DVParser.DVType - class jxl.biff.DVParser.DVType.
 
DVParser.DVType(int, String) - Constructor for class jxl.biff.DVParser.DVType
 
DVParser.ErrorStyle - class jxl.biff.DVParser.ErrorStyle.
 
DVParser.ErrorStyle(int) - Constructor for class jxl.biff.DVParser.ErrorStyle
 
DValParser - class jxl.biff.DValParser.
Class which parses the binary data associated with Data Validity (DVal) setting
DValParser(byte[]) - Constructor for class jxl.biff.DValParser
Constructor
DValParser(int, int) - Constructor for class jxl.biff.DValParser
Constructor
DataValidation - class jxl.biff.DataValidation.
Class which encapsulates a data validation (typically in the form of a dropdown list box)
DataValidation(DataValidityListRecord) - Constructor for class jxl.biff.DataValidation
Constructor
DataValidation(int, ExternalSheet, WorkbookMethods, WorkbookSettings) - Constructor for class jxl.biff.DataValidation
Constructor used to create writable data validations
DataValidation(DataValidation, ExternalSheet, WorkbookMethods, WorkbookSettings) - Constructor for class jxl.biff.DataValidation
Copy constructor used to copy drawings from read to write
DataValidityListRecord - class jxl.biff.DataValidityListRecord.
Record containing the list of data validation settings for a given sheet
DataValidityListRecord(Record) - Constructor for class jxl.biff.DataValidityListRecord
Constructor
DataValidityListRecord(DValParser) - Constructor for class jxl.biff.DataValidityListRecord
Constructor called when generating a data validity list from the API
DataValidityListRecord(DataValidityListRecord) - Constructor for class jxl.biff.DataValidityListRecord
Copy constructor
DataValiditySettingsRecord - class jxl.biff.DataValiditySettingsRecord.
Data validity settings
DataValiditySettingsRecord(Record, ExternalSheet, WorkbookMethods, WorkbookSettings) - Constructor for class jxl.biff.DataValiditySettingsRecord
Constructor
DataValiditySettingsRecord(DataValiditySettingsRecord) - Constructor for class jxl.biff.DataValiditySettingsRecord
Copy constructor
DataValiditySettingsRecord(DataValiditySettingsRecord, ExternalSheet, WorkbookMethods, WorkbookSettings) - Constructor for class jxl.biff.DataValiditySettingsRecord
Constructor
DataValiditySettingsRecord(DVParser) - Constructor for class jxl.biff.DataValiditySettingsRecord
Constructor called when the API creates a writable data validation
DisplayFormat - interface jxl.biff.DisplayFormat.
The interface implemented by the various number and date format styles.
DoubleHelper - class jxl.biff.DoubleHelper.
Class to help handle doubles
DoubleHelper() - Constructor for class jxl.biff.DoubleHelper
Private constructor to prevent instantiation
data - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The data that created this set
data - Variable in class jxl.biff.ContinueRecord
The data
data - Variable in class jxl.biff.DataValidityListRecord
The data
data - Variable in class jxl.biff.DataValiditySettingsRecord
The binary data
data - Variable in class jxl.biff.FormatRecord
The raw data
dataValidation - Variable in class jxl.biff.BaseCellFeatures
Indicates whether this cell features has data validation
dataValidation - Variable in class jxl.biff.DataValiditySettingsRecord
Handle to the data validation record
date - Variable in class jxl.biff.FormatRecord
Indicates whether this is a date formatting record
date - Variable in class jxl.biff.XFRecord
Indicates whether this is a date formatting record
dateFormat - Variable in class jxl.biff.XFRecord
The date format for this record.
dateFormats - Static variable in class jxl.biff.XFRecord
The list of built in date format values
dateStrings - Static variable in class jxl.biff.FormatRecord
The date strings to look for
defaultCommentHeight - Static variable in class jxl.biff.BaseCellFeatures
 
defaultCommentWidth - Static variable in class jxl.biff.BaseCellFeatures
 
defaultGrowSize - Static variable in class jxl.biff.ByteArray
 
defaultOptions - Static variable in class jxl.biff.WorkspaceInformationRecord
 
desc - Variable in class jxl.biff.DVParser.DVType
 
description - Variable in class jxl.biff.CountryCode
The long description
dirty - Variable in class jxl.biff.PaletteRecord
A dirty flag indicating that this palette has been tampered with in some way
dropDown - Variable in class jxl.biff.BaseCellFeatures
Indicates whether a drop down is required
dvAdded() - Method in class jxl.biff.DValParser
Called when adding a DV record on a copied DVal
dvAdded() - Method in class jxl.biff.DataValidityListRecord
Called when a writable DV record is added to a copied validity list
dvParser - Variable in class jxl.biff.BaseCellFeatures
The DV Parser used to contain the validation details
dvParser - Variable in class jxl.biff.DataValiditySettingsRecord
The reader
dvRemoved() - Method in class jxl.biff.DValParser
Called when a remove row or column results in one of DV records being removed
dvRemoved() - Method in class jxl.biff.DataValidityListRecord
Called when a remove row or column results in one of DV records being removed
dvalParser - Variable in class jxl.biff.DataValidityListRecord
The dval parser

E

EMPTY_CELLS_ALLOWED_MASK - Static variable in class jxl.biff.DVParser
 
EOF - Static variable in class jxl.biff.Type
 
EQUAL - Static variable in class jxl.biff.BaseCellFeatures
 
EQUAL - Static variable in class jxl.biff.DVParser
 
EXCEL_UNITS_PER_POINT - Static variable in class jxl.biff.FontRecord
The conversion factor between microsoft internal units and point size
EXTENSION_BLOCK_POS - Static variable in class jxl.biff.BaseCompoundFile
 
EXTERNNAME - Static variable in class jxl.biff.Type
 
EXTERNSHEET - Static variable in class jxl.biff.Type
 
EXTSST - Static variable in class jxl.biff.Type
 
EmptyCell - class jxl.biff.EmptyCell.
An empty cell.
EmptyCell(int, int) - Constructor for class jxl.biff.EmptyCell
Constructs an empty cell at the specified position
EncodedURLHelper - class jxl.biff.EncodedURLHelper.
Helper to get the Microsoft encoded URL from the given string
EncodedURLHelper() - Constructor for class jxl.biff.EncodedURLHelper
 
empty() - Method in class jxl.biff.HeaderFooter.Contents
Queries if the contents are empty
emptyCellsAllowed - Variable in class jxl.biff.DVParser
Empty cells allowed
endOfSubdirectory - Static variable in class jxl.biff.EncodedURLHelper
 
equals(Object) - Method in class jxl.biff.BuiltInFormat
Equals method
equals(Object) - Method in class jxl.biff.FontRecord
Standard equals method
equals(Object) - Method in class jxl.biff.FormatRecord
Standard equals method.
equals(Object) - Method in class jxl.biff.SheetRangeImpl
Standard equals method
equals(Object) - Method in class jxl.biff.Type
Standard equals method
equals(Object) - Method in class jxl.biff.XFRecord
Equals method.
errorStyle - Variable in class jxl.biff.DVParser
The error style
errorText - Variable in class jxl.biff.DVParser
The text of the error box
errorTitle - Variable in class jxl.biff.DVParser
The title of the error box
excelFormat - Variable in class jxl.biff.XFRecord
The excel format for this record.
externalSheet - Variable in class jxl.biff.DataValidation
Handle to the external sheet
externalSheet - Variable in class jxl.biff.DataValiditySettingsRecord
Handle to the externalSheet

F

FBI - Static variable in class jxl.biff.Type
 
FILEPASS - Static variable in class jxl.biff.Type
 
FILE_PS_TYPE - Static variable in class jxl.biff.BaseCompoundFile
 
FNGROUPCOUNT - Static variable in class jxl.biff.Type
 
FONT - Static variable in class jxl.biff.Type
 
FONTX - Static variable in class jxl.biff.Type
 
FOOTER - Static variable in class jxl.biff.Type
 
FORMAT - Static variable in class jxl.biff.Type
 
FORMULA - Static variable in class jxl.biff.DVParser
 
FORMULA - Static variable in class jxl.biff.Type
 
FORMULA2 - Static variable in class jxl.biff.Type
 
FRANCE - Static variable in class jxl.biff.CountryCode
 
FontRecord - class jxl.biff.FontRecord.
A record containing the necessary data for the font information
FontRecord(String, int, int, boolean, int, int, int) - Constructor for class jxl.biff.FontRecord
Constructor, used when creating a new font for writing out.
FontRecord(Record, WorkbookSettings) - Constructor for class jxl.biff.FontRecord
Constructs this object from the raw data.
FontRecord(Record, WorkbookSettings, FontRecord.Biff7) - Constructor for class jxl.biff.FontRecord
Constructs this object from the raw data.
FontRecord(Font) - Constructor for class jxl.biff.FontRecord
Publicly available copy constructor
FontRecord.Biff7 - class jxl.biff.FontRecord.Biff7.
Dummy indicators for overloading the constructor
FontRecord.Biff7() - Constructor for class jxl.biff.FontRecord.Biff7
 
Fonts - class jxl.biff.Fonts.
A container for the list of fonts used in this workbook
Fonts() - Constructor for class jxl.biff.Fonts
Constructor
FormatRecord - class jxl.biff.FormatRecord.
A non-built in format record
FormatRecord(String, int) - Constructor for class jxl.biff.FormatRecord
Constructor invoked when copying sheets
FormatRecord() - Constructor for class jxl.biff.FormatRecord
Constructor used by writable formats
FormatRecord(FormatRecord) - Constructor for class jxl.biff.FormatRecord
Copy constructor - can be invoked by public access
FormatRecord(Record, WorkbookSettings, FormatRecord.BiffType) - Constructor for class jxl.biff.FormatRecord
Constructs this object from the raw data.
FormatRecord.BiffType - class jxl.biff.FormatRecord.BiffType.
 
FormatRecord.BiffType() - Constructor for class jxl.biff.FormatRecord.BiffType
 
FormattingRecords - class jxl.biff.FormattingRecords.
The list of XF records and formatting records for the workbook
FormattingRecords(Fonts) - Constructor for class jxl.biff.FormattingRecords
Constructor
FormulaData - interface jxl.biff.FormulaData.
Interface which is used for copying formulas from a read only to a writable spreadsheet
fitToPages - Static variable in class jxl.biff.WorkspaceInformationRecord
 
fixedInd - Static variable in class jxl.biff.CellReferenceHelper
The character which indicates whether a reference is fixed
font - Variable in class jxl.biff.XFRecord
The font object for this XF record
fontFamily - Variable in class jxl.biff.FontRecord
The font family
fontIndex - Variable in class jxl.biff.FontRecord
The index of this font in the font list
fontIndex - Variable in class jxl.biff.XFRecord
The index to the font record used by this XF record
fonts - Variable in class jxl.biff.Fonts
The list of fonts
fonts - Variable in class jxl.biff.FormattingRecords
A handle to the available fonts
format - Variable in class jxl.biff.DVParser.Condition
 
format - Variable in class jxl.biff.FormatRecord
The format object
format - Variable in class jxl.biff.XFRecord
The format object for this XF record.
formatIndex - Variable in class jxl.biff.BuiltInFormat
The index
formatIndex - Variable in class jxl.biff.XFRecord
The index to the format record
formatInfoInitialized - Variable in class jxl.biff.XFRecord
Flag to indicate whether the format information has been initialized.
formatString - Variable in class jxl.biff.BuiltInFormat
The excel format string
formatString - Variable in class jxl.biff.FormatRecord
The formatting string
formats - Variable in class jxl.biff.FormattingRecords
A hash map of FormatRecords, for random access retrieval when reading in a spreadsheet
formatsList - Variable in class jxl.biff.FormattingRecords
A list of formats, used when writing out a spreadsheet
formattingRecords - Variable in class jxl.biff.XFRecord
A handle to the formatting records.
formula1 - Variable in class jxl.biff.DVParser
The first formula
formula1String - Variable in class jxl.biff.DVParser
The first formula string
formula2 - Variable in class jxl.biff.DVParser
The second formula
formula2String - Variable in class jxl.biff.DVParser
The second formula string

G

GERMANY - Static variable in class jxl.biff.CountryCode
 
GREATER_EQUAL - Static variable in class jxl.biff.BaseCellFeatures
 
GREATER_EQUAL - Static variable in class jxl.biff.DVParser
 
GREATER_THAN - Static variable in class jxl.biff.BaseCellFeatures
 
GREATER_THAN - Static variable in class jxl.biff.DVParser
 
GREECE - Static variable in class jxl.biff.CountryCode
 
GRIDSET - Static variable in class jxl.biff.Type
 
GUTS - Static variable in class jxl.biff.Type
 
getAlignment() - Method in class jxl.biff.XFRecord
Gets the horizontal cell alignment
getBackgroundColour() - Method in class jxl.biff.XFRecord
Gets the background colour used by this cell
getBoldWeight() - Method in class jxl.biff.FontRecord
Gets the bold weight for this font
getBorder(Border) - Method in class jxl.biff.XFRecord
Gets the line style for the given cell border If a border type of ALL or NONE is specified, then a line style of NONE is returned
getBorderColour(Border) - Method in class jxl.biff.XFRecord
Gets the line style for the given cell border If a border type of ALL or NONE is specified, then a line style of NONE is returned
getBorderLine(Border) - Method in class jxl.biff.XFRecord
Gets the line style for the given cell border If a border type of ALL or NONE is specified, then a line style of NONE is returned
getBottomRight() - Method in class jxl.biff.RangeImpl
Gets the cell at the bottom right of this range
getBottomRight() - Method in class jxl.biff.SheetRangeImpl
Gets the cell at the bottom right of this range
getBytes() - Method in class jxl.biff.ByteArray
Gets the complete array
getBytes() - Method in interface jxl.biff.ByteData
Used when writing out records
getBytes(String) - Static method in class jxl.biff.StringHelper
Deprecated.  
getBytes(String, WorkbookSettings) - Static method in class jxl.biff.StringHelper
Gets the bytes of the specified string.
getBytes(String, byte[], int) - Static method in class jxl.biff.StringHelper
Gets the ASCII bytes from the specified string and places them in the array at the specified position
getBytes() - Method in class jxl.biff.WritableRecordData
Used when writing out records.
getCellFeatures() - Method in class jxl.biff.EmptyCell
Accessor for the cell features
getCellFormat() - Method in class jxl.biff.EmptyCell
Accessor for the format which is applied to this cell
getCellReference(int, int, StringBuffer) - Static method in class jxl.biff.CellReferenceHelper
Gets the cell reference
getCellReference(int, boolean, int, boolean, StringBuffer) - Static method in class jxl.biff.CellReferenceHelper
Overloaded method which prepends $ for absolute reference
getCellReference(int, int, int, ExternalSheet, StringBuffer) - Static method in class jxl.biff.CellReferenceHelper
Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, boolean, int, boolean, ExternalSheet, StringBuffer) - Static method in class jxl.biff.CellReferenceHelper
Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, int, ExternalSheet) - Static method in class jxl.biff.CellReferenceHelper
Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int) - Static method in class jxl.biff.CellReferenceHelper
Gets the cell reference for the specified column and row
getCentreText() - Method in class jxl.biff.HeaderFooter
Accessor for the contents which in the centre of the page
getCode() - Method in class jxl.biff.CountryCode
Accessor for the string
getCode() - Method in class jxl.biff.RecordData
Accessor for the code
getColour() - Method in class jxl.biff.FontRecord
Gets the colour for this font
getColourRGB(Colour) - Method in class jxl.biff.FormattingRecords
Accessor for the RGB value for the specified colour
getColourRGB(Colour) - Method in class jxl.biff.PaletteRecord
Gets the colour RGB from the palette
getColumn(String) - Static method in class jxl.biff.CellReferenceHelper
Gets the columnn number of the string cell reference
getColumn() - Method in class jxl.biff.EmptyCell
Returns the column number of this cell
getColumnReference(int) - Static method in class jxl.biff.CellReferenceHelper
Gets the column letter corresponding to the 0-based column number
getColumnReference(int, StringBuffer) - Static method in class jxl.biff.CellReferenceHelper
Gets the column letter corresponding to the 0-based column number
getComboBoxObjectId() - Method in class jxl.biff.DataValidation
Accessor for the combo box, used when copying sheets
getComment() - Method in class jxl.biff.BaseCellFeatures
Accessor for the cell comment
getCommentDrawing() - Method in class jxl.biff.BaseCellFeatures
Accessor for the comment drawing
getCommentHeight() - Method in class jxl.biff.BaseCellFeatures
Accessor for the comment height
getCommentWidth() - Method in class jxl.biff.BaseCellFeatures
Accessor for the comment width
getCondition() - Method in class jxl.biff.BaseCellFeatures.ValidationCondition
 
getCondition(int) - Static method in class jxl.biff.DVParser.Condition
 
getConditionString(String, String) - Method in class jxl.biff.DVParser.Condition
 
getContents() - Method in class jxl.biff.EmptyCell
Quick and dirty function to return the contents of this cell as a string.
getContents() - Method in class jxl.biff.HeaderFooter.Contents
Retrieves a Stringified version of this object
getCountryCode(String) - Static method in class jxl.biff.CountryCode
Gets the country code for the given two character mnemonic string
getDVParser() - Method in class jxl.biff.BaseCellFeatures
Gets the dv parser
getData() - Method in class jxl.biff.BuiltInStyle
Abstract method implementation to get the raw byte data ready to write out
getData() - Method in class jxl.biff.ContinueRecord
Accessor for the binary data - used when copying
getData() - Method in class jxl.biff.DVParser
Gets the data
getData() - Method in class jxl.biff.DValParser
Gets the data
getData() - Method in class jxl.biff.DataValidityListRecord
Retrieves the data for output to binary file
getData() - Method in class jxl.biff.DataValiditySettingsRecord
Retrieves the data for output to binary file
getData() - Method in class jxl.biff.FontRecord
Gets the byte data for writing out
getData() - Method in class jxl.biff.FormatRecord
Used to get the data when writing out the format record
getData() - Method in class jxl.biff.PaletteRecord
Accessor for the binary data - used when copying
getData() - Method in class jxl.biff.WorkspaceInformationRecord
Gets the binary data for output to file
getData() - Method in class jxl.biff.WritableRecordData
Abstract method called by the getBytes method.
getData() - Method in class jxl.biff.XFRecord
Converts the various fields into binary data.
getDataValidationList() - Method in class jxl.biff.BaseCellFeatures
Gets the data validation list as a formula.
getDataValidityList() - Method in class jxl.biff.DataValidation
Accessor for the validity list.
getDataValiditySettings() - Method in class jxl.biff.DataValidation
Accessor for the validity settings.
getDataValiditySettings(int, int) - Method in class jxl.biff.DataValidation
Used during the copy process to retrieve the validity settings for a particular cell
getDateFormat() - Method in class jxl.biff.FormatRecord
Gets the java equivalent date format for the formatString
getDateFormat(int) - Method in class jxl.biff.FormattingRecords
Gets the DateFormat used to format the cell.
getDateFormat() - Method in class jxl.biff.XFRecord
Gets the java date format for this format record
getDescription() - Method in class jxl.biff.DVParser.DVType
 
getEncodedURL(String, WorkbookSettings) - Static method in class jxl.biff.EncodedURLHelper
 
getErrorStyle(int) - Static method in class jxl.biff.DVParser.ErrorStyle
 
getFile(String, WorkbookSettings) - Static method in class jxl.biff.EncodedURLHelper
 
getFirstColumn() - Method in class jxl.biff.DVParser
Accessor for first column
getFirstColumn() - Method in class jxl.biff.DataValiditySettingsRecord
Accessor for first column
getFirstRow() - Method in class jxl.biff.DVParser
Accessor for first row
getFirstRow() - Method in class jxl.biff.DataValiditySettingsRecord
Accessor for first row
getFirstSheetIndex() - Method in class jxl.biff.RangeImpl
Gets the index of the first sheet in the range
getFirstSheetIndex() - Method in class jxl.biff.SheetRangeImpl
Not supported.
getFitToPages() - Method in class jxl.biff.WorkspaceInformationRecord
Gets the fit to pages flag
getFont(int) - Method in class jxl.biff.Fonts
Used by FormattingRecord for retrieving the fonts for the hardcoded styles
getFont() - Method in class jxl.biff.XFRecord
Gets the font used by this format
getFontIndex() - Method in class jxl.biff.FontRecord
Accessor for the font index
getFontIndex() - Method in class jxl.biff.XFRecord
Accessor for the font index.
getFonts() - Method in class jxl.biff.FormattingRecords
Accessor for the fonts used by this workbook
getFormat() - Method in class jxl.biff.XFRecord
Gets the format used by this format
getFormatIndex() - Method in class jxl.biff.BuiltInFormat
Accessor for the index style of this format
getFormatIndex() - Method in interface jxl.biff.DisplayFormat
Accessor for the index style of this format
getFormatIndex() - Method in class jxl.biff.FormatRecord
Gets the format index of this record
getFormatRecord(int) - Method in class jxl.biff.FormattingRecords
Gets the format record
getFormatRecord() - Method in class jxl.biff.XFRecord
Gets the lookup number of the format record
getFormatString() - Method in class jxl.biff.BuiltInFormat
Accesses the excel format string which is applied to the cell Note that this is the string that excel uses, and not the java equivalent
getFormatString() - Method in class jxl.biff.FormatRecord
Gets the formatting string.
getFormulaData() - Method in interface jxl.biff.FormulaData
Gets the raw bytes for the formula.
getFourBytes(int) - Static method in class jxl.biff.IntegerHelper
Gets a four byte array from an integer
getFourBytes(int, byte[], int) - Static method in class jxl.biff.IntegerHelper
Converts an integer into four bytes, and places it in the array at the specified position
getHidden() - Method in class jxl.biff.XFRecord
Accessor for the hidden flag
getIEEEBytes(double, byte[], int) - Static method in class jxl.biff.DoubleHelper
Puts the IEEE representation of the double provided into the array at the designated position
getIEEEDouble(byte[], int) - Static method in class jxl.biff.DoubleHelper
Gets the IEEE value from the byte array passed in
getIndentation() - Method in class jxl.biff.XFRecord
Gets the indentation
getIndexCode() - Method in class jxl.biff.FormatRecord
Gets the index code, for use as a hash value
getInt(byte, byte) - Static method in class jxl.biff.IntegerHelper
Gets an int from two bytes
getInt(byte, byte, byte, byte) - Static method in class jxl.biff.IntegerHelper
Gets an int from four bytes, doing all the necessary swapping
getLastColumn() - Method in class jxl.biff.DVParser
Accessor for the last column
getLastColumn() - Method in class jxl.biff.DataValiditySettingsRecord
Accessor for the last column
getLastRow() - Method in class jxl.biff.DVParser
Accessor for the last row
getLastRow() - Method in class jxl.biff.DataValiditySettingsRecord
Accessor for the last row
getLastSheetIndex() - Method in class jxl.biff.RangeImpl
Gets the index of the last sheet in the range
getLastSheetIndex() - Method in class jxl.biff.SheetRangeImpl
Not supported.
getLeftText() - Method in class jxl.biff.HeaderFooter
Accessor for the contents which appear on the left hand side of the page
getLocked() - Method in class jxl.biff.XFRecord
Accessor for the locked flag
getName() - Method in class jxl.biff.FontRecord
Gets the name of this font
getName(int) - Method in interface jxl.biff.WorkbookMethods
Gets the name at the specified index
getNameIndex(String) - Method in interface jxl.biff.WorkbookMethods
Gets the index of the name record for the name
getNewIndex(int) - Method in class jxl.biff.IndexMapping
Gets the new cell format index
getNumberFormat() - Method in class jxl.biff.FormatRecord
Gets the java equivalent number format for the formatString
getNumberFormat(int) - Method in class jxl.biff.FormattingRecords
Gets the NumberFormat used to format the cell.
getNumberFormat() - Method in class jxl.biff.XFRecord
Gets the java number format for this format record
getNumberIndex(String) - Static method in class jxl.biff.CellReferenceHelper
Finds the position where the first number occurs in the string
getNumberOfDVRecords() - Method in class jxl.biff.DValParser
Accessor for the number of DV records
getNumberOfFormatRecords() - Method in class jxl.biff.FormattingRecords
Gets the number of formatting records on the list.
getNumberOfSettings() - Method in class jxl.biff.DataValidityListRecord
Accessor for the number of settings records associated with this list
getObjectId() - Method in class jxl.biff.DValParser
Accessor for the object id
getObjectId() - Method in class jxl.biff.DataValidityListRecord
Accessor for the object id
getOrientation() - Method in class jxl.biff.XFRecord
Gets the orientation
getPalette() - Method in class jxl.biff.FormattingRecords
Accessor for the colour palette
getPattern() - Method in class jxl.biff.XFRecord
Gets the pattern used by this cell format
getPointSize() - Method in class jxl.biff.FontRecord
Gets the point size for this font, if the font hasn't been initialized
getReadSheet(int) - Method in interface jxl.biff.WorkbookMethods
Gets the specified sheet within this workbook
getRecord() - Method in class jxl.biff.RecordData
Returns the raw data to its subclasses
getRightText() - Method in class jxl.biff.HeaderFooter
Accessor for the contents which appear on the right hand side of the page
getRow(String) - Static method in class jxl.biff.CellReferenceHelper
Gets the row number of the cell reference
getRow() - Method in class jxl.biff.EmptyCell
Returns the row number of this cell
getScriptStyle() - Method in class jxl.biff.FontRecord
Gets the script style
getSheet(String) - Static method in class jxl.biff.CellReferenceHelper
Gets the sheet name from the cell reference string
getShort(byte, byte) - Static method in class jxl.biff.IntegerHelper
Gets an short from two bytes
getString(byte[], int, int, WorkbookSettings) - Static method in class jxl.biff.StringHelper
Gets a string from the data array using the character encoding for this workbook
getTopLeft() - Method in class jxl.biff.RangeImpl
Gets the cell at the top left of this range
getTopLeft() - Method in class jxl.biff.SheetRangeImpl
Gets the cell at the top left of this range
getTwoBytes(int) - Static method in class jxl.biff.IntegerHelper
Gets a two byte array from an integer
getTwoBytes(int, byte[], int) - Static method in class jxl.biff.IntegerHelper
Converts an integer into two bytes, and places it in the array at the specified position
getType(int) - Static method in class jxl.biff.DVParser.DVType
 
getType() - Method in class jxl.biff.EmptyCell
Returns the content type of this cell
getType(int) - Static method in class jxl.biff.Type
Gets the type object from its integer value
getURL(String, WorkbookSettings) - Static method in class jxl.biff.EncodedURLHelper
 
getUnderlineStyle() - Method in class jxl.biff.FontRecord
Gets the underline style for this font
getUnicodeBytes(String) - Static method in class jxl.biff.StringHelper
Converts the string into a little-endian array of Unicode bytes
getUnicodeBytes(String, byte[], int) - Static method in class jxl.biff.StringHelper
Inserts the unicode byte representation of the specified string into the array passed in
getUnicodeString(byte[], int, int) - Static method in class jxl.biff.StringHelper
Gets a string from the data array
getValidationFormula() - Method in class jxl.biff.DVParser
Gets the formula present in the validation
getValidationFormula() - Method in class jxl.biff.DataValiditySettingsRecord
 
getValue() - Method in class jxl.biff.CountryCode
Accessor for the excel value
getValue() - Method in class jxl.biff.DVParser.Condition
 
getValue() - Method in class jxl.biff.DVParser.DVType
 
getValue() - Method in class jxl.biff.DVParser.ErrorStyle
 
getVerticalAlignment() - Method in class jxl.biff.XFRecord
Gets the vertical cell alignment
getWrap() - Method in class jxl.biff.XFRecord
Gets whether or not the contents of this cell are wrapped
getWritableCellFeatures() - Method in class jxl.biff.EmptyCell
Accessor for the cell features
getXFIndex() - Method in class jxl.biff.XFRecord
Accessor for the XF index
getXFRecord(int) - Method in class jxl.biff.FormattingRecords
Gets the XFRecord for the specified index.
growSize - Variable in class jxl.biff.ByteArray
The array grow size

H

HCENTER - Static variable in class jxl.biff.Type
 
HEADER - Static variable in class jxl.biff.Type
 
HIDEOBJ - Static variable in class jxl.biff.Type
 
HLINK - Static variable in class jxl.biff.Type
 
HORIZONTALPAGEBREAKS - Static variable in class jxl.biff.Type
 
HeaderFooter - class jxl.biff.HeaderFooter.
Class which represents an Excel header or footer.
HeaderFooter() - Constructor for class jxl.biff.HeaderFooter
Default constructor.
HeaderFooter(HeaderFooter) - Constructor for class jxl.biff.HeaderFooter
Copy constructor
HeaderFooter(String) - Constructor for class jxl.biff.HeaderFooter
Constructor used when reading workbooks to separate the left, right a central part of the strings into their constituent parts
HeaderFooter.Contents - class jxl.biff.HeaderFooter.Contents.
The contents - a simple wrapper around a string buffer
HeaderFooter.Contents() - Constructor for class jxl.biff.HeaderFooter.Contents
The constructor
HeaderFooter.Contents(String) - Constructor for class jxl.biff.HeaderFooter.Contents
Constructor used when reading worksheets.
HeaderFooter.Contents(HeaderFooter.Contents) - Constructor for class jxl.biff.HeaderFooter.Contents
Copy constructor
handleContinueRecords(byte[]) - Method in class jxl.biff.WritableRecordData
The number of bytes for this record exceeds the maximum record length, so a continue is required
hasBorders() - Method in class jxl.biff.XFRecord
Determines if this cell format has any borders at all.
hasDVRecords() - Method in class jxl.biff.DataValidityListRecord
Accessor for the number of DV records
hasDataValidation() - Method in class jxl.biff.BaseCellFeatures
Accessor for the data validation
hasDropDown() - Method in class jxl.biff.BaseCellFeatures
Accessor for whether a drop down is required
hashCode() - Method in class jxl.biff.FontRecord
Standard hash code method
hashCode() - Method in class jxl.biff.FormatRecord
Standard hash code method
hashCode() - Method in class jxl.biff.SheetRangeImpl
Standard hash code method
hashCode() - Method in class jxl.biff.Type
Standard hash code method
hashCode() - Method in class jxl.biff.XFRecord
Standard hash code implementation
hidden - Variable in class jxl.biff.XFRecord
Flag to indicate whether this XF record is hidden

I

IDENTIFIER - Static variable in class jxl.biff.BaseCompoundFile
The identifier at the beginning of every OLE file
IFMT - Static variable in class jxl.biff.Type
 
INDEX - Static variable in class jxl.biff.Type
 
INDIA - Static variable in class jxl.biff.CountryCode
 
INFO - Static variable in class jxl.biff.DVParser
 
INTEGER - Static variable in class jxl.biff.DVParser
 
INTERFACEEND - Static variable in class jxl.biff.Type
 
INTERFACEHDR - Static variable in class jxl.biff.Type
 
ITALICS_TOGGLE - Static variable in class jxl.biff.HeaderFooter
Turns italic printing on or off
ITALY - Static variable in class jxl.biff.CountryCode
 
ITERATION - Static variable in class jxl.biff.Type
 
IndexMapping - class jxl.biff.IndexMapping.
This class is a wrapper for a list of mappings between indices.
IndexMapping(int) - Constructor for class jxl.biff.IndexMapping
Constructor
IntegerHelper - class jxl.biff.IntegerHelper.
Converts excel byte representations into integers
IntegerHelper() - Constructor for class jxl.biff.IntegerHelper
Private constructor disables the instantiation of this object
indentation - Variable in class jxl.biff.XFRecord
Indentation of the cell text
indexCode - Variable in class jxl.biff.FormatRecord
The index code
initialize(int) - Method in class jxl.biff.BuiltInFormat
Initializes this format with the specified index number
initialize() - Method in class jxl.biff.DataValiditySettingsRecord
Initializes the dvParser
initialize(int) - Method in interface jxl.biff.DisplayFormat
Initializes this format with the specified index number
initialize(int) - Method in class jxl.biff.FontRecord
Sets the font index of this record.
initialize(int) - Method in class jxl.biff.FormatRecord
Sets the index of this record.
initialize() - Method in class jxl.biff.PaletteRecord
Initialize the record data
initialize(int, FormattingRecords, Fonts) - Method in class jxl.biff.XFRecord
If this cell has not been read in from an existing Excel sheet, then initializes this record with the XF index passed in.
initializeFormatInformation() - Method in class jxl.biff.<