|
|||||||||
| Home >> All >> jxl >> [ biff overview ] | PREV NEXT | ||||||||
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.<