< A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

<

() - Static method in class jxl.biff.BuiltInFormat
 

A

A3 - Static variable in class jxl.format.PaperSize
A3
A4 - Static variable in class jxl.format.PaperSize
A4
A4_SMALL - Static variable in class jxl.format.PaperSize
Small A4
A5 - Static variable in class jxl.format.PaperSize
A5
ABS - Static variable in class jxl.biff.formula.Function
 
ACCOUNTING_FLOAT - Static variable in class jxl.write.NumberFormats
Formatting for an integer which is presented in accounting format (ie.
ACCOUNTING_INTEGER - Static variable in class jxl.write.NumberFormats
Formatting for an integer which is presented in accounting format (ie.
ACCOUNTING_RED_FLOAT - Static variable in class jxl.write.NumberFormats
As ACCOUNTING_FLOAT except that deficits appear coloured red
ACCOUNTING_RED_INTEGER - Static variable in class jxl.write.NumberFormats
As ACCOUNTING_INTEGER except that deficits appear coloured red
ACOS - Static variable in class jxl.biff.formula.Function
 
ACOSH - Static variable in class jxl.biff.formula.Function
 
Add - class jxl.biff.formula.Add.
A cell reference in a formula
ADD - Static variable in class jxl.biff.formula.Token
 
Add() - Constructor for class jxl.biff.formula.Add
Constructor
add(BaseSharedFormulaRecord) - Method in class jxl.read.biff.SharedFormulaRecord
Adds this formula to the list of formulas, if it falls within the bounds
add(ParseItem) - Method in class jxl.biff.formula.Operator
Adds operands to this item
add(Range) - Method in class jxl.write.biff.MergedCellsRecord
Adds the range to the list of merged cells.
add(String) - Method in class jxl.write.biff.SSTRecord
Adds a string to this SST record.
add(String) - Method in class jxl.write.biff.SSTContinueRecord
Adds a string to this record.
addBlockPosition(int) - Method in class jxl.write.biff.IndexRecord
Adds another index record into the array
addCell(Cell) - Method in class jxl.read.biff.SheetReader
Adds the cell to the array
addCell(CellValue) - Method in class jxl.write.biff.RowRecord
Adds a cell to this row, growing the array of cells as required
addCell(WritableCell) - Method in interface jxl.write.WritableSheet
Adds a cell to this sheet The RowsExceededException may be caught if client code wishes to explicitly trap the case where too many rows have been written to the current sheet.
addCell(WritableCell) - Method in class jxl.write.biff.WritableSheetImpl
Adds the cell to this sheet.
addCellRowPosition(int) - Method in class jxl.write.biff.DBCellRecord
Adds a cell
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.
addHyperlink(WritableHyperlink) - Method in interface jxl.write.WritableSheet
Adds the specified hyperlink.
addHyperlink(WritableHyperlink) - Method in class jxl.write.biff.WritableSheetImpl
Adds the specified hyperlink
ADDIN - Static variable in class jxl.read.biff.SupbookRecord
 
addOperator(Operator) - Method in class jxl.biff.formula.TokenFormulaParser
Adds the specified operator to the parse tree, taking operands off the stack as appropriate
ADDRESS - Static variable in class jxl.biff.formula.Function
 
addRowPageBreak(int) - Method in interface jxl.write.WritableSheet
Forces a page break at the specified row
addRowPageBreak(int) - Method in class jxl.write.biff.WritableSheetImpl
Forces a page break at the specified row
addSheet(Sheet) - Method in class jxl.read.biff.WorkbookParser
Adds the sheet to the end of the array
addStyle(XFRecord) - Method in class jxl.biff.FormattingRecords
Adds an extended formatting record to the list.
addToSharedFormulas(BaseSharedFormulaRecord) - Method in class jxl.read.biff.SheetReader
Sees if the shared formula belongs to any of the shared formula groups
align - Variable in class jxl.biff.XFRecord
The alignment for this cell (left, right, centre)
Alignment - class jxl.format.Alignment.
Enumeration class which contains the various alignments for data within a cell
Alignment - class jxl.write.Alignment.
Deprecated. Repackaged as jxl.Alignment. This version is retained for backwards compatibility
Alignment() - Constructor for class jxl.write.Alignment
Deprecated. Private constructor
Alignment(int, String) - Constructor for class jxl.format.Alignment
Private constructor
alignments - Static variable in class jxl.format.Alignment
The list of alignments
alignments - Static variable in class jxl.format.VerticalAlignment
The list of alignments
ALL - Static variable in class jxl.format.Border
 
AND - Static variable in class jxl.biff.formula.Function
 
Area - class jxl.biff.formula.Area.
A nested class to hold range information
AREA - Static variable in class jxl.biff.formula.Token
 
Area() - Constructor for class jxl.biff.formula.Area
Constructor
Area(String) - Constructor for class jxl.biff.formula.Area
Constructor invoked when parsing a string formula
Area3d - class jxl.biff.formula.Area3d.
A nested class to hold range information
AREA3D - Static variable in class jxl.biff.formula.Token
 
Area3d(ExternalSheet) - Constructor for class jxl.biff.formula.Area3d
 
areaReference - Static variable in class jxl.read.biff.NameRecord
 
AREAS - Static variable in class jxl.biff.formula.Function
 
AREAV - Static variable in class jxl.biff.formula.Token
 
arguments - Variable in class jxl.biff.formula.VariableArgFunction
The number of arguments
arguments - Variable in class jxl.biff.formula.StringFormulaParser
The stack argument used when parsing a function in order to pass multiple arguments back to the calling method
ArgumentSeparator - class jxl.biff.formula.ArgumentSeparator.
A dummy token used when parsing strings in order to indicate the separation of parameters
ArgumentSeparator() - Constructor for class jxl.biff.formula.ArgumentSeparator
Constructor
ARIAL - Static variable in class jxl.write.WritableFont
Objects created with this font name will be rendered within Excel as ARIAL fonts
ARIAL - Static variable in class jxl.write.Font
Deprecated.  
ARIAL_10_PT - Static variable in class jxl.write.WritableWorkbook
The default font for Cell formats
ARRAY - Static variable in class jxl.biff.Type
 
arrayGrowSize - Variable in class jxl.WorkbookSettings
The amount of memory allocated to the array containing the workbook data when its current amount is exhausted.
arrayGrowSize - Variable in class jxl.read.biff.File
The amount to increase the growable array by
arrayGrowSize - Variable in class jxl.write.biff.File
The amount to increase the growable array by
asDisplayed - Variable in class jxl.write.biff.PrecisionRecord
The precision as displayed flag
ASIN - Static variable in class jxl.biff.formula.Function
 
ASINH - Static variable in class jxl.biff.formula.Function
 
ATAN - Static variable in class jxl.biff.formula.Function
 
ATAN2 - Static variable in class jxl.biff.formula.Function
 
ATANH - Static variable in class jxl.biff.formula.Function
 
Attribute - class jxl.biff.formula.Attribute.
A special attribute control token - typically either a SUM function or an IF function
ATTRIBUTE - Static variable in class jxl.biff.formula.Function
 
ATTRIBUTE - Static variable in class jxl.biff.formula.Token
 
Attribute() - Constructor for class jxl.biff.formula.Attribute
Constructor
Attribute(StringFunction) - Constructor for class jxl.biff.formula.Attribute
Constructor for use when this is called when parsing a string
authorString - Static variable in class jxl.write.biff.WriteAccessRecord
The author of this workbook (ie.
automatic - Static variable in class jxl.write.biff.CalcModeRecord
Automatic calculation
automaticNoTables - Static variable in class jxl.write.biff.CalcModeRecord
Automatic calculation, except tables
AVEDEV - Static variable in class jxl.biff.formula.Function
 
AVERAGE - Static variable in class jxl.biff.formula.Function
 
AVERAGEA - Static variable in class jxl.biff.formula.Function
 

B

backgroundColour - Variable in class jxl.biff.XFRecord
The background colour
backup - Variable in class jxl.write.biff.BackupRecord
Flag to indicate whether or not Excel should make backups
BACKUP - Static variable in class jxl.biff.Type
 
BackupRecord - class jxl.write.biff.BackupRecord.
Record which indicates whether Excel should save backup versions of the file
BackupRecord(boolean) - Constructor for class jxl.write.biff.BackupRecord
Constructor
BaseCompoundFile - class jxl.biff.BaseCompoundFile.
Contains the common data for a compound file
BaseCompoundFile.PropertyStorage - class jxl.biff.BaseCompoundFile.PropertyStorage.
Inner class to represent the property storage sets
BaseCompoundFile.PropertyStorage(BaseCompoundFile, byte[]) - Constructor for class jxl.biff.BaseCompoundFile.PropertyStorage
Constructs a property set
BaseCompoundFile.PropertyStorage(BaseCompoundFile, String) - Constructor for class jxl.biff.BaseCompoundFile.PropertyStorage
Constructs an empty property set.
BaseCompoundFile() - Constructor for class jxl.biff.BaseCompoundFile
Constructor
BaseSharedFormulaRecord - class jxl.read.biff.BaseSharedFormulaRecord.
A base class for shared formula records
BaseSharedFormulaRecord(Record, FormattingRecords, ExternalSheet, SheetImpl) - Constructor for class jxl.read.biff.BaseSharedFormulaRecord
Constructs this number
bbdPos - Variable in class jxl.write.biff.CompoundFile
The current position within the bbd.
bbdStartBlock - Variable in class jxl.write.biff.CompoundFile
The start block of the big block depot
BETADIST - Static variable in class jxl.biff.formula.Function
 
BETAINV - Static variable in class jxl.biff.formula.Function
 
biff7 - Static variable in class jxl.biff.FontRecord
 
biff7 - Static variable in class jxl.biff.XFRecord
 
biff7 - Static variable in class jxl.biff.FormatRecord
 
biff7 - Static variable in class jxl.read.biff.DimensionRecord
 
biff7 - Static variable in class jxl.read.biff.HeaderRecord
 
biff7 - Static variable in class jxl.read.biff.NameRecord
 
biff7 - Static variable in class jxl.read.biff.HorizontalPageBreaksRecord
 
biff7 - Static variable in class jxl.read.biff.FooterRecord
 
biff7 - Static variable in class jxl.read.biff.LabelRecord
 
biff7 - Static variable in class jxl.read.biff.ExternalSheetRecord
 
biff7 - Static variable in class jxl.read.biff.BoundsheetRecord
 
biff7 - Static variable in class jxl.read.biff.RStringRecord
 
Biff7 - Static variable in class jxl.read.biff.BOFRecord
The code used for biff8 files
biff8 - Static variable in class jxl.biff.XFRecord
 
biff8 - Static variable in class jxl.biff.FormatRecord
 
Biff8 - Static variable in class jxl.read.biff.BOFRecord
The code used for biff8 files
biff8Supported - Static variable in class jxl.biff.formula.FormulaException
 
BiffDump - class jxl.demo.BiffDump.
Generates a biff dump of the specified excel file
BiffDump(File, OutputStream) - Constructor for class jxl.demo.BiffDump
 
BiffException - exception jxl.read.biff.BiffException.
Exception thrown when reading a biff file
BiffException.BiffMessage - class jxl.read.biff.BiffException.BiffMessage.
 
BiffException.BiffMessage(String) - Constructor for class jxl.read.biff.BiffException.BiffMessage
Constructs this exception with the specified message
BiffException(BiffException.BiffMessage) - Constructor for class jxl.read.biff.BiffException
Constructs this exception with the specified message
BiffRecordReader - class jxl.read.biff.BiffRecordReader.
Serves up Record objects from a biff file.
BiffRecordReader(File) - Constructor for class jxl.read.biff.BiffRecordReader
 
biffType - Variable in class jxl.biff.XFRecord
The biff type
BIG_BLOCK_DEPOT_BLOCKS_POS - Static variable in class jxl.biff.BaseCompoundFile
 
BIG_BLOCK_SIZE - Static variable in class jxl.biff.BaseCompoundFile
 
bigBlockChain - Variable in class jxl.read.biff.CompoundFile
The sequence of blocks which comprise the big block chain
bigBlockDepot - Variable in class jxl.write.biff.CompoundFile
The current bbd block
bigBlockDepotBlocks - Variable in class jxl.read.biff.CompoundFile
The chain of blocks which comprise the big block depot
BinaryOperator - class jxl.biff.formula.BinaryOperator.
A cell reference in a formula
BinaryOperator() - Constructor for class jxl.biff.formula.BinaryOperator
Constructor
BINOMDIST - Static variable in class jxl.biff.formula.Function
 
BLACK - Static variable in class jxl.format.Colour
 
Blank - class jxl.write.Blank.
A blank cell.
BLANK - Static variable in class jxl.biff.Type
 
Blank(Cell) - Constructor for class jxl.write.Blank
Constructor used internally by the application when making a writable copy of a spreadsheet being read in
Blank(int, int) - Constructor for class jxl.write.Blank
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates
Blank(int, int, CellFormat) - Constructor for class jxl.write.Blank
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates in the manner specified by the CellFormat parameter
BlankCell - class jxl.read.biff.BlankCell.
A blank cell.
BlankCell(Record, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.BlankCell
Constructs this object from the raw data
BlankRecord - class jxl.write.biff.BlankRecord.
A blank record, which is used to contain formatting information
BlankRecord(Cell) - Constructor for class jxl.write.biff.BlankRecord
Constructor used when copying a formatted blank cell from a read only spreadsheet
BlankRecord(int, int) - Constructor for class jxl.write.biff.BlankRecord
Consructor used when creating a label from the user API
BlankRecord(int, int, CellFormat) - Constructor for class jxl.write.biff.BlankRecord
Constructor used when creating a label from the API.
blocks - Variable in class jxl.write.biff.IndexRecord
The number of blocks needed to hold all the rows
BLUE - Static variable in class jxl.format.Colour
 
BOF - Static variable in class jxl.biff.Type
 
bofPosition - Variable in class jxl.write.biff.IndexRecord
The position of the BOF record in the excel output stream
BOFRecord - class jxl.read.biff.BOFRecord.
A Beginning Of File record, found at the commencement of all substreams within a biff8 file
BOFRecord - class jxl.write.biff.BOFRecord.
Record to indicate the beginning of a new stream in the Compound File
BOFRecord.SheetBOF - class jxl.write.biff.BOFRecord.SheetBOF.
 
BOFRecord.SheetBOF() - Constructor for class jxl.write.biff.BOFRecord.SheetBOF
 
BOFRecord.WorkbookGlobalsBOF - class jxl.write.biff.BOFRecord.WorkbookGlobalsBOF.
 
BOFRecord.WorkbookGlobalsBOF() - Constructor for class jxl.write.biff.BOFRecord.WorkbookGlobalsBOF
 
BOFRecord(BOFRecord.SheetBOF) - Constructor for class jxl.write.biff.BOFRecord
Constructor for generating a sheet BOF record
BOFRecord(BOFRecord.WorkbookGlobalsBOF) - Constructor for class jxl.write.biff.BOFRecord
Constructor for generating a workbook globals BOF record
BOFRecord(Record) - Constructor for class jxl.read.biff.BOFRecord
Constructs this object from the raw data
bofs - Variable in class jxl.read.biff.WorkbookParser
 
BOLD - Static variable in class jxl.format.BoldStyle
Emboldened style
BOLD - Static variable in class jxl.write.WritableFont
Indicates that this font should be presented in a BOLD style
BOLD - Static variable in class jxl.write.Font
Deprecated.  
BoldStyle - class jxl.format.BoldStyle.
Enumeration class containing the various bold styles for data
BoldStyle - class jxl.write.BoldStyle.
Enumeration class containing the various bold styles for data
BoldStyle(int) - Constructor for class jxl.write.BoldStyle
Constructor
BoldStyle(int, String) - Constructor for class jxl.format.BoldStyle
Constructor
boldWeight - Variable in class jxl.biff.FontRecord
The bold weight for this font (normal or bold)
BOOKBOOL - Static variable in class jxl.biff.Type
 
BookboolRecord - class jxl.write.biff.BookboolRecord.
Writes out the workbook option flag (should it save the external link options)
BookboolRecord(boolean) - Constructor for class jxl.write.biff.BookboolRecord
Constructor
BOOL - Static variable in class jxl.biff.formula.Token
 
Boolean - class jxl.write.Boolean.
A cell, created by user applications, which contains a boolean (or in some cases an error) value
BOOLEAN - Static variable in class jxl.CellType
 
BOOLEAN_FORMULA - Static variable in class jxl.CellType
 
Boolean(BooleanCell) - Constructor for class jxl.write.Boolean
Constructor used internally by the application when making a writable copy of a spreadsheet that has been read in
Boolean(int, int, boolean) - Constructor for class jxl.write.Boolean
Constructs a boolean value, which, when added to a spreadsheet, will display the specified value at the column/row position indicated.
Boolean(int, int, boolean, CellFormat) - Constructor for class jxl.write.Boolean
Constructs a boolean, which, when added to a spreadsheet, will display the specified value at the column/row position with the specified CellFormat.
BooleanCell - interface jxl.BooleanCell.
This type represents the Microsoft concept of a Boolean.
BooleanFormulaCell - interface jxl.BooleanFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
BooleanFormulaRecord - class jxl.read.biff.BooleanFormulaRecord.
A boolean formula's last calculated value
BooleanFormulaRecord(Record, FormattingRecords, ExternalSheet, SheetImpl) - Constructor for class jxl.read.biff.BooleanFormulaRecord
Constructs this object from the raw data
BooleanRecord - class jxl.read.biff.BooleanRecord.
A boolean cell last calculated value
BooleanRecord - class jxl.write.biff.BooleanRecord.
A boolean cell's last calculated value
BooleanRecord(BooleanCell) - Constructor for class jxl.write.biff.BooleanRecord
Constructor used when copying a workbook
BooleanRecord(int, int, boolean) - Constructor for class jxl.write.biff.BooleanRecord
Constructor invoked by the user API
BooleanRecord(int, int, boolean, CellFormat) - Constructor for class jxl.write.biff.BooleanRecord
Overloaded constructor invoked from the API, which takes a cell format
BooleanRecord(Record, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.BooleanRecord
Constructs this object from the raw data
BooleanValue - class jxl.biff.formula.BooleanValue.
A boolean operand in a formula
BooleanValue() - Constructor for class jxl.biff.formula.BooleanValue
Constructor
BOOLERR - Static variable in class jxl.biff.Type
 
Border - class jxl.format.Border.
The location of a border
Border - class jxl.write.Border.
Deprecated. repackaged as jxl.format.Border
Border() - Constructor for class jxl.write.Border
Deprecated. Constructor
Border(String) - Constructor for class jxl.format.Border
Constructor
BorderLineStyle - class jxl.format.BorderLineStyle.
The border line style
BorderLineStyle - class jxl.write.BorderLineStyle.
Deprecated. Repackaged as jxl.format.BorderLineStyle
BorderLineStyle() - Constructor for class jxl.write.BorderLineStyle
Deprecated.  
BorderLineStyle(int, String) - Constructor for class jxl.format.BorderLineStyle
Constructor
BOTTOM - Static variable in class jxl.format.Border
 
BOTTOM - Static variable in class jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned at the bottom
bottomBorder - Variable in class jxl.biff.XFRecord
The border indicator for the bottom of the cell
bottomMargin - Variable in class jxl.SheetSettings
The margin from the bottom of the paper in inches
BOTTOMMARGIN - Static variable in class jxl.biff.Type
 
BottomMarginRecord - class jxl.read.biff.BottomMarginRecord.
Record for the left margin settings
BottomMarginRecord - class jxl.write.biff.BottomMarginRecord.
The settings for the left margin
BottomMarginRecord(double) - Constructor for class jxl.write.biff.BottomMarginRecord
 
BottomMarginRecord(Record) - Constructor for class jxl.read.biff.BottomMarginRecord
Constructor
BOUNDSHEET - Static variable in class jxl.biff.Type
 
BoundsheetRecord - class jxl.read.biff.BoundsheetRecord.
A boundsheet record, which contains the worksheet name
BoundsheetRecord - class jxl.write.biff.BoundsheetRecord.
Record which stores the sheet name, the sheet type and the stream position
BoundsheetRecord.Biff7 - class jxl.read.biff.BoundsheetRecord.Biff7.
Dummy indicators for overloading the constructor
BoundsheetRecord.Biff7() - Constructor for class jxl.read.biff.BoundsheetRecord.Biff7
 
BoundsheetRecord(Record) - Constructor for class jxl.read.biff.BoundsheetRecord
Constructs this object from the raw data
BoundsheetRecord(Record, BoundsheetRecord.Biff7) - Constructor for class jxl.read.biff.BoundsheetRecord
Constructs this object from the raw data
BoundsheetRecord(String, boolean) - Constructor for class jxl.write.biff.BoundsheetRecord
Constructor
boundsheets - Variable in class jxl.read.biff.WorkbookParser
The names of all the worksheets
BRIGHT_GREEN - Static variable in class jxl.format.Colour
 
BROWN - Static variable in class jxl.format.Colour
 
buildNameHash() - Method in class jxl.demo.BiffDump
Builds the hashmap of record names
BuiltInFormat - class jxl.biff.BuiltInFormat.
The excel string for the various built in formats.
BuiltInFormat(String) - Constructor for class jxl.biff.BuiltInFormat
Constructor
BuiltInFunction - class jxl.biff.formula.BuiltInFunction.
A built in function in a formula
BuiltInFunction() - Constructor for class jxl.biff.formula.BuiltInFunction
Constructor
BuiltInFunction(Function) - Constructor for class jxl.biff.formula.BuiltInFunction
Constructor used when parsing a formula from a string
builtIns - Static variable in class jxl.biff.BuiltInFormat
The list of built in formats
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
byteCount - Variable in class jxl.write.biff.SSTRecord
The count of bytes needed so far to contain this record
byteCount - Variable in class jxl.write.biff.SSTContinueRecord
The count of bytes needed so far to contain this record
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)
bytes - Variable in class jxl.read.biff.SSTRecord.ByteArrayHolder
 
bytesPerLine - Static variable in class jxl.demo.BiffDump
 

C

calcCount - Variable in class jxl.write.biff.CalcCountRecord
The iteration count
CALCCOUNT - Static variable in class jxl.biff.Type
 
CalcCountRecord - class jxl.write.biff.CalcCountRecord.
Record which stores the maximum iterations option from the Options dialog box
CalcCountRecord(int) - Constructor for class jxl.write.biff.CalcCountRecord
Constructor
CALCMODE - Static variable in class jxl.biff.Type
 
CalcModeRecord - class jxl.write.biff.CalcModeRecord.
The calculation mode for the workbook, as set from the Options dialog box
CalcModeRecord.CalcMode - class jxl.write.biff.CalcModeRecord.CalcMode.
 
CalcModeRecord.CalcMode(int) - Constructor for class jxl.write.biff.CalcModeRecord.CalcMode
Constructor
CalcModeRecord(CalcModeRecord.CalcMode) - Constructor for class jxl.write.biff.CalcModeRecord
Constructor
calculateValue(boolean) - Method in class jxl.write.biff.DateRecord
Calculates the 1900 based numerical value based upon the utc value held in the date object
calculationMode - Variable in class jxl.write.biff.CalcModeRecord
The calculation mode (manual, automatic)
CEILING - Static variable in class jxl.biff.formula.Function
 
Cell - interface jxl.Cell.
Represents an individual Cell within a Sheet.
CELL - Static variable in class jxl.biff.formula.Function
 
cellFormat - Variable in class jxl.read.biff.DateRecord
The raw cell format
cellFormat - Variable in class jxl.read.biff.NumberValue
The raw cell format
cellFormat - Variable in class jxl.read.biff.MulBlankCell
The raw cell format
CellFormat - interface jxl.CellFormat.
Deprecated. Repackaged as jxl.format.CellFormat
CellFormat - interface jxl.format.CellFormat.
Interface for cell formats
cellOffset - Variable in class jxl.write.biff.DBCellRecord
The position of the start of the next cell after the first row.
cellReference - Static variable in class jxl.read.biff.NameRecord
 
CellReference - class jxl.biff.formula.CellReference.
A cell reference in a formula
CellReference() - Constructor for class jxl.biff.formula.CellReference
Constructor
CellReference(Cell) - Constructor for class jxl.biff.formula.CellReference
Constructor
CellReference(String) - Constructor for class jxl.biff.formula.CellReference
Constructor invoked when parsing a text string
CellReference3d - class jxl.biff.formula.CellReference3d.
A 3d cell reference in a formula
CellReference3d(Cell, ExternalSheet) - Constructor for class jxl.biff.formula.CellReference3d
Constructor
cellReferenced - Static variable in class jxl.write.biff.JxlWriteException
 
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
 
cellRowPositions - Variable in class jxl.write.biff.DBCellRecord
The list of all cell positions in this block
cells - Variable in class jxl.read.biff.SheetImpl
The cells
cells - Variable in class jxl.read.biff.SheetReader
The cells
cells - Variable in class jxl.write.biff.RowRecord
The cells which comprise this row
CellType - class jxl.CellType.
An enumeration type listing the available content types for a cell
CellType(String) - Constructor for class jxl.CellType
Private constructor
CellValue - class jxl.read.biff.CellValue.
Abstract class for all records which actually contain cell values
CellValue - class jxl.write.biff.CellValue.
Abstract class which stores the common data used for cells, such as row, column and formatting information.
CellValue(Record, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.CellValue
Constructs this object from the raw cell data
CellValue(Type, Cell) - Constructor for class jxl.write.biff.CellValue
Constructor used when creating a writable cell from a read-only cell (when copying a workbook)
CellValue(Type, int, int) - Constructor for class jxl.write.biff.CellValue
Constructor used when building writable cells from the Java API
CellValue(Type, int, int, CellFormat) - Constructor for class jxl.write.biff.CellValue
Overloaded constructor used when building writable cells from the Java API which also takes a format
CellXFRecord - class jxl.write.biff.CellXFRecord.
A cell XF Record
CellXFRecord(FontRecord, DisplayFormat) - Constructor for class jxl.write.biff.CellXFRecord
Constructor
CellXFRecord(XFRecord) - Constructor for class jxl.write.biff.CellXFRecord
Copy constructor.
centre - Variable in class jxl.write.biff.VerticalCentreRecord
The centre flag
centre - Variable in class jxl.write.biff.HorizontalCentreRecord
The centre flag
CENTRE - Static variable in class jxl.format.Alignment
Data in cells with this alignment will be centred
CENTRE - Static variable in class jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned centrally
CHAR - Static variable in class jxl.biff.formula.Function
 
Chart - class jxl.biff.chart.Chart.
Contains the various biff records used to insert a chart into a worksheet
Chart - Static variable in class jxl.read.biff.BOFRecord
The code used for charts
Chart(MsoDrawingRecord, ObjRecord, int, int, File) - Constructor for class jxl.biff.chart.Chart
Constructor
charts - Variable in class jxl.read.biff.SheetImpl
A list of charts on this page
charts - Variable in class jxl.read.biff.SheetReader
The list of charts on this page
charts - Variable in class jxl.write.biff.SheetWriter
The list of charts
chartsDisabled - Static variable in class jxl.biff.Config
Flag to indicate whether the chart feature is enabled or not Charts deactivated using -Dnocharts=true on the JVM command line Activated by default or by using -Dnocharts=false on the JVM command line
checkBbdPos() - Method in class jxl.write.biff.CompoundFile
Checks that the data can fit into the current BBD block.
checkMergedBorders() - Method in class jxl.write.biff.SheetWriter
Check all the merged cells for borders.
checkMergedBorders() - Method in class jxl.write.biff.WritableSheetImpl
Check all the merged cells for borders.
checkRanges() - Method in class jxl.write.biff.MergedCellsRecord
Checks the cell ranges for intersections, or if the merged cells contains more than one item of data
CHIDIST - Static variable in class jxl.biff.formula.Function
 
CHIINV - Static variable in class jxl.biff.formula.Function
 
CHITEST - Static variable in class jxl.biff.formula.Function
 
CHOOSE - Static variable in class jxl.biff.formula.Function
 
CLEAN - Static variable in class jxl.biff.formula.Function
 
clear() - Method in class jxl.read.biff.SheetImpl
Clears out the array of cells.
clear() - Method in class jxl.read.biff.File
Clears the contents of the file
close() - Method in class jxl.Workbook
Closes this workbook, and frees makes any memory allocated available for garbage collection
close() - Method in class jxl.read.biff.WorkbookParser
Closes this workbook, and frees makes any memory allocated available for garbage collection
close() - Method in class jxl.read.biff.File
Deprecated. As of version 1.6 use workbook.close() instead
close() - Method in class jxl.write.WritableWorkbook
Closes this workbook, and makes any memory allocated available for garbage collection.
close() - Method in class jxl.write.biff.WritableWorkbookImpl
Closes this workbook, and frees makes any memory allocated available for garbage collection
close(boolean) - Method in class jxl.write.biff.File
Closes the file.
CloseParentheses - class jxl.biff.formula.CloseParentheses.
 
CloseParentheses() - Constructor for class jxl.biff.formula.CloseParentheses
 
closeStream - Variable in class jxl.write.biff.WritableWorkbookImpl
Indicates whether or not the output stream should be closed.
code - Variable in class jxl.biff.RecordData
The Biff code for this record.
code - Variable in class jxl.biff.formula.Function
The code which applies to this function
code - Variable in class jxl.read.biff.Record
The excel 97 code
CODE - Static variable in class jxl.biff.formula.Function
 
CODEPAGE - Static variable in class jxl.biff.Type
 
CodepageRecord - class jxl.write.biff.CodepageRecord.
Stores the default character set in operation when the workbook was saved
CodepageRecord() - Constructor for class jxl.write.biff.CodepageRecord
Constructor
col - Variable in class jxl.biff.EmptyCell
The column number of this empty cell
colFirst - Variable in class jxl.read.biff.MulRKRecord
The first column these rk number occur on
colFirst - Variable in class jxl.read.biff.MulBlankRecord
The first column these rk number occur on
colFirst - Variable in class jxl.write.biff.MulRKRecord
The first column these rk number occur on
colGutter - Variable in class jxl.write.biff.GuttersRecord
The column gutter
COLINFO - Static variable in class jxl.biff.Type
 
collapsed - Variable in class jxl.read.biff.RowRecord
Flag to indicate whether this row is collapsed or not
collapsed - Variable in class jxl.write.biff.RowRecord
Flag to indicate whether this row is outline collapsed or not
colLast - Variable in class jxl.read.biff.MulRKRecord
The last column these rk numbers occur on
colLast - Variable in class jxl.read.biff.MulBlankRecord
The last column these blank numbers occur on
colLast - Variable in class jxl.write.biff.MulRKRecord
The last column these rk number occur on
Colour - class jxl.format.Colour.
Enumeration class which contains the various colours available within the standard Excel colour palette
Colour - class jxl.write.Colour.
Deprecated. This has been repackaged as jxl.Colour
Colour() - Constructor for class jxl.write.Colour
Deprecated.  
Colour(int, String) - Constructor for class jxl.format.Colour
Private constructor
colourIndex - Variable in class jxl.biff.FontRecord
The index into the colour palette
colours - Static variable in class jxl.format.Colour
The list of colours
column - Variable in class jxl.biff.formula.CellReference3d
The column reference
column - Variable in class jxl.biff.formula.CellReference
The column reference
column - Variable in class jxl.biff.formula.SharedFormulaCellReference
The column reference
column - Variable in class jxl.read.biff.DateRecord
The column number of this cell record
column - Variable in class jxl.read.biff.CellValue
The column number of this cell record
column - Variable in class jxl.read.biff.NumberValue
The column containing this number
column - Variable in class jxl.read.biff.MulBlankCell
The column containing this blank
column - Variable in class jxl.write.biff.CellValue
The column in the worksheet at which this cell is located
column - Variable in class jxl.write.biff.ColumnInfoRecord
The column number which this format applies to
COLUMN - Static variable in class jxl.biff.formula.Function
 
column1 - Variable in class jxl.biff.SheetRangeImpl
The column number of the cell at the top left of the range
column1 - Variable in class jxl.read.biff.RangeImpl
The column number of the cell at the top left of the range
column2 - Variable in class jxl.biff.SheetRangeImpl
The column index of the cell at the bottom right
column2 - Variable in class jxl.read.biff.RangeImpl
The column index of the cell at the bottom right
columnFirst - Variable in class jxl.biff.formula.Area3d
 
columnFirst - Variable in class jxl.biff.formula.SharedFormulaArea
 
columnFirst - Variable in class jxl.biff.formula.Area
 
columnFirst - Variable in class jxl.read.biff.NameRecord.NameRange
 
columnFirstRelative - Variable in class jxl.biff.formula.Area3d
 
columnFirstRelative - Variable in class jxl.biff.formula.SharedFormulaArea
 
columnFirstRelative - Variable in class jxl.biff.formula.Area
 
columnFormats - Variable in class jxl.write.biff.SheetWriter
The column format overrides
columnFormats - Variable in class jxl.write.biff.WritableSheetImpl
The list of non-default column formats
ColumnInfoRecord - class jxl.read.biff.ColumnInfoRecord.
Contains the display info data which affects the entire columns
ColumnInfoRecord - class jxl.write.biff.ColumnInfoRecord.
Describes the column formatting for a particular column
ColumnInfoRecord(ColumnInfoRecord, int, FormattingRecords) - Constructor for class jxl.write.biff.ColumnInfoRecord
Constructor used when copying an existing spreadsheet
ColumnInfoRecord(int, int, XFRecord) - Constructor for class jxl.write.biff.ColumnInfoRecord
Constructor used when setting column information from the user API
ColumnInfoRecord(Record) - Constructor for class jxl.read.biff.ColumnInfoRecord
Constructor which creates this object from the binary data
columnInfos - Variable in class jxl.read.biff.SheetImpl
The list of specified (ie.
columnInfosArray - Variable in class jxl.read.biff.SheetImpl
An array of column info records.
columnInfosArray - Variable in class jxl.read.biff.SheetReader
An array of column info records.
columnInfosInitialized - Variable in class jxl.read.biff.SheetImpl
Indicates whether the columnInfos array has been initialized
columnLast - Variable in class jxl.biff.formula.Area3d
 
columnLast - Variable in class jxl.biff.formula.SharedFormulaArea
 
columnLast - Variable in class jxl.biff.formula.Area
 
columnLast - Variable in class jxl.read.biff.NameRecord.NameRange
 
columnLastRelative - Variable in class jxl.biff.formula.Area3d
 
columnLastRelative - Variable in class jxl.biff.formula.SharedFormulaArea
 
columnLastRelative - Variable in class jxl.biff.formula.Area
 
columnRelative - Variable in class jxl.biff.formula.CellReference3d
Indicates whether the column reference is relative or absolute
columnRelative - Variable in class jxl.biff.formula.CellReference
Indicates whether the column reference is relative or absolute
columnRelative - Variable in class jxl.biff.formula.SharedFormulaCellReference
Indicates whether the column reference is relative or absolute
COLUMNS - Static variable in class jxl.biff.formula.Function
 
COMBIN - Static variable in class jxl.biff.formula.Function
 
compare(Object, Object) - Method in class jxl.write.biff.WritableSheetImpl.ColumnInfoComparator
Comparison function for to ColumnInfoRecords
CompoundFile - class jxl.read.biff.CompoundFile.
Reads in and defrags an OLE compound compound file
CompoundFile - class jxl.write.biff.CompoundFile.
Writes out a compound file Header block is -1 Excel data is e..n (where is the head extension blocks, normally 0 and n is at least 8) Summary information (8 blocks) Document summary (8 blocks) BBD is block p..q (where p=e+n+16 and q-p+1 is the number of BBD blocks) Property storage block is q+b...r (normally 1 block) (where b is the number of BBD blocks)
CompoundFile(byte[]) - Constructor for class jxl.read.biff.CompoundFile
Initializes the compound file
CompoundFile(byte[], int, OutputStream) - Constructor for class jxl.write.biff.CompoundFile
Constructor
CONCAT - Static variable in class jxl.biff.formula.Token
 
Concatenate - class jxl.biff.formula.Concatenate.
A cell reference in a formula
CONCATENATE - Static variable in class jxl.biff.formula.Function
 
Concatenate() - Constructor for class jxl.biff.formula.Concatenate
Constructor
CONFIDENCE - Static variable in class jxl.biff.formula.Function
 
Config - class jxl.biff.Config.
Class which contains the available system properties which can be enabled/disabled to allow performance enhancements to JExcelApi
Config() - Constructor for class jxl.biff.Config
 
contents - Variable in class jxl.write.biff.HyperlinkRecord
The cell contents of the cell which activate this hyperlink.
contents - Variable in class jxl.write.biff.LabelRecord
The string
continuationBreaks - Variable in class jxl.read.biff.SSTRecord
The array of continuation breaks
CONTINUE - Static variable in class jxl.biff.Type
 
copied - Variable in class jxl.biff.XFRecord
Flag to indicate whether this cell was copied.
copy(Sheet) - Method in class jxl.write.biff.WritableSheetImpl
Copies the specified sheet, row by row and cell by cell
copy(Workbook) - Method in class jxl.write.WritableWorkbook
Deprecated. Copying now occurs implicitly as part of the overloaded factory method Workbook.createWorkbood
copy(WritableSheet) - Method in class jxl.write.biff.WritableSheetImpl
Copies the specified sheet, row by row and cell by cell
copyCells(Sheet) - Method in class jxl.write.biff.WritableSheetImpl
Copies the cell contents from the specified sheet into this one
copySheet(int, String, int) - Method in class jxl.write.WritableWorkbook
Copies the specified sheet and places it at the index specified by the parameter
copySheet(int, String, int) - Method in class jxl.write.biff.WritableWorkbookImpl
Copies the specified sheet and places it at the index specified by the parameter
copySheet(String, String, int) - Method in class jxl.write.WritableWorkbook
Copies the specified sheet and places it at the index specified by the parameter
copySheet(String, String, int) - Method in class jxl.write.biff.WritableWorkbookImpl
Copies the specified sheet and places it at the index specified by the parameter
copyWorkbook(Workbook) - Method in class jxl.write.biff.WritableWorkbookImpl
Produces a writable copy of the workbook passed in by creating copies of each sheet in the specified workbook and adding them to its own record
CORREL - Static variable in class jxl.biff.formula.Function
 
COS - Static variable in class jxl.biff.formula.Function
 
COSH - Static variable in class jxl.biff.formula.Function
 
COUNT - Static variable in class jxl.biff.formula.Function
 
COUNTA - Static variable in class jxl.biff.formula.Function
 
COUNTBLANK - Static variable in class jxl.biff.formula.Function
 
COUNTIF - Static variable in class jxl.biff.formula.Function
 
COUNTRY - Static variable in class jxl.biff.Type
 
CountryRecord - class jxl.write.biff.CountryRecord.
Record containing the localization information
CountryRecord() - Constructor for class jxl.write.biff.CountryRecord
Constructor
COVAR - Static variable in class jxl.biff.formula.Function
 
createContinueRecord(String, int, File) - Method in class jxl.write.biff.SharedStrings
Creates and returns a continue record using the left over bits and pieces
createSheet(String, int) - Method in class jxl.write.WritableWorkbook
Creates, and returns a worksheet at the specified position with the specified name If the index specified is less than or equal to zero, the new sheet is created at the beginning of the workbook.
createSheet(String, int) - Method in class jxl.write.biff.WritableWorkbookImpl
Creates a new sheet within the workbook, at the specified position.
createWorkbook(File) - Static method in class jxl.Workbook
Creates a writable workbook with the given file name
createWorkbook(File, Workbook) - Static method in class jxl.Workbook
Creates a writable workbook with the given filename as a copy of the workbook passed in.
createWorkbook(File, WorkbookSettings) - Static method in class jxl.Workbook
Creates a writable workbook with the given file name
createWorkbook(File, Workbook, WorkbookSettings) - Static method in class jxl.Workbook
Creates a writable workbook with the given filename as a copy of the workbook passed in.
createWorkbook(OutputStream) - Static method in class jxl.Workbook
Creates a writable workbook.
createWorkbook(OutputStream, Workbook) - Static method in class jxl.Workbook
Creates a writable workbook as a copy of the workbook passed in.
createWorkbook(OutputStream, WorkbookSettings) - Static method in class jxl.Workbook
Creates a writable workbook.
createWorkbook(OutputStream, Workbook, WorkbookSettings) - Static method in class jxl.Workbook
Creates a writable workbook as a copy of the workbook passed in.
CRITBINOM - Static variable in class jxl.biff.formula.Function
 
CSV - class jxl.demo.CSV.
Simple demo class which uses the api to present the contents of an excel 97 spreadsheet as comma separated values, using a workbook and output stream of your choice
CSV(Workbook, OutputStream, String, boolean) - Constructor for class jxl.demo.CSV
Constructor
CSVFormat - Static variable in class jxl.demo.Demo
 
customFormatStartIndex - Static variable in class jxl.biff.FormattingRecords
The start index number for custom format records

D

DARK_BLUE - Static variable in class jxl.format.Colour
 
DARK_RED - Static variable in class jxl.format.Colour
 
DASH_DOT - Static variable in class jxl.format.BorderLineStyle
 
DASH_DOT_DOT - Static variable in class jxl.format.BorderLineStyle
 
DASHED - Static variable in class jxl.format.BorderLineStyle
 
data - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The data that created this set
data - Variable in class jxl.biff.FormatRecord
The raw data
data - Variable in class jxl.read.biff.BooleanFormulaRecord
The raw data
data - Variable in class jxl.read.biff.ColumnInfoRecord
The raw data
data - Variable in class jxl.read.biff.SetupRecord
The raw data
data - Variable in class jxl.read.biff.CompoundFile
The original OLE stream, organized into blocks, which can appear at any physical location in the file
data - Variable in class jxl.read.biff.NumberFormulaRecord
The raw data
data - Variable in class jxl.read.biff.StringFormulaRecord
The raw data
data - Variable in class jxl.read.biff.Record
The raw data within this record
data - Variable in class jxl.read.biff.DateFormulaRecord
The raw data
data - Variable in class jxl.read.biff.ErrorFormulaRecord
The raw data
data - Variable in class jxl.read.biff.File
The data from the excel 97 file
data - Variable in class jxl.write.biff.HyperlinkRecord
The data for this hyperlink
data - Variable in class jxl.write.biff.BookboolRecord
The binary data to write out
data - Variable in class jxl.write.biff.PrintHeadersRecord
The binary data
data - Variable in class jxl.write.biff.SSTRecord
The binary data
data - Variable in class jxl.write.biff.TabIdRecord
The binary data
data - Variable in class jxl.write.biff.NineteenFourRecord
The binary data for output to file
data - Variable in class jxl.write.biff.DeltaRecord
The binary data
data - Variable in class jxl.write.biff.SetupRecord
The binary data for output to file
data - Variable in class jxl.write.biff.BackupRecord
The data array
data - Variable in class jxl.write.biff.BOFRecord
The data to write to the file
data - Variable in class jxl.write.biff.CodepageRecord
The binary data
data - Variable in class jxl.write.biff.ExternalSheetRecord
The underlying external sheet data
data - Variable in class jxl.write.biff.CalcCountRecord
The binary data to write to the output file
data - Variable in class jxl.write.biff.BoundsheetRecord
The data to write to the output file
data - Variable in class jxl.write.biff.CountryRecord
The binary data
data - Variable in class jxl.write.biff.Window2Record
The binary data for output to file
data - Variable in class jxl.write.biff.Prot4RevRecord
The binary data
data - Variable in class jxl.write.biff.WorkspaceInformationRecord
The binary data
data - Variable in class jxl.write.biff.RowRecord
The binary data
data - Variable in class jxl.write.biff.RefreshAllRecord
The binary data
data - Variable in class jxl.write.biff.GuttersRecord
The binary data
data - Variable in class jxl.write.biff.VerticalCentreRecord
The binary data for output to file
data - Variable in class jxl.write.biff.PasswordRecord
The binary data
data - Variable in class jxl.write.biff.DefaultColumnWidth
The binary data
data - Variable in class jxl.write.biff.WriteAccessRecord
The data to output to file
data - Variable in class jxl.write.biff.SSTContinueRecord
The binary data
data - Variable in class jxl.write.biff.WindowProtectRecord
The binary data
data - Variable in class jxl.write.biff.MMSRecord
The binary data
data - Variable in class jxl.write.biff.PrecisionRecord
The binary data
data - Variable in class jxl.write.biff.IterationRecord
The binary data
data - Variable in class jxl.write.biff.NameRecord
The binary data for output to file
data - Variable in class jxl.write.biff.DSFRecord
The data to be written to the binary file
data - Variable in class jxl.write.biff.File
The data from the excel 97 file
data - Variable in class jxl.write.biff.ColumnInfoRecord
The binary data
data - Variable in class jxl.write.biff.GridSetRecord
The binary data
data - Variable in class jxl.write.biff.MsoDrawingGroupRecord
The underlying external sheet data
data - Variable in class jxl.write.biff.IndexRecord
The binary data
data - Variable in class jxl.write.biff.UsesElfsRecord
The binary data for output to file
data - Variable in class jxl.write.biff.HeaderRecord
The binary data
data - Variable in class jxl.write.biff.FooterRecord
The binary data
data - Variable in class jxl.write.biff.FunctionGroupCountRecord
The binary data
data - Variable in class jxl.write.biff.Prot4RevPassRecord
The binary data
data - Variable in class jxl.write.biff.DefaultRowHeightRecord
The binary data
data - Variable in class jxl.write.biff.SupbookRecord
The data to be written to the binary file
data - Variable in class jxl.write.biff.HideobjRecord
The binary data
data - Variable in class jxl.write.biff.DimensionRecord
The binary data
data - Variable in class jxl.write.biff.SaveRecalcRecord
The binary data for output to file
data - Variable in class jxl.write.biff.PrintGridLinesRecord
The binary data
data - Variable in class jxl.write.biff.HorizontalCentreRecord
The binary data
data - Variable in class jxl.write.biff.Window1Record
The binary data
data - Variable in class jxl.write.biff.SelectionRecord
The binaryd data
data - Variable in class jxl.write.biff.ProtectRecord
The binary data
dataPos - Variable in class jxl.read.biff.Record
A pointer to the beginning of the actual data
dataPos - Variable in class jxl.write.biff.IndexRecord
The position of the current 'pointer' within the byte array
date - Variable in class jxl.biff.XFRecord
Indicates whether this is a date formatting record
date - Variable in class jxl.biff.FormatRecord
Indicates whether this is a date formatting record
date - Variable in class jxl.read.biff.DateRecord
The date represented within this cell
date - Variable in class jxl.write.biff.DateRecord
The java representation of the date
DATE - Static variable in class jxl.CellType
 
DATE - Static variable in class jxl.biff.formula.Function
 
DateCell - interface jxl.DateCell.
A date cell
dateFormat - Variable in class jxl.biff.XFRecord
The date format for this record.
dateFormat - Static variable in class jxl.read.biff.DateRecord
 
DateFormat - class jxl.write.DateFormat.
A custom user defined number format which may be instantiated within user applications in order to present date and time values in the appropriate format.
DateFormat(String) - Constructor for class jxl.write.DateFormat
Constructor.
DateFormatRecord - class jxl.write.biff.DateFormatRecord.
A class which contains a date format
DateFormatRecord(String) - Constructor for class jxl.write.biff.DateFormatRecord
Constructor
dateFormats - Static variable in class jxl.biff.XFRecord
 
DateFormats - class jxl.write.DateFormats.
Static class which contains Excels predefined Date formats
DateFormats.BuiltInFormat - class jxl.write.DateFormats.BuiltInFormat.
Inner class which holds the format index
DateFormats.BuiltInFormat(int, String) - Constructor for class jxl.write.DateFormats.BuiltInFormat
Constructor
DateFormats() - Constructor for class jxl.write.DateFormats
 
DateFormulaRecord - class jxl.read.biff.DateFormulaRecord.
A date formula's last calculated value
DateFormulaRecord(NumberFormulaRecord, FormattingRecords, ExternalSheet, boolean, SheetImpl) - Constructor for class jxl.read.biff.DateFormulaRecord
Constructs this object from the raw data
dateRecord - Variable in class jxl.read.biff.SharedDateFormulaRecord
Re-use the date record to handle all the formatting information and date calculations
DateRecord - class jxl.read.biff.DateRecord.
A date which is stored in the cell
DateRecord - class jxl.write.biff.DateRecord.
A date stored in the database
DateRecord.GMTDate - class jxl.write.biff.DateRecord.GMTDate.
Class definition for a dummy variable
DateRecord.GMTDate() - Constructor for class jxl.write.biff.DateRecord.GMTDate
 
DateRecord(DateCell) - Constructor for class jxl.write.biff.DateRecord
Constructor invoked when copying a readable spreadsheet
DateRecord(int, int, Date) - Constructor for class jxl.write.biff.DateRecord
Constructor invoked by the user API
DateRecord(int, int, Date, CellFormat) - Constructor for class jxl.write.biff.DateRecord
Constructor invoked from the user API
DateRecord(int, int, Date, CellFormat, boolean) - Constructor for class jxl.write.biff.DateRecord
Constructor invoked from the API
DateRecord(int, int, Date, CellFormat, DateRecord.GMTDate) - Constructor for class jxl.write.biff.DateRecord
Constructor invoked from the user API
DateRecord(int, int, Date, DateRecord.GMTDate) - Constructor for class jxl.write.biff.DateRecord
Constructor invoked by the user API
DateRecord(NumberCell, int, FormattingRecords, boolean, SheetImpl) - Constructor for class jxl.read.biff.DateRecord
Constructs this object from the raw data
dateStrings - Static variable in class jxl.biff.FormatRecord
 
DateTime - class jxl.write.DateTime.
A Date which may be created on the fly by a user application and added to a spreadsheet NOTE: By default, all dates will have local timezone information added to their UTC value.
DateTime(DateCell) - Constructor for class jxl.write.DateTime
A constructor called by the worksheet when creating a writable version of a spreadsheet that has been read in
DateTime(int, int, Date) - Constructor for class jxl.write.DateTime
Constructor
DateTime(int, int, Date, CellFormat) - Constructor for class jxl.write.DateTime
Constructor which takes the format for this cell
DateTime(int, int, Date, CellFormat, boolean) - Constructor for class jxl.write.DateTime
Constructor which takes the format for the cell and an indicator as to whether this cell is a full date time or purely just a time eg.
DateTime(int, int, Date, CellFormat, DateRecord.GMTDate) - Constructor for class jxl.write.DateTime
Constructor, which adjusts the specified date to take timezone considerations into account
DateTime(int, int, Date, DateRecord.GMTDate) - Constructor for class jxl.write.DateTime
Constructor, which adjusts the specified date to take timezone considerations into account
DATEVALUE - Static variable in class jxl.biff.formula.Function
 
DAVERAGE - Static variable in class jxl.biff.formula.Function
 
DAY - Static variable in class jxl.biff.formula.Function
 
DAYS360 - Static variable in class jxl.biff.formula.Function
 
DBCELL - Static variable in class jxl.biff.Type
 
DBCellRecord - class jxl.write.biff.DBCellRecord.
Indexes the first row record of the block and each individual cell.
DBCellRecord(int) - Constructor for class jxl.write.biff.DBCellRecord
Constructor
DCOUNT - Static variable in class jxl.biff.formula.Function
 
DCOUNTA - Static variable in class jxl.biff.formula.Function
 
DDB - Static variable in class jxl.biff.formula.Function
 
decrementColumn() - Method in class jxl.write.biff.CellValue
Decrements the column of this cell by one.
decrementColumn() - Method in class jxl.write.biff.ColumnInfoRecord
Decrements the column.
decrementRow() - Method in class jxl.write.biff.CellValue
Decrements the row of this cell by one.
decrementRow() - Method in class jxl.write.biff.RowRecord
Decrements the row of this cell by one.
DEFAULT - Static variable in class jxl.write.NumberFormats
The default format.
DEFAULT - Static variable in class jxl.write.DateFormats
The default format.
DEFAULT_BACKGROUND - Static variable in class jxl.format.Colour
 
DEFAULT_POINT_SIZE - Static variable in class jxl.write.WritableFont
The default point size for all Fonts
defaultArrayGrowSize - Static variable in class jxl.WorkbookSettings
 
DefaultColumnWidth - class jxl.write.biff.DefaultColumnWidth.
The default column width for a workbook
DefaultColumnWidth(int) - Constructor for class jxl.write.biff.DefaultColumnWidth
Constructor
defaultDateFormat - Static variable in class jxl.write.biff.DateRecord
This is package protected so that the worksheet might detect whether or not to override it with the column cell format
defaultFooterMargin - Static variable in class jxl.SheetSettings
 
defaultFormat - Static variable in class jxl.read.biff.NumberValue
The format in which to return this number as a string
defaultFormat - Static variable in class jxl.read.biff.NumberRecord
The formatter to convert the value into a string
defaultFormat - Static variable in class jxl.read.biff.NumberFormulaRecord
The string format for the double value
defaultFormat - Static variable in class jxl.read.biff.RKRecord
The formatter to convert the value into a string
defaultFormat - Static variable in class jxl.read.biff.SharedNumberFormulaRecord
The string format for the double value
defaultHeaderMargin - Static variable in class jxl.SheetSettings
 
defaultHeightIndicator - Static variable in class jxl.read.biff.RowRecord
Indicates that the row is default height
defaultHeightIndicator - Static variable in class jxl.write.biff.RowRecord
Indicates that the row is default height
defaultHeightMargin - Static variable in class jxl.SheetSettings
 
defaultInitialFileSize - Static variable in class jxl.WorkbookSettings
 
defaultOrientation - Static variable in class jxl.SheetSettings
 
defaultPaperSize - Static variable in class jxl.SheetSettings
 
defaultPrintResolution - Static variable in class jxl.SheetSettings
 
DEFAULTROWHEIGHT - Static variable in class jxl.biff.Type
 
DefaultRowHeightRecord - class jxl.write.biff.DefaultRowHeightRecord.
The default row height for cells in the workbook
DefaultRowHeightRecord() - Constructor for class jxl.write.biff.DefaultRowHeightRecord
Constructor
defaultWidthMargin - Static variable in class jxl.SheetSettings
 
DEFCOLWIDTH - Static variable in class jxl.biff.Type
 
DEGREES - Static variable in class jxl.biff.formula.Function
 
DELTA - Static variable in class jxl.biff.Type
 
DeltaRecord - class jxl.write.biff.DeltaRecord.
Record which stores the maximum change value from the Options dialog
DeltaRecord(double) - Constructor for class jxl.write.biff.DeltaRecord
Constructor
Demo - class jxl.demo.Demo.
The main demo class which interprets the command line switches in order to determine how to call the demo programs The demo program uses stdout as its default output stream
Demo() - Constructor for class jxl.demo.Demo
 
description - Variable in class jxl.CellType
The text description of this cell type
DEVSQ - Static variable in class jxl.biff.formula.Function
 
DIMENSION - Static variable in class jxl.biff.Type
 
DimensionRecord - class jxl.read.biff.DimensionRecord.
Contains the cell dimensions of this worksheet
DimensionRecord - class jxl.write.biff.DimensionRecord.
Record which contains the bounds of the sheet
DimensionRecord.Biff7 - class jxl.read.biff.DimensionRecord.Biff7.
Dummy indicators for overloading the constructor
DimensionRecord.Biff7() - Constructor for class jxl.read.biff.DimensionRecord.Biff7
 
DimensionRecord(int, int) - Constructor for class jxl.write.biff.DimensionRecord
Constructor
DimensionRecord(Record) - Constructor for class jxl.read.biff.DimensionRecord
Constructs the dimensions from the raw data
DimensionRecord(Record, DimensionRecord.Biff7) - Constructor for class jxl.read.biff.DimensionRecord
Constructs the dimensions from the raw data
directory - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The directory for this property set
DIRECTORY_POS - Static variable in class jxl.biff.BaseCompoundFile
 
display() - Method in class jxl.demo.WriteAccess
Dumps out the contents of the excel file
DisplayFormat - interface jxl.biff.DisplayFormat.
The interface implemented by the various number and date format styles.
displayHelp() - Static method in class jxl.demo.Demo
Displays the acceptable command line arguments
Divide - class jxl.biff.formula.Divide.
A cell reference in a formula
DIVIDE - Static variable in class jxl.biff.formula.Token
 
Divide() - Constructor for class jxl.biff.formula.Divide
Constructor
DMAX - Static variable in class jxl.biff.formula.Function
 
DMIN - Static variable in class jxl.biff.formula.Function
 
DOLLAR - Static variable in class jxl.biff.formula.Function
 
DOTTED - Static variable in class jxl.format.BorderLineStyle
 
DOUBLE - Static variable in class jxl.biff.formula.Token
 
DOUBLE - Static variable in class jxl.format.BorderLineStyle
 
DOUBLE - Static variable in class jxl.format.UnderlineStyle
 
DOUBLE - Static variable in class jxl.write.Font
Deprecated.  
DOUBLE_ACCOUNTING - Static variable in class jxl.format.UnderlineStyle
 
DOUBLE_ACCOUNTING - Static variable in class jxl.write.Font
Deprecated.  
DoubleHelper - class jxl.biff.DoubleHelper.
Class to help handle doubles
DoubleHelper() - Constructor for class jxl.biff.DoubleHelper
 
DoubleValue - class jxl.biff.formula.DoubleValue.
A cell reference in a formula
DoubleValue() - Constructor for class jxl.biff.formula.DoubleValue
Constructor
DoubleValue(String) - Constructor for class jxl.biff.formula.DoubleValue
Constructor for a double value when reading from a string
DPRODUCT - Static variable in class jxl.biff.formula.Function
 
DSF - Static variable in class jxl.biff.Type
 
DSFRecord - class jxl.write.biff.DSFRecord.
Stores a flag which indicates whether the file is a double stream file.
DSFRecord() - Constructor for class jxl.write.biff.DSFRecord
Constructor
DSTDEV - Static variable in class jxl.biff.formula.Function
 
DSTDEVP - Static variable in class jxl.biff.formula.Function
 
DSUM - Static variable in class jxl.biff.formula.Function
 
dump() - Method in class jxl.demo.BiffDump
Dumps out the contents of the excel file
DVAR - Static variable in class jxl.biff.formula.Function
 
DVARP - Static variable in class jxl.biff.formula.Function
 

E

EMPTY - Static variable in class jxl.CellType
 
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
encoding - Variable in class jxl.demo.XML
The encoding to write
endColumn - Variable in class jxl.read.biff.ColumnInfoRecord
The end column for which to apply the format information
endpos - Variable in class jxl.biff.chart.Chart
The start pos of the chart bof stream in the data file
EOF - Static variable in class jxl.biff.Type
 
EOFRecord - class jxl.write.biff.EOFRecord.
Record which marks the end of the current stream
EOFRecord() - Constructor for class jxl.write.biff.EOFRecord
Constructor
Equal - class jxl.biff.formula.Equal.
A cell reference in a formula
EQUAL - Static variable in class jxl.biff.formula.Token
 
Equal() - Constructor for class jxl.biff.formula.Equal
Constructor
equals(Object) - Method in class jxl.biff.SheetRangeImpl
Standard equals method
equals(Object) - Method in class jxl.biff.XFRecord
Equals method.
equals(Object) - Method in class jxl.biff.Type
Standard equals method
equals(Object) - Method in class jxl.write.biff.WritableSheetImpl.ColumnInfoComparator
Equals method
error - Variable in class jxl.read.biff.BooleanRecord
Indicates whether this cell contains an error or a boolean
ERROR - Static variable in class jxl.CellType
 
ERROR - Static variable in class jxl.biff.formula.Function
 
ErrorCell - interface jxl.ErrorCell.
This type represents a cell which contains an error.
errorCode - Variable in class jxl.read.biff.ErrorRecord
The error code if this cell evaluates to an error, otherwise zer0
errorCode - Variable in class jxl.read.biff.ErrorFormulaRecord
The error code of this cell
ErrorFormulaCell - interface jxl.ErrorFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
ErrorFormulaRecord - class jxl.read.biff.ErrorFormulaRecord.
An error resulting from the calculation of a formula
ErrorFormulaRecord(Record, FormattingRecords, ExternalSheet, SheetImpl) - Constructor for class jxl.read.biff.ErrorFormulaRecord
Constructs this object from the raw data
ErrorRecord - class jxl.read.biff.ErrorRecord.
A cell containing an error code.
ErrorRecord(Record, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.ErrorRecord
Constructs this object
EVEN - Static variable in class jxl.biff.formula.Function
 
EXACT - Static variable in class jxl.biff.formula.Function
 
excelData - Variable in class jxl.write.biff.CompoundFile
The organized biff records which form the actual excel data
excelDataBlocks - Variable in class jxl.write.biff.CompoundFile
The number of blocks it takes to store the excel data
excelDataStartBlock - Variable in class jxl.write.biff.CompoundFile
The start block of the excel data
excelFile - Variable in class jxl.read.biff.SheetImpl
The excel file
excelFile - Variable in class jxl.read.biff.WorkbookParser
The excel file
excelFile - Variable in class jxl.read.biff.SheetReader
The excel file
excelFileNotFound - Static variable in class jxl.read.biff.BiffException
 
excelFileTooBig - Static variable in class jxl.read.biff.BiffException
 
excelFormat - Variable in class jxl.biff.XFRecord
The excel format for this record.
EXP - Static variable in class jxl.biff.formula.Function
 
expectedGlobals - Static variable in class jxl.read.biff.BiffException
 
EXPONDIST - Static variable in class jxl.biff.formula.Function
 
EXPONENTIAL - Static variable in class jxl.write.NumberFormats
Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00"
ExtendedSSTRecord - class jxl.write.biff.ExtendedSSTRecord.
Indicates an extension to the Shared String Table.
ExtendedSSTRecord() - Constructor for class jxl.write.biff.ExtendedSSTRecord
Constructor
EXTENSION_BLOCK_POS - Static variable in class jxl.biff.BaseCompoundFile
 
extensionBlock - Variable in class jxl.read.biff.CompoundFile
The header extension block
extensionBlock - Variable in class jxl.write.biff.CompoundFile
The extension block for the header
EXTERNAL - Static variable in class jxl.read.biff.SupbookRecord
 
externalLink - Variable in class jxl.write.biff.BookboolRecord
The external link option flag
externalSheet - Variable in class jxl.read.biff.BooleanFormulaRecord
A handle to the class needed to access external sheets
externalSheet - Variable in class jxl.read.biff.NumberFormulaRecord
A handle to the class needed to access external sheets
externalSheet - Variable in class jxl.read.biff.StringFormulaRecord
A handle to the class needed to access external sheets
externalSheet - Variable in class jxl.read.biff.SharedFormulaRecord
A handle to the external sheet
externalSheet - Variable in class jxl.read.biff.BaseSharedFormulaRecord
The external sheet
externalSheet - Variable in class jxl.read.biff.DateFormulaRecord
A handle to the class needed to access external sheets
externalSheet - Variable in class jxl.read.biff.ErrorFormulaRecord
A handle to the class needed to access external sheets
ExternalSheet - interface jxl.biff.formula.ExternalSheet.
Interface which exposes the methods needed by formulas to access external sheet records
ExternalSheetRecord - class jxl.read.biff.ExternalSheetRecord.
An Externsheet record, containing the details of externally references workbooks
ExternalSheetRecord - class jxl.write.biff.ExternalSheetRecord.
An external sheet record, used to maintain integrity when formulas are copied from read databases
ExternalSheetRecord.Biff7 - class jxl.read.biff.ExternalSheetRecord.Biff7.
Dummy indicators for overloading the constructor
ExternalSheetRecord.Biff7() - Constructor for class jxl.read.biff.ExternalSheetRecord.Biff7
 
ExternalSheetRecord.XTI - class jxl.read.biff.ExternalSheetRecord.XTI.
An XTI structure
ExternalSheetRecord.XTI(int, int, int) - Constructor for class jxl.read.biff.ExternalSheetRecord.XTI
 
ExternalSheetRecord(ExternalSheetRecord) - Constructor for class jxl.write.biff.ExternalSheetRecord
Constructor
ExternalSheetRecord(Record) - Constructor for class jxl.read.biff.ExternalSheetRecord
Constructs this object from the raw data
ExternalSheetRecord(Record, ExternalSheetRecord.Biff7) - Constructor for class jxl.read.biff.ExternalSheetRecord
Constructs this object from the raw data in biff 7 format.
externSheet - Variable in class jxl.read.biff.WorkbookParser
The external sheet record.
externSheet - Variable in class jxl.write.biff.WritableWorkbookImpl
The list of external sheets, used by cell references in formulas
EXTERNSHEET - Static variable in class jxl.biff.Type
 
EXTSST - Static variable in class jxl.biff.Type
 

F

FACT - Static variable in class jxl.biff.formula.Function
 
FALSE - Static variable in class jxl.biff.formula.Function
 
FDIST - Static variable in class jxl.biff.formula.Function
 
file - Variable in class jxl.biff.chart.Chart
A handle to the Excel file
file - Variable in class jxl.read.biff.HyperlinkRecord
The local file referred to by this hyperlink
file - Variable in class jxl.read.biff.Record
A handle to the excel 97 file
file - Variable in class jxl.read.biff.BiffRecordReader
 
file - Variable in class jxl.write.biff.HyperlinkRecord
The local file referred to by this hyperlink
File - class jxl.read.biff.File.
File containing the data from the binary stream
File - class jxl.write.biff.File.
A file of excel data to be written out.
File(InputStream, WorkbookSettings) - Constructor for class jxl.read.biff.File
Constructs a file from the input stream
File(OutputStream, WorkbookSettings) - Constructor for class jxl.write.biff.File
Constructor
fileLink - Static variable in class jxl.read.biff.HyperlinkRecord
 
fileLink - Static variable in class jxl.write.biff.HyperlinkRecord
 
filename - Variable in class jxl.demo.Write
The filename
fileName - Variable in class jxl.read.biff.SupbookRecord
The name of the external file
fileName - Variable in class jxl.write.biff.SupbookRecord
The name of the external file
FILEPASS - Static variable in class jxl.biff.Type
 
FILL - Static variable in class jxl.format.Alignment
Data in cells with this alignment will fill the cell
FIND - Static variable in class jxl.biff.formula.Function
 
FINDB - Static variable in class jxl.biff.formula.Function
 
findByName(String) - Method in class jxl.Workbook
Gets the named range from this workbook.
findByName(String) - Method in class jxl.read.biff.WorkbookParser
Gets the named range from this workbook.
findCell(String) - Method in interface jxl.Sheet
Gets the cell whose contents match the string passed in.
findCell(String) - Method in class jxl.read.biff.SheetImpl
Gets the cell whose contents match the string passed in.
findCell(String) - Method in class jxl.write.biff.WritableSheetImpl
Gets the cell whose contents match the string passed in.
findCellByName(String) - Method in class jxl.Workbook
Gets the named cell from this workbook.
findCellByName(String) - Method in class jxl.read.biff.WorkbookParser
Gets the named cell from this workbook.
findLabelCell(String) - Method in interface jxl.Sheet
Gets the cell whose contents match the string passed in.
findLabelCell(String) - Method in class jxl.read.biff.SheetImpl
Gets the cell whose contents match the string passed in.
findLabelCell(String) - Method in class jxl.write.biff.WritableSheetImpl
Gets the cell whose contents match the string passed in.
findTest(Workbook) - Static method in class jxl.demo.Demo
A private method to test the various find functions
FINV - Static variable in class jxl.biff.formula.Function
 
firstCol - Variable in class jxl.read.biff.SharedFormulaRecord
The first column to which this shared formula applies
firstColumn - Variable in class jxl.read.biff.HyperlinkRecord
The first column
firstColumn - Variable in class jxl.write.biff.HyperlinkRecord
The first column
firstRow - Variable in class jxl.read.biff.SharedFormulaRecord
The first row to which this shared formula applies
firstRow - Variable in class jxl.read.biff.HyperlinkRecord
The first row
firstRow - Variable in class jxl.write.biff.HyperlinkRecord
The first row
firstString - Variable in class jxl.write.biff.SSTContinueRecord
The first string is a special case
firstStringLength - Variable in class jxl.write.biff.SSTContinueRecord
The length of the first string
firstTab - Variable in class jxl.read.biff.ExternalSheetRecord.XTI
 
FISHER - Static variable in class jxl.biff.formula.Function
 
FISHERINV - Static variable in class jxl.biff.formula.Function
 
fitHeight - Variable in class jxl.SheetSettings
The number of pages into which this excel sheet is squeezed heightwise
fitHeight - Variable in class jxl.read.biff.SetupRecord
The fit height
fitHeight - Variable in class jxl.write.biff.SetupRecord
The fit height
fitWidth - Variable in class jxl.SheetSettings
The number of pages into which this excel sheet is squeezed widthwise
fitWidth - Variable in class jxl.read.biff.SetupRecord
The fit width
fitWidth - Variable in class jxl.write.biff.SetupRecord
The fit width
FIXED - Static variable in class jxl.biff.formula.Function
 
FLOAT - Static variable in class jxl.write.NumberFormats
Formatting for a float.
FLOOR - Static variable in class jxl.biff.formula.Function
 
FNGROUPCOUNT - Static variable in class jxl.biff.Type
 
font - Variable in class jxl.biff.XFRecord
The font object for this XF record
Font - interface jxl.format.Font.
Interface which exposes the user font display information to the user
Font - class jxl.write.Font.
Deprecated. Renamed to writable font
FONT - Static variable in class jxl.biff.Type
 
Font(WritableFont.FontName) - Constructor for class jxl.write.Font
Deprecated. Use jxl.write.WritableFont
Font(WritableFont.FontName, int) - Constructor for class jxl.write.Font
Deprecated. use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle) - Constructor for class jxl.write.Font
Deprecated. use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean) - Constructor for class jxl.write.Font
Deprecated. use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle) - Constructor for class jxl.write.Font
Deprecated. use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour) - Constructor for class jxl.write.Font
Deprecated. use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour, ScriptStyle) - Constructor for class jxl.write.Font
Deprecated. use jxl.write.WritableFont
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
FontRecord - class jxl.biff.FontRecord.
A record containing the necessary data for the font information
FontRecord.Biff7 - class jxl.biff.FontRecord.Biff7.
Dummy indicators for overloading the constructor
FontRecord.Biff7() - Constructor for class jxl.biff.FontRecord.Biff7
 
FontRecord(Record) - Constructor for class jxl.biff.FontRecord
Constructs this object from the raw data.
FontRecord(Record, FontRecord.Biff7) - Constructor for class jxl.biff.FontRecord
Constructs this object from the raw data.
FontRecord(String, int, int, boolean, int, int, int) - Constructor for class jxl.biff.FontRecord
Constructor, used when creating a new font for writing out.
fonts - Variable in class jxl.biff.FormattingRecords
A handle to the available fonts
fonts - Variable in class jxl.biff.Fonts
The list of fonts
fonts - Variable in class jxl.read.biff.WorkbookParser
The fonts used by this workbook
fonts - Variable in class jxl.write.biff.WritableWorkbookImpl
The list of fonts available within this workbook
Fonts - class jxl.biff.Fonts.
A container for the list of fonts used in this workbook
Fonts() - Constructor for class jxl.biff.Fonts
Constructor
footer - Variable in class jxl.read.biff.SheetImpl
The page footer
footer - Variable in class jxl.read.biff.FooterRecord
The footer
footer - Variable in class jxl.read.biff.SheetReader
The page footer
footer - Variable in class jxl.write.biff.SheetWriter
The page footer
footer - Variable in class jxl.write.biff.FooterRecord
The footer string
FOOTER - Static variable in class jxl.biff.Type
 
footerMargin - Variable in class jxl.SheetSettings
The margin allocated for any page footers, in inches
footerMargin - Variable in class jxl.read.biff.SetupRecord
The footer margin
footerMargin - Variable in class jxl.write.biff.SetupRecord
The footer margin
FooterRecord - class jxl.read.biff.FooterRecord.
A workbook page footer record
FooterRecord - class jxl.write.biff.FooterRecord.
Places a string at the bottom of each page when the file is printed.
FooterRecord.Biff7 - class jxl.read.biff.FooterRecord.Biff7.
Dummy indicators for overloading the constructor
FooterRecord.Biff7() - Constructor for class jxl.read.biff.FooterRecord.Biff7
 
FooterRecord(FooterRecord) - Constructor for class jxl.write.biff.FooterRecord
Consructor invoked when copying a spreadsheet
FooterRecord(FooterRecord) - Constructor for class jxl.write.biff.FooterRecord
Consructor invoked when copying a sheets
FooterRecord(Record) - Constructor for class jxl.read.biff.FooterRecord
Constructs this object from the raw data
FooterRecord(Record, FooterRecord.Biff7) - Constructor for class jxl.read.biff.FooterRecord
Constructs this object from the raw data
FooterRecord(String, String, String) - Constructor for class jxl.write.biff.FooterRecord
Consructor
FORECAST - Static variable in class jxl.biff.formula.Function
 
format - Variable in class jxl.biff.XFRecord
The format object for this XF record.
format - Variable in class jxl.biff.FormatRecord
The format object
format - Variable in class jxl.read.biff.DateRecord
The format to use when displaying this cell's contents as a string
format - Variable in class jxl.read.biff.CellValue
The cell format
format - Variable in class jxl.read.biff.NumberValue
The cell format
format - Variable in class jxl.read.biff.NumberRecord
The java equivalent of the excel format
format - Variable in class jxl.read.biff.NumberFormulaRecord
The number format
format - Variable in class jxl.read.biff.RKRecord
The java equivalent of the excel format
format - Variable in class jxl.read.biff.SharedNumberFormulaRecord
The cell format
format - Variable in class jxl.write.biff.CellValue
The format applied to this cell
Format - interface jxl.biff.Format.
The interface implemented by the various number and date format styles.
Format - interface jxl.format.Format.
Exposes the cell formatting information
FORMAT - Static variable in class jxl.biff.Type
 
FORMAT1 - Static variable in class jxl.write.NumberFormats
Equivalent to a DecimalFormat "#,##0;(#,##0)"
FORMAT1 - Static variable in class jxl.write.DateFormats
The default format.
FORMAT10 - Static variable in class jxl.write.NumberFormats
Equivalent to DecimalFormat "##0.0E0"
FORMAT10 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "mm:ss"
FORMAT11 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "H:mm:ss"
FORMAT12 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "mm:ss.S"
FORMAT2 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT1 except deficits are coloured red
FORMAT2 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "d-MMM-yy"
FORMAT3 - Static variable in class jxl.write.NumberFormats
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
FORMAT3 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "d-MMM"
FORMAT4 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT3 except deficits are coloured red
FORMAT4 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "MMM-yy"
FORMAT5 - Static variable in class jxl.write.NumberFormats
Equivalent to DecimalFormat "#,##0;(#,##0)"
FORMAT5 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "h:mm a"
FORMAT6 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT5 except deficits are coloured red
FORMAT6 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "h:mm:ss a"
FORMAT7 - Static variable in class jxl.write.NumberFormats
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
FORMAT7 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "H:mm"
FORMAT8 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT7 except deficits are coloured red
FORMAT8 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "H:mm:ss"
FORMAT9 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT7
FORMAT9 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "M/d/yy H:mm"
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.
formatInitialized - Static variable in class jxl.write.biff.JxlWriteException
 
FormatRecord - class jxl.biff.FormatRecord.
A non-built format record
FormatRecord.BiffType - class jxl.biff.FormatRecord.BiffType.
 
FormatRecord.BiffType() - Constructor for class jxl.biff.FormatRecord.BiffType
 
FormatRecord() - Constructor for class jxl.biff.FormatRecord
Constructor used by writable formats
FormatRecord(Record, FormatRecord.BiffType) - Constructor for class jxl.biff.FormatRecord
Constructs this object from the raw data.
FormatRecord(String, int) - Constructor for class jxl.biff.FormatRecord
Constructor invoked when copying sheets
formatRecords - Variable in class jxl.write.biff.WritableSheetImpl
A handle to workbook format records
formatRecords - Variable in class jxl.write.biff.WritableWorkbookImpl
The list of formats available within this workbook
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
formatString - Variable in class jxl.biff.BuiltInFormat
The excel format string
formatString - Variable in class jxl.biff.FormatRecord
The formatting string
formatString - Variable in class jxl.write.NumberFormats.BuiltInFormat
The format string
formatString - Variable in class jxl.write.DateFormats.BuiltInFormat
The excel format
formattingRecords - Variable in class jxl.biff.XFRecord
A handle to the formatting records.
formattingRecords - Variable in class jxl.read.biff.SheetImpl
A handle to the formatting records
formattingRecords - Variable in class jxl.read.biff.DateRecord
A handle to the formatting records
formattingRecords - Variable in class jxl.read.biff.CellValue
A handle to the formatting records, so that we can retrieve the formatting information
formattingRecords - Variable in class jxl.read.biff.NumberValue
A handle to the formatting records
formattingRecords - Variable in class jxl.read.biff.WorkbookParser
The xf records
formattingRecords - Variable in class jxl.read.biff.MulBlankCell
A handle to the formatting records
formattingRecords - Variable in class jxl.read.biff.SheetReader
A handle to the formatting records
formattingRecords - Variable in class jxl.read.biff.BaseSharedFormulaRecord
A handle to the formatting records
formattingRecords - Variable in class jxl.read.biff.SharedNumberFormulaRecord
A handle to the formatting records
formattingRecords - Variable in class jxl.read.biff.SharedStringFormulaRecord
A handle to the formatting records
formattingRecords - Variable in class jxl.write.biff.CellValue
A handle to the formatting records, used in case we want to change the format of the cell once it has been added to the spreadsheet
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
formula - Variable in class jxl.biff.formula.StringFormulaParser
The formula string passed to this object
formula - Variable in class jxl.read.biff.FormulaRecord
The "real" formula record - will be either a string a or a number
formula - Variable in class jxl.write.biff.ReadFormulaRecord
The underlying formula from the read sheet
Formula - interface jxl.read.biff.Formula.
Interface which is used for copying formulas from a read only to a writable spreadsheet
Formula - class jxl.write.Formula.
A cell, created by user applications, which contains a numerical value
FORMULA - Static variable in class jxl.biff.Type
 
FORMULA_ERROR - Static variable in class jxl.CellType
 
Formula(int, int, String) - Constructor for class jxl.write.Formula
Constructs the formula
Formula(int, int, String, CellFormat) - Constructor for class jxl.write.Formula
Constructs a formula
FORMULA2 - Static variable in class jxl.biff.Type
 
formulaBytes - Variable in class jxl.write.biff.FormulaRecord
The parsed formula bytes
FormulaCell - interface jxl.FormulaCell.
Interface for formulas which allow clients to read the Excel formula
FormulaData - interface jxl.biff.FormulaData.
Interface which is used for copying formulas from a read only to a writable spreadsheet
FormulaData - interface jxl.read.biff.FormulaData.
Interface which is used for copying formulas from a read only to a writable spreadsheet
FormulaException - exception jxl.biff.formula.FormulaException.
Exception thrown when parsing a formula
FormulaException.FormulaMessage - class jxl.biff.formula.FormulaException.FormulaMessage.
 
FormulaException.FormulaMessage(String) - Constructor for class jxl.biff.formula.FormulaException.FormulaMessage
Constructs this exception with the specified message
FormulaException(FormulaException.FormulaMessage) - Constructor for class jxl.biff.formula.FormulaException
Constructs this exception with the specified message
FormulaException(FormulaException.FormulaMessage, int) - Constructor for class jxl.biff.formula.FormulaException
Constructs this exception with the specified message
FormulaException(FormulaException.FormulaMessage, String) - Constructor for class jxl.biff.formula.FormulaException
Constructs this exception with the specified message
FormulaParser - class jxl.biff.formula.FormulaParser.
Parses the formula passed in (either as parsed strings or as a string) into a tree of operators and operands
FormulaParser(byte[], Cell, ExternalSheet) - Constructor for class jxl.biff.formula.FormulaParser
Constructor which creates the parse tree out of tokens
FormulaParser(String) - Constructor for class jxl.biff.formula.FormulaParser
Constructor which creates the parse tree out of the string
FormulaRecord - class jxl.read.biff.FormulaRecord.
A formula's last calculated value
FormulaRecord - class jxl.write.biff.FormulaRecord.
A formula record.
FormulaRecord.IgnoreSharedFormula - class jxl.read.biff.FormulaRecord.IgnoreSharedFormula.
Static class for a dummy override, indicating that the formula passed in is not a shared formula
FormulaRecord.IgnoreSharedFormula() - Constructor for class jxl.read.biff.FormulaRecord.IgnoreSharedFormula
 
FormulaRecord(int, int, String) - Constructor for class jxl.write.biff.FormulaRecord
Constructor
FormulaRecord(int, int, String, CellFormat) - Constructor for class jxl.write.biff.FormulaRecord
Constructor
FormulaRecord(Record, File, FormattingRecords, ExternalSheet, FormulaRecord.IgnoreSharedFormula, SheetImpl) - Constructor for class jxl.read.biff.FormulaRecord
Constructs this object from the raw data.
FormulaRecord(Record, File, FormattingRecords, ExternalSheet, SheetImpl) - Constructor for class jxl.read.biff.FormulaRecord
Constructs this object from the raw data.
formulas - Variable in class jxl.read.biff.SharedFormulaRecord
The rest of the comprising this shared formula
Formulas - class jxl.demo.Formulas.
Goes through each cell in the workbook, and if the contents of that cell is a formula, it prints out the last calculated value and the formula string
Formulas(Workbook, OutputStream, String) - Constructor for class jxl.demo.Formulas
Constructor
formulaString - Variable in class jxl.read.biff.BooleanFormulaRecord
The formula as an excel string
formulaString - Variable in class jxl.read.biff.NumberFormulaRecord
The formula as an excel string
formulaString - Variable in class jxl.read.biff.StringFormulaRecord
The formula as an excel string
formulaString - Variable in class jxl.read.biff.BaseSharedFormulaRecord
The formula as an excel string
formulaString - Variable in class jxl.read.biff.DateFormulaRecord
The formula as an excel string
formulaString - Variable in class jxl.read.biff.ErrorFormulaRecord
The formula as an excel string
formulaString - Variable in class jxl.write.biff.FormulaRecord
The parsed formula string
formulaToParse - Variable in class jxl.write.biff.FormulaRecord
The formula to parse
FTEST - Static variable in class jxl.biff.formula.Function
 
function - Variable in class jxl.biff.formula.VariableArgFunction
The function
function - Variable in class jxl.biff.formula.StringFunction
 
function - Variable in class jxl.biff.formula.BuiltInFunction
The function
Function - class jxl.biff.formula.Function.
An enumeration detailing the Excel function codes
FUNCTION - Static variable in class jxl.biff.formula.Token
 
Function(int, String, int) - Constructor for class jxl.biff.formula.Function
Constructor Sets the token value and adds this token to the array of all token
FunctionGroupCountRecord - class jxl.write.biff.FunctionGroupCountRecord.
Stores the number of build in function groups
FunctionGroupCountRecord() - Constructor for class jxl.write.biff.FunctionGroupCountRecord
Constructor
functions - Static variable in class jxl.biff.formula.Function
All available functions
FUNCTIONVARARG - Static variable in class jxl.biff.formula.Token
 
FV - Static variable in class jxl.biff.formula.Function
 

G

GAMMADIST - Static variable in class jxl.biff.formula.Function
 
GAMMAINV - Static variable in class jxl.biff.formula.Function
 
GAMMALN - Static variable in class jxl.biff.formula.Function
 
gcDisabled - Static variable in class jxl.biff.Config
Flag to indicate whether the system hint garbage collection is enabled or not.
GENERAL - Static variable in class jxl.format.Alignment
The standard alignment
GEOMEAN - Static variable in class jxl.biff.formula.Function
 
get(int) - Method in class jxl.write.biff.SharedStrings
Gets the string at the specified index
getAlignment() - Method in class jxl.biff.XFRecord
Gets the horizontal cell alignment
getAlignment() - Method in interface jxl.format.CellFormat
Gets the horizontal cell alignment
getAlignment(int) - Static method in class jxl.format.Alignment
Gets the alignment from the value
getAlignment(int) - Static method in class jxl.format.VerticalAlignment
Gets the alignment from the value
getArrayGrowSize() - Method in class jxl.WorkbookSettings
Accessor for the array grow size property
getBackgroundColour() - Method in class jxl.biff.XFRecord
Gets the background colour used by this cell
getBackgroundColour() - Method in interface jxl.format.CellFormat
Gets the background colour used by this cell
getBigBlockStream(BaseCompoundFile.PropertyStorage) - Method in class jxl.read.biff.CompoundFile
Build up the resultant stream using the big blocks
getBoldWeight() - Method in class jxl.biff.FontRecord
Gets the bold weight for this font
getBoldWeight() - Method in interface jxl.format.Font
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
getBorder(Border) - Method in interface jxl.format.CellFormat
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
getBottomMargin() - Method in class jxl.SheetSettings
Accessor for the bottom margin
getBottomRight() - Method in interface jxl.Range
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
getBottomRight() - Method in class jxl.read.biff.RangeImpl
Gets the cell at the bottom right of this range
getBytes() - Method in class jxl.biff.WritableRecordData
Used when writing out records.
getBytes() - Method in interface jxl.biff.ByteData
Used when writing out records
getBytes() - Method in class jxl.biff.chart.Chart
Gets the entire binary record for the chart as a chunk of binary data
getBytes() - Method in class jxl.biff.formula.ParseItem
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.BinaryOperator
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.Parenthesis
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.Area3d
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.StringParseItem
Gets the token representation of this item in RPN.
getBytes() - Method in class jxl.biff.formula.UnaryOperator
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.FormulaParser
Gets the bytes for the formula.
getBytes() - Method in class jxl.biff.formula.MissingArg
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.VariableArgFunction
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.CellReference3d
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.TokenFormulaParser
Gets the bytes for the formula.
getBytes() - Method in class jxl.biff.formula.SharedFormulaArea
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.IntegerValue
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.DoubleValue
Gets the token representation of this item in RPN
getBytes() - Method in interface jxl.biff.formula.Parser
Gets the bytes for the formula.
getBytes() - Method in class jxl.biff.formula.StringValue
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.BooleanValue
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.Area
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.Attribute
Gets the token representation of this item in RPN.
getBytes() - Method in class jxl.biff.formula.StringFormulaParser
Gets the bytes for the formula
getBytes() - Method in class jxl.biff.formula.CellReference
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.Name
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.SharedFormulaCellReference
Gets the token representation of this item in RPN
getBytes() - Method in class jxl.biff.formula.BuiltInFunction
Gets the token representation of this item in RPN
getBytes(String) - 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
getCell(int) - Method in class jxl.write.biff.RowRecord
Gets the cell which occurs at the specified column value
getCell(int, int) - Method in interface jxl.Sheet
Returns the cell specified at this row and at this column.
getCell(int, int) - Method in class jxl.read.biff.SheetImpl
Returns the cell specified at this row and at this column
getCell(int, int) - Method in class jxl.write.biff.WritableSheetImpl
Returns the cell specified at this row and at this column
getCellFormat() - Method in interface jxl.Cell
Gets the cell format which applies to this cell Note that for cell with a cell type of EMPTY, which has no formatting information, this method will return null.
getCellFormat() - Method in class jxl.biff.EmptyCell
Accessor for the format which is applied to this cell
getCellFormat() - Method in class jxl.read.biff.DateRecord
Gets the CellFormat object for this cell.
getCellFormat() - Method in class jxl.read.biff.CellValue
Gets the CellFormat object for this cell.
getCellFormat() - Method in class jxl.read.biff.NumberValue
Gets the cell format
getCellFormat() - Method in class jxl.read.biff.MulBlankCell
Gets the cell format for this cell
getCellFormat() - Method in class jxl.write.biff.CellValue
API method which gets the format applied to this cell
getCellFormat() - Method in class jxl.write.biff.ColumnInfoRecord
Gets the cell format associated with this column info record
getCellReference(int, int) - Static method in class jxl.biff.CellReferenceHelper
 
getCellReference(int, int, int, ExternalSheet, StringBuffer) - Static method in class jxl.biff.CellReferenceHelper
 
getCellReference(int, int, StringBuffer) - Static method in class jxl.biff.CellReferenceHelper
 
getCells() - Method in class jxl.read.biff.SheetReader
 
getChars(byte[], SSTRecord.ByteArrayHolder, int, SSTRecord.BooleanHolder, int) - Method in class jxl.read.biff.SSTRecord
Gets the chars in the ascii array, taking into account continuation breaks
getCharts() - Method in class jxl.read.biff.SheetImpl
Gets the charts.
getCharts() - Method in class jxl.read.biff.SheetReader
 
getCharts() - Method in class jxl.write.biff.SheetWriter
 
getCharts() - Method in class jxl.write.biff.WritableSheetImpl
Accessor for the charts.
getCode() - Method in class jxl.biff.RecordData
Accessor for the code
getCode() - Method in class jxl.biff.formula.Token
Gets the token code for the specified token
getCode() - Method in class jxl.read.biff.Record
The excel 97 code
getColour() - Method in class jxl.biff.FontRecord
Gets the colour for this font
getColour() - Method in interface jxl.format.Font
Gets the colour for this font
getColour(int) - Static method in class jxl.format.Colour
Gets the colour from the value
getColumn() - Method in interface jxl.Cell
Returns the column number of this cell
getColumn() - Method in interface jxl.Hyperlink
Returns the column number of this cell
getColumn() - Method in class jxl.biff.EmptyCell
Returns the column number of this cell
getColumn() - Method in class jxl.biff.formula.CellReference3d
 
getColumn() - Method in class jxl.biff.formula.CellReference
Accessor for the column
getColumn() - Method in class jxl.biff.formula.SharedFormulaCellReference
 
getColumn() - Method in class jxl.read.biff.DateRecord
Interface method which returns the column number of this cell
getColumn() - Method in class jxl.read.biff.CellValue
Interface method which returns the column number of this cell
getColumn() - Method in class jxl.read.biff.NumberValue
Accessor for the column
getColumn() - Method in class jxl.read.biff.MulBlankCell
Accessor for the column
getColumn() - Method in class jxl.read.biff.HyperlinkRecord
Returns the column number of the top left cell
getColumn() - Method in class jxl.write.biff.CellValue
Returns the column number of this cell
getColumn() - Method in class jxl.write.biff.HyperlinkRecord
Returns the column number of the top left cell
getColumn() - Method in class jxl.write.biff.ColumnInfoRecord
Gets the column this format applies to
getColumn(int) - Method in interface jxl.Sheet
Gets all the cells on the specified column
getColumn(int) - Method in class jxl.read.biff.SheetImpl
Gets all the cells on the specified column.
getColumn(int) - Method in class jxl.write.biff.WritableSheetImpl
Gets all the cells on the specified column
getColumn(String) - Static method in class jxl.biff.CellReferenceHelper
Gets the columnn number of the string cell reference
getColumnInfo(int) - Method in class jxl.read.biff.SheetImpl
Gets the column info record for the specified column.
getColumnInfo(int) - Method in class jxl.write.biff.WritableSheetImpl
Gets the column info record for the specified column
getColumnInfosArray() - Method in class jxl.read.biff.SheetReader
 
getColumns() - Method in interface jxl.Sheet
Returns the number of columns in this sheet
getColumns() - Method in class jxl.read.biff.SheetImpl
Returns the number of columns in this sheet
getColumns() - Method in class jxl.write.biff.WritableSheetImpl
Returns the number of columns in this sheet
getContents() - Method in interface jxl.Cell
Quick and dirty function to return the contents of this cell as a string.
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.read.biff.DateRecord
Gets the cell contents as a string.
getContents() - Method in class jxl.read.biff.BooleanFormulaRecord
Returns the numerical value as a string
getContents() - Method in class jxl.read.biff.ErrorRecord
Returns the numerical value as a string
getContents() - Method in class jxl.read.biff.NumberValue
Accessor for the contents as a string
getContents() - Method in class jxl.read.biff.BlankCell
Returns the contents of this cell as an empty string
getContents() - Method in class jxl.read.biff.NumberRecord
Returns the contents of this cell as a string
getContents() - Method in class jxl.read.biff.BooleanRecord
Returns the numerical value as a string
getContents() - Method in class jxl.read.biff.NumberFormulaRecord
Returns the numerical value as a string
getContents() - Method in class jxl.read.biff.StringFormulaRecord
Interface method which returns the value
getContents() - Method in class jxl.read.biff.MulBlankCell
Accessor for the contents as a string
getContents() - Method in class jxl.read.biff.LabelRecord
Gets the cell contents as a string
getContents() - Method in class jxl.read.biff.RKRecord
Returns the contents of this cell as a string
getContents() - Method in class jxl.read.biff.SharedDateFormulaRecord
Accessor for the contents as a string
getContents() - Method in class jxl.read.biff.FormulaRecord
Returns the numerical value as a string
getContents() - Method in class jxl.read.biff.SharedNumberFormulaRecord
Accessor for the contents as a string
getContents() - Method in class jxl.read.biff.LabelSSTRecord
Gets this cell's contents as a string
getContents() - Method in class jxl.read.biff.SharedStringFormulaRecord
Accessor for the contents as a string
getContents() - Method in class jxl.read.biff.RStringRecord
Gets the cell contents as a string
getContents() - Method in class jxl.read.biff.ErrorFormulaRecord
Returns the numerical value as a string
getContents() - Method in class jxl.write.biff.FormulaRecord
Quick and dirty function to return the contents of this cell as a string.
getContents() - Method in class jxl.write.biff.HyperlinkRecord
Called by the worksheet.
getContents() - Method in class jxl.write.biff.BooleanRecord
Returns the numerical value as a string
getContents() - Method in class jxl.write.biff.NumberRecord
Quick and dirty function to return the contents of this cell as a string.
getContents() - Method in class jxl.write.biff.LabelRecord
Quick and dirty function to return the contents of this cell as a string.
getContents() - Method in class jxl.write.biff.DateRecord
Quick and dirty function to return the contents of this cell as a string.
getContents() - Method in class jxl.write.biff.BlankRecord
Quick and dirty function to return the contents of this cell as a string.
getContents() - Method in class jxl.write.biff.ReadFormulaRecord
Quick and dirty function to return the contents of this cell as a string.
getContinuedString(byte[], SSTRecord.ByteArrayHolder, int, int, SSTRecord.BooleanHolder, int) - Method in class jxl.read.biff.SSTRecord
Gets the rest of the string after a continuation break
getData() - Method in class jxl.biff.WritableRecordData
Abstract method called by the getBytes method.
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.FontRecord
Gets the byte data for writing out
getData() - Method in class jxl.biff.XFRecord
Converts the various fields into binary data.
getData() - Method in class jxl.biff.FormatRecord
Used to get the data when writing out the format record
getData() - Method in class jxl.read.biff.NameRecord
Called when copying a sheet.
getData() - Method in class jxl.read.biff.Record
Gets the data portion of the record
getData() - Method in class jxl.read.biff.MsoDrawingGroupRecord
Expose the protected function to the SheetImpl in this package
getData() - Method in class jxl.read.biff.SupbookRecord
Gets the data - used when copying a spreadsheet
getData() - Method in class jxl.read.biff.ExternalSheetRecord
Used when copying a workbook to access the raw external sheet data
getData() - Method in class jxl.write.biff.CellXFRecord
Retrieves the data to be written to the output file
getData() - Method in class jxl.write.biff.CellValue
Gets the data to write to the output file
getData() - Method in class jxl.write.biff.FormulaRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.HyperlinkRecord
Gets the binary data to be written to the output file
getData() - Method in class jxl.write.biff.BooleanRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.NumberRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.LabelRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.DateRecord
Gets the binary data for writing
getData() - Method in class jxl.write.biff.BookboolRecord
Gets the binary data to write to the output file
getData() - Method in class jxl.write.biff.PrintHeadersRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.SSTRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.DBCellRecord
Gets the binary data for this cell record
getData() - Method in class jxl.write.biff.TabIdRecord
Gets the data for output to file
getData() - Method in class jxl.write.biff.NineteenFourRecord
The binary data for output to file
getData() - Method in class jxl.write.biff.DeltaRecord
Gets the binary data for writing to the output file
getData() - Method in class jxl.write.biff.SetupRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.BackupRecord
Returns the binary data for writing to the output file
getData() - Method in class jxl.write.biff.ExtendedSSTRecord
Gets the binary data to be written out
getData() - Method in class jxl.write.biff.BOFRecord
Gets the data for writing to the output file
getData() - Method in class jxl.write.biff.CodepageRecord
Retrieves the data for output to binary file
getData() - Method in class jxl.write.biff.ExternalSheetRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.CalcCountRecord
Gets the data to write out to the file
getData() - Method in class jxl.write.biff.BoundsheetRecord
Gets the data to write out to the binary file
getData() - Method in class jxl.write.biff.CountryRecord
Retrieves the data to be written to the binary file
getData() - Method in class jxl.write.biff.Window2Record
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.Prot4RevRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.WorkspaceInformationRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.RowRecord
Gets the row data to output to file
getData() - Method in class jxl.write.biff.RefreshAllRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.GuttersRecord
Gets the binary data for output
getData() - Method in class jxl.write.biff.MarginRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.VerticalCentreRecord
Gets the data for output to file
getData() - Method in class jxl.write.biff.PasswordRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.DefaultColumnWidth
Gets the binary data for writing to the stream
getData() - Method in class jxl.write.biff.StringRecord
The binary data to be written out
getData() - Method in class jxl.write.biff.HorizontalPageBreaksRecord
Gets the binary data to write to the output file
getData() - Method in class jxl.write.biff.MergedCellsRecord
Gets the raw data for output to file
getData() - Method in class jxl.write.biff.WriteAccessRecord
Gets the data for output to file
getData() - Method in class jxl.write.biff.MulRKRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.SSTContinueRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.WindowProtectRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.MMSRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.PrecisionRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.IterationRecord
Gets the binary data for output
getData() - Method in class jxl.write.biff.NameRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.CalcModeRecord
Gets the binary to data to write to the output file
getData() - Method in class jxl.write.biff.DSFRecord
The binary data to be written out
getData() - Method in class jxl.write.biff.InterfaceHeaderRecord
Gets the binary data
getData() - Method in class jxl.write.biff.ColumnInfoRecord
Gets the binary data to be written to the output file
getData() - Method in class jxl.write.biff.GridSetRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.MsoDrawingGroupRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.IndexRecord
Gets the binary data for output.
getData() - Method in class jxl.write.biff.EOFRecord
Returns the binary data to be written to the output file
getData() - Method in class jxl.write.biff.UsesElfsRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.HeaderRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.FooterRecord
Gets the binary data to write to the output file
getData() - Method in class jxl.write.biff.FunctionGroupCountRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.ReadFormulaRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.Prot4RevPassRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.DefaultRowHeightRecord
Gets the binary data for writing to the output stream
getData() - Method in class jxl.write.biff.SupbookRecord
The binary data to be written out
getData() - Method in class jxl.write.biff.StyleXFRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.HideobjRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.DimensionRecord
Gets the binary data to be written to the output file
getData() - Method in class jxl.write.biff.SaveRecalcRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.InterfaceEndRecord
Gets the binary data for output
getData() - Method in class jxl.write.biff.PrintGridLinesRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.HorizontalCentreRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.Window1Record
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.SelectionRecord
Gets the binary data
getData() - Method in class jxl.write.biff.RefModeRecord
Gets the binary data for output to file
getData() - Method in class jxl.write.biff.ProtectRecord
Gets the binary data for output to file
getDate() - Method in interface jxl.DateCell
Gets the date contained in this cell
getDate() - Method in class jxl.read.biff.DateRecord
Gets the date
getDate() - Method in class jxl.read.biff.SharedDateFormulaRecord
Gets the date
getDate() - Method in class jxl.write.biff.DateRecord
Gets the date contained in this cell
getDateFormat() - Method in interface jxl.DateCell
Gets the DateFormat used to format the cell.
getDateFormat() - Method in class jxl.biff.XFRecord
Gets the java date format for this format record
getDateFormat() - Method in class jxl.biff.FormatRecord
Gets the java equivalent date format for the formatString
getDateFormat() - Method in class jxl.read.biff.DateRecord
Gets the DateFormat used to format the cell.
getDateFormat() - Method in class jxl.read.biff.SharedDateFormulaRecord
Gets the DateFormat used to format the cell.
getDateFormat() - Method in class jxl.write.biff.DateRecord
Gets the DateFormat used to format the cell.
getDateFormat(int) - Method in class jxl.biff.FormattingRecords
Gets the DateFormat used to format the cell.
getDefaultHeightMargin() - Method in class jxl.SheetSettings
Gets the default margin height
getDefaultWidthMargin() - Method in class jxl.SheetSettings
Gets the default margin width
getDescription() - Method in class jxl.format.Colour
Gets the string description for display purposes
getDescription() - Method in class jxl.format.Border
Gets the description
getDescription() - Method in class jxl.format.BorderLineStyle
Gets the textual description
getDescription() - Method in class jxl.format.UnderlineStyle
Gets the string description for display purposes
getDescription() - Method in class jxl.format.ScriptStyle
Gets the string description for display purposes
getDescription() - Method in class jxl.format.Orientation
Gets the textual description
getDescription() - Method in class jxl.format.Alignment
Gets the string description of this alignment
getDescription() - Method in class jxl.format.Pattern
Gets the textual description
getDescription() - Method in class jxl.format.BoldStyle
Gets the string description of the bold style
getDescription() - Method in class jxl.format.VerticalAlignment
Gets the textual description
getDouble(int) - Static method in class jxl.read.biff.RKHelper
Converts excel's internal RK format into a double value
getEndColumn() - Method in class jxl.read.biff.ColumnInfoRecord
Accessor for the end column of this range
getErrorCode() - Method in interface jxl.ErrorCell
Gets the error code for this cell.
getErrorCode() - Method in class jxl.read.biff.ErrorRecord
Interface method which gets the error code for this cell.
getErrorCode() - Method in class jxl.read.biff.ErrorFormulaRecord
Interface method which gets the error code for this cell.
getExternalSheet() - Method in class jxl.read.biff.BaseSharedFormulaRecord
Access for the external sheet
getExternalSheetIndex(int) - Method in class jxl.read.biff.WorkbookParser
Package protected function which gets the real internal sheet index based upon the external sheet reference.
getExternalSheetName(int) - Method in interface jxl.biff.formula.ExternalSheet
Gets the name of the external sheet specified by the index
getExternalSheetName(int) - Method in class jxl.read.biff.WorkbookParser
Gets the name of the external sheet specified by the index
getExternalSheetRecord() - Method in class jxl.read.biff.WorkbookParser
Accessor for the externSheet, used by the WritableWorkbook when creating a copy of this
getFile() - Method in interface jxl.Hyperlink
Returns the local file eferenced by this Hyperlink
getFile() - Method in class jxl.read.biff.HyperlinkRecord
Returns the local file eferenced by this Hyperlink
getFile() - Method in class jxl.write.biff.HyperlinkRecord
Returns the local file eferenced by this Hyperlink
getFileData(byte[]) - Method in class jxl.write.biff.HyperlinkRecord
Gets the hyperlink stream specific to a local file link
getFileName() - Method in class jxl.read.biff.SupbookRecord
Gets the name of the external file
getFirstColumn() - Method in class jxl.biff.formula.Area3d
 
getFirstColumn() - Method in class jxl.biff.formula.SharedFormulaArea
 
getFirstColumn() - Method in class jxl.biff.formula.Area
 
getFirstColumn() - Method in class jxl.read.biff.NameRecord.NameRange
 
getFirstColumn() - Method in class jxl.read.biff.MulRKRecord
The first column containing the rk numbers
getFirstColumn() - Method in class jxl.read.biff.MulBlankRecord
The first column containing the blank numbers
getFirstRow() - Method in class jxl.biff.formula.Area3d
 
getFirstRow() - Method in class jxl.biff.formula.SharedFormulaArea
 
getFirstRow() - Method in class jxl.biff.formula.Area
 
getFirstRow() - Method in class jxl.read.biff.NameRecord.NameRange
 
getFirstSheet() - Method in class jxl.read.biff.NameRecord.NameRange
 
getFirstSheetIndex() - Method in interface jxl.Range
Gets the index of the first sheet in the range
getFirstSheetIndex() - Method in class jxl.biff.SheetRangeImpl
Not supported.
getFirstSheetIndex() - Method in class jxl.read.biff.RangeImpl
Gets the index of the first sheet in the range
getFirstTabIndex(int) - Method in class jxl.read.biff.ExternalSheetRecord
Gets the first tab index for the specified external sheet
getFitHeight() - Method in class jxl.SheetSettings
Accessor for the fit height
getFitHeight() - Method in class jxl.read.biff.SetupRecord
Accessor for the fit height.
getFitWidth() - Method in class jxl.SheetSettings
Accessor for the fit width
getFitWidth() - Method in class jxl.read.biff.SetupRecord
Accessor for the fit width.
getFont() - Method in class jxl.biff.XFRecord
Gets the font used by this format
getFont() - Method in interface jxl.format.CellFormat
Gets the font information used by this format
getFont(int) - Method in class jxl.biff.Fonts
Used by FormattingRecord for retrieving the fonts for the hardcoded styles
getFontIndex() - Method in class jxl.biff.FontRecord
Accessor for the font index
getFonts() - Method in class jxl.biff.FormattingRecords
Accessor for the fonts used by this workbook
getFonts() - Method in class jxl.read.biff.WorkbookParser
Accessor for the fonts, used by the WritableWorkbook when creating a copy of this
getFooter() - Method in class jxl.read.biff.SheetImpl
Gets the footer.
getFooter() - Method in class jxl.read.biff.FooterRecord
Gets the footer string
getFooter() - Method in class jxl.read.biff.SheetReader
 
getFooter() - Method in class jxl.write.biff.SheetWriter
Gets the footer.
getFooter() - Method in class jxl.write.biff.WritableSheetImpl
Gets the footer.
getFooterMargin() - Method in class jxl.SheetSettings
Accessor for the footer margin
getFooterMargin() - Method in class jxl.read.biff.SetupRecord
Accessor for the footer.
getFormat() - Method in class jxl.biff.XFRecord
Gets the format used by this format
getFormat() - Method in interface jxl.format.CellFormat
Gets the format used by this format
getFormatIndex() - Method in interface jxl.biff.Format
Accessor for the index style of this format
getFormatIndex() - Method in class jxl.biff.FormatRecord
Gets the format index of this record
getFormatIndex() - Method in interface jxl.biff.DisplayFormat
Accessor for the index style of this format
getFormatIndex() - Method in class jxl.write.NumberFormats.BuiltInFormat
Accessor for the format index
getFormatIndex() - Method in class jxl.write.DateFormats.BuiltInFormat
Gets the format index
getFormatRecord() - Method in class jxl.biff.XFRecord
Gets the lookup number of the format record
getFormatRecord(int) - Method in class jxl.biff.FormattingRecords
Gets 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.
getFormatString() - Method in interface jxl.format.Format
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.write.NumberFormats.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.write.DateFormats.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
getFormattingRecords() - Method in class jxl.read.biff.WorkbookParser
Accessor for the formattingRecords, used by the WritableWorkbook when creating a copy of this
getFormula() - Method in interface jxl.FormulaCell
Gets the formula as a string
getFormula() - Method in class jxl.biff.formula.FormulaParser
Gets the formula as a string
getFormula() - Method in class jxl.biff.formula.TokenFormulaParser
Gets the formula as a string
getFormula() - Method in interface jxl.biff.formula.Parser
Gets the string version of the formula
getFormula() - Method in class jxl.biff.formula.StringFormulaParser
Gets the formula as a string.
getFormula() - Method in class jxl.read.biff.BooleanFormulaRecord
Gets the formula as an excel string
getFormula() - Method in class jxl.read.biff.NumberFormulaRecord
Gets the formula as an excel string
getFormula() - Method in class jxl.read.biff.StringFormulaRecord
Gets the formula as an excel string
getFormula() - Method in class jxl.read.biff.BaseSharedFormulaRecord
Gets the formula as an excel string
getFormula() - Method in class jxl.read.biff.DateFormulaRecord
Gets the formula as an excel string
getFormula() - Method in class jxl.read.biff.FormulaRecord
Gets the "real" formula
getFormula() - Method in class jxl.read.biff.ErrorFormulaRecord
Gets the formula as an excel string
getFormulaData() - Method in interface jxl.biff.FormulaData
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.read.biff.BooleanFormulaRecord
Gets the raw bytes for the formula.
getFormulaData() - Method in interface jxl.read.biff.FormulaData
Gets the raw bytes for the formula.
getFormulaData() - Method in interface jxl.read.biff.Formula
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.read.biff.NumberFormulaRecord
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.read.biff.StringFormulaRecord
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.read.biff.SharedDateFormulaRecord
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.read.biff.DateFormulaRecord
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.read.biff.SharedNumberFormulaRecord
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.read.biff.SharedStringFormulaRecord
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.read.biff.ErrorFormulaRecord
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.write.biff.FormulaRecord
Gets the raw bytes for the formula.
getFormulaData() - Method in class jxl.write.biff.ReadFormulaRecord
Gets the raw bytes for the formula.
getFormulas(FormattingRecords, boolean) - Method in class jxl.read.biff.SharedFormulaRecord
Manufactures individual cell formulas out the whole shared formula debacle
getFourBytes(int) - Static method in class jxl.biff.IntegerHelper
Gets a two 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
getFunction() - Method in class jxl.biff.formula.VariableArgFunction
Gets the underlying function
getFunction() - Method in class jxl.biff.formula.StringFunction
 
getFunction(int) - Static method in class jxl.biff.formula.Function
Gets the type object from its integer value
getFunction(String) - Static method in class jxl.biff.formula.Function
Gets the type object from its string value.
getHeader() - Method in class jxl.read.biff.SheetImpl
Gets the header.
getHeader() - Method in class jxl.read.biff.HeaderRecord
Gets the header string
getHeader() - Method in class jxl.read.biff.SheetReader
 
getHeader() - Method in class jxl.write.biff.SheetWriter
Gets the header.
getHeader() - Method in class jxl.write.biff.WritableSheetImpl
Gets the header.
getHeaderMargin() - Method in class jxl.SheetSettings
Accessor for the header margin
getHeaderMargin() - Method in class jxl.read.biff.SetupRecord
Accessor for the header.
getHidden() - Method in class jxl.biff.XFRecord
Accessor for the hidden flag
getHorizontalPrintResolution() - Method in class jxl.SheetSettings
Accessor for the horizontal print resolution
getHorizontalPrintResolution() - Method in class jxl.read.biff.SetupRecord
The horizontal print resolution.
getHyperlinks() - Method in interface jxl.Sheet
Gets the hyperlinks on this sheet
getHyperlinks() - Method in class jxl.read.biff.SheetImpl
Gets the hyperlinks on this sheet
getHyperlinks() - Method in class jxl.read.biff.SheetReader
 
getHyperlinks() - Method in class jxl.write.biff.WritableSheetImpl
Gets the hyperlinks on this sheet
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
getIf() - Method in class jxl.biff.formula.Attribute
Gets the associated if conditions with this attribute
getIndex(String) - Method in class jxl.write.biff.SharedStrings
Gets the index for the string passed in.
getIndexCode() - Method in class jxl.biff.FormatRecord
Gets the index code, for use as a hash value
getInitialFileSize() - Method in class jxl.WorkbookSettings
Accessor for the initial file size property
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 interface jxl.Hyperlink
Returns the column number of the bottom right cell
getLastColumn() - Method in class jxl.biff.formula.Area3d
 
getLastColumn() - Method in class jxl.biff.formula.SharedFormulaArea
 
getLastColumn() - Method in class jxl.biff.formula.Area
 
getLastColumn() - Method in class jxl.read.biff.NameRecord.NameRange
 
getLastColumn() - Method in class jxl.read.biff.HyperlinkRecord
Returns the column number of the bottom right cell
getLastColumn() - Method in class jxl.write.biff.HyperlinkRecord
Returns the column number of the bottom right cell
getLastRow() - Method in interface jxl.Hyperlink
Returns the row number of the bottom right cell
getLastRow() - Method in class jxl.biff.formula.Area3d
 
getLastRow() - Method in class jxl.biff.formula.SharedFormulaArea
 
getLastRow() - Method in class jxl.biff.formula.Area
 
getLastRow() - Method in class jxl.read.biff.NameRecord.NameRange
 
getLastRow() - Method in class jxl.read.biff.HyperlinkRecord
Returns the row number of the bottom right cell
getLastRow() - Method in class jxl.write.biff.HyperlinkRecord
Returns the row number of the bottom right cell
getLastSheet() - Method in class jxl.read.biff.NameRecord.NameRange
 
getLastSheetIndex() - Method in interface jxl.Range
Gets the index of the last sheet in the range
getLastSheetIndex() - Method in class jxl.biff.SheetRangeImpl
Not supported.
getLastSheetIndex() - Method in class jxl.read.biff.RangeImpl
Gets the index of the last sheet in the range
getLastTabIndex(int) - Method in class jxl.read.biff.ExternalSheetRecord
Gets the last tab index for the specified external sheet
getLeftMargin() - Method in class jxl.SheetSettings
Accessor for the left margin
getLength() - Method in class jxl.read.biff.Record
Gets the length of the record
getLocation() - Method in class jxl.read.biff.HyperlinkRecord
Gets the location referenced by this hyperlink
getLocationData(byte[]) - Method in class jxl.write.biff.HyperlinkRecord
Gets the hyperlink stream specific to a location link
getLocked() - Method in class jxl.biff.XFRecord
Accessor for the locked flag
getMargin() - Method in class jxl.read.biff.MarginRecord
Accessor for the margin
getMaxColumn() - Method in class jxl.write.biff.RowRecord
Gets the maximum column value which occurs in this row
getMergedCells() - Method in interface jxl.Sheet
Gets the cells which have been merged on this sheet
getMergedCells() - Method in class jxl.read.biff.SheetImpl
Gets the cells which have been merged on this sheet
getMergedCells() - Method in class jxl.read.biff.SheetReader
 
getMergedCells() - Method in class jxl.write.biff.WritableSheetImpl
Gets the cells which have been merged on this sheet
getMsoDrawingGroupRecord() - Method in class jxl.read.biff.WorkbookParser
Accessor for the MsoDrawingGroup, used by the WritableWorkbook when creating a copy of this
getName() - Method in interface jxl.Sheet
Gets the name of this sheet
getName() - Method in class jxl.biff.FontRecord
Gets the name of this font
getName() - Method in interface jxl.format.Font
Gets the name of this font
getName() - Method in class jxl.read.biff.SheetImpl
Gets the name of this sheet
getName() - Method in class jxl.read.biff.NameRecord
Gets the name
getName() - Method in class jxl.read.biff.BoundsheetRecord
Accessor for the worksheet name
getName() - Method in class jxl.write.biff.WritableSheetImpl
Gets the name of this sheet
getNameRecords() - Method in class jxl.read.biff.WorkbookParser
Accessor for the name records.
getNumberFormat() - Method in class jxl.biff.XFRecord
Gets the java number format for this format record
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.
getNumberIndex(String) - Static method in class jxl.biff.CellReferenceHelper
Finds the position where the first number occurs in the string
getNumberOfColumns() - Method in class jxl.read.biff.DimensionRecord
Accessor for the number of columns in this sheet
getNumberOfColumns() - Method in class jxl.read.biff.MulRKRecord
Accessor for the number of rk values
getNumberOfColumns() - Method in class jxl.read.biff.MulBlankRecord
Accessor for the number of blank values
getNumberOfFormatRecords() - Method in class jxl.biff.FormattingRecords
Gets the number of formatting records on the list.
getNumberOfRows() - Method in class jxl.read.biff.DimensionRecord
Accessor for the number of rows in this sheet
getNumberOfSheets() - Method in class jxl.Workbook
Returns the number of sheets in this workbook
getNumberOfSheets() - Method in class jxl.read.biff.WorkbookParser
Returns the number of sheets in this workbook
getNumberOfSheets() - Method in class jxl.read.biff.SupbookRecord
Gets the number of sheets.
getNumberOfSheets() - Method in class jxl.write.WritableWorkbook
Returns the number of sheets in this workbook
getNumberOfSheets() - Method in class jxl.write.biff.WritableWorkbookImpl
Returns the number of sheets in this workbook
getNumCols() - Method in class jxl.read.biff.SheetReader
 
getNumRows() - Method in class jxl.read.biff.SheetReader
 
getOffset() - Method in class jxl.write.biff.SSTRecord
Gets the current offset into this record, excluding the header fields
getOperands() - Method in class jxl.biff.formula.Operator
Gets the operands ie.
getOperands(Stack) - Method in class jxl.biff.formula.Operator
Gets the operands for this operator from the stack
getOperands(Stack) - Method in class jxl.biff.formula.BinaryOperator
Gets the operands for this operator from the stack
getOperands(Stack) - Method in class jxl.biff.formula.Parenthesis
Gets the operands for this operator from the stack
getOperands(Stack) - Method in class jxl.biff.formula.UnaryOperator
Gets the operands for this operator from the stack
getOperands(Stack) - Method in class jxl.biff.formula.VariableArgFunction
Gets the operands for this operator from the stack
getOperands(Stack) - Method in class jxl.biff.formula.Attribute
Gets the operands for this operator from the stack
getOperands(Stack) - Method in class jxl.biff.formula.BuiltInFunction
Gets the operands for this operator from the stack
getOptions() - Method in class jxl.read.biff.WorkspaceInformationRecord
Returns the optionsprotected flag
getOrientation() - Method in class jxl.SheetSettings
Accessor for the orientation
getOrientation() - Method in class jxl.biff.XFRecord
Gets the orientation
getOrientation() - Method in interface jxl.format.CellFormat
Gets the orientation
getOrientation(int) - Static method in class jxl.format.Orientation
Gets the alignment from the value
getPageStart() - Method in class jxl.SheetSettings
Accessor for the page start
getPageStart() - Method in class jxl.read.biff.SetupRecord
Accessor for the page height.
getPaperSize() - Method in class jxl.SheetSettings
Accessor for the paper size
getPaperSize() - Method in class jxl.read.biff.SetupRecord
Accessor for the paper size.
getPaperSize(int) - Static method in class jxl.format.PaperSize
Gets the paper size for a specific value
getPattern() - Method in class jxl.biff.XFRecord
Gets the pattern used by this cell format
getPattern() - Method in interface jxl.format.CellFormat
Gets the pattern used by this cell format
getPattern(int) - Static method in class jxl.format.Pattern
Gets the pattern from the value
getPointSize() - Method in class jxl.biff.FontRecord
Gets the point size for this font, if the font hasn't been initialized
getPointSize() - Method in interface jxl.format.Font
Gets the point size for this font, if the font hasn't been initialized
getPos() - Method in class jxl.biff.formula.Yylex
 
getPos() - Method in class jxl.read.biff.BiffRecordReader
 
getPos() - Method in class jxl.read.biff.File
Gets the position in the stream
getPos() - Method in class jxl.write.biff.File
Gets the current position within the file
getPrecedence() - Method in class jxl.biff.formula.Operator
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Divide
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Parenthesis
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.UnaryPlus
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Equal
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Percent
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.VariableArgFunction
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.GreaterEqual
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.UnaryMinus
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Concatenate
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Add
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Subtract
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.GreaterThan
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.LessEqual
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Multiply
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Attribute
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.Power
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.LessThan
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.NotEqual
Gets the precedence for this operator.
getPrecedence() - Method in class jxl.biff.formula.BuiltInFunction
Gets the precedence for this operator.
getPropertyStorage(String) - Method in class jxl.read.biff.CompoundFile
Gets the property set with the specified name
getRange() - Method in interface jxl.Hyperlink
Gets the range of cells which activate this hyperlink The get sheet index methods will all return -1, because the cells will all be present on the same sheet
getRange() - Method in class jxl.read.biff.HyperlinkRecord
Gets the range of cells which activate this hyperlink The get sheet index methods will all return -1, because the cells will all be present on the same sheet
getRange() - Method in class jxl.write.biff.HyperlinkRecord
Gets the range of cells which activate this hyperlink The get sheet index methods will all return -1, because the cells will all be present on the same sheet
getRanges() - Method in class jxl.read.biff.NameRecord
Gets the array of ranges for this name
getRanges() - Method in class jxl.read.biff.MergedCellsRecord
Gets the ranges which have been merged in this sheet
getRecord() - Method in class jxl.biff.RecordData
Returns the raw data to its subclasses
getRecord() - Method in class jxl.read.biff.BooleanRecord
A special case which overrides the method in the subclass to get hold of the raw data
getRecord() - Method in class jxl.read.biff.ObjRecord
Expose the protected function to the SheetImpl in this package
getRecord() - Method in class jxl.read.biff.HyperlinkRecord
Exposes the base class method.
getRecord() - Method in class jxl.read.biff.BaseSharedFormulaRecord
In case the shared formula is not added for any reason, we need to expose the raw record data , in order to try again
getRecord() - Method in class jxl.read.biff.MsoDrawingRecord
Expose the protected function to the SheetImpl in this package
getRightMargin() - Method in class jxl.SheetSettings
Accessor for the right margin
getRKNumber(int) - Method in class jxl.read.biff.MulRKRecord
Returns a specific rk number
getRow() - Method in interface jxl.Cell
Returns the row number of this cell
getRow() - Method in interface jxl.Hyperlink
Returns the row number of this cell
getRow() - Method in class jxl.biff.EmptyCell
Returns the row number of this cell
getRow() - Method in class jxl.biff.formula.CellReference3d
 
getRow() - Method in class jxl.biff.formula.CellReference
Accessor for the row
getRow() - Method in class jxl.biff.formula.SharedFormulaCellReference
 
getRow() - Method in class jxl.read.biff.DateRecord
Interface method which returns the row number of this cell
getRow() - Method in class jxl.read.biff.CellValue
Interface method which returns the row number of this cell
getRow() - Method in class jxl.read.biff.NumberValue
Accessor for the row
getRow() - Method in class jxl.read.biff.MulBlankCell
Accessor for the row
getRow() - Method in class jxl.read.biff.HyperlinkRecord
Returns the row number of the top left cell
getRow() - Method in class jxl.read.biff.MulRKRecord
Accessor for the row
getRow() - Method in class jxl.read.biff.MulBlankRecord
Accessor for the row
getRow() - Method in class jxl.write.biff.CellValue
Returns the row number of this cell
getRow() - Method in class jxl.write.biff.HyperlinkRecord
Returns the row number of the top left cell
getRow(int) - Method in interface jxl.Sheet
Gets all the cells on the specified row
getRow(int) - Method in class jxl.read.biff.SheetImpl
Gets all the cells on the specified row.
getRow(int) - Method in class jxl.write.biff.WritableSheetImpl
Gets all the cells on the specified row
getRow(String) - Static method in class jxl.biff.CellReferenceHelper
Gets the row number of the cell reference
getRowBreaks() - Method in class jxl.read.biff.HorizontalPageBreaksRecord
Gets the row breaks
getRowBreaks() - Method in class jxl.read.biff.SheetReader
 
getRowHeight() - Method in class jxl.read.biff.RowRecord
Gets the height of the row
getRowHeight() - Method in class jxl.write.biff.RowRecord
Gets the height of the row
getRowInfo(int) - Method in class jxl.read.biff.SheetImpl
Gets the row record.
getRowInfo(int) - Method in class jxl.write.biff.WritableSheetImpl
Gets the row record for the specified row
getRowNumber() - Method in class jxl.read.biff.RowRecord
Gets the row number
getRowNumber() - Method in class jxl.write.biff.RowRecord
Gets the row number of this row
getRowPageBreaks() - Method in class jxl.read.biff.SheetImpl
Gets the row breaks.
getRowProperties() - Method in class jxl.read.biff.SheetImpl
Gets the non-default rows.
getRowProperties() - Method in class jxl.read.biff.SheetReader
 
getRowRecord(int) - Method in class jxl.write.biff.WritableSheetImpl
Gets the row record at the specified row number, growing the array as needs dictate
getRows() - Method in interface jxl.Sheet
Returns the number of rows in this sheet
getRows() - Method in class jxl.read.biff.SheetImpl
Returns the number of rows in this sheet
getRows() - Method in class jxl.write.biff.WritableSheetImpl
Returns the number of rows in this sheet
getScaleFactor() - Method in class jxl.SheetSettings
Accessor for the scale factor
getScaleFactor() - Method in class jxl.read.biff.SetupRecord
Accessor for the scale factor.
getScriptStyle() - Method in class jxl.biff.FontRecord
Gets the script style
getScriptStyle() - Method in interface jxl.format.Font
Gets the script style
getSettings() - Method in interface jxl.Sheet
Gets the settings used on a particular sheet
getSettings() - Method in class jxl.read.biff.SheetImpl
Accessor for the sheet settings
getSettings() - Method in class jxl.read.biff.SheetReader
 
getSettings() - Method in class jxl.write.biff.WritableSheetImpl
Gets the settings for this sheet
getSheet(int) - Method in class jxl.Workbook
Gets the specified sheet within this workbook As described in the accompanying technical notes, each call to getSheet forces a reread of the sheet (for memory reasons).
getSheet(int) - Method in class jxl.read.biff.WorkbookParser
Gets the specified sheet within this workbook
getSheet(int) - Method in class jxl.write.WritableWorkbook
Gets the specified sheet within this workbook
getSheet(int) - Method in class jxl.write.biff.WritableWorkbookImpl
Gets the specified sheet within this workbook
getSheet(String) - Method in class jxl.Workbook
Gets the sheet with the specified name from within this workbook.
getSheet(String) - Method in class jxl.read.biff.WorkbookParser
Gets the sheet with the specified name from within this workbook
getSheet(String) - Method in class jxl.write.WritableWorkbook
Gets the sheet with the specified name from within this workbook
getSheet(String) - Method in class jxl.write.biff.WritableWorkbookImpl
Gets the sheet with the specified name from within this workbook
getSheetName(int) - Method in class jxl.read.biff.SupbookRecord
Gets the name of the external sheet
getSheets() - Method in class jxl.Workbook
Gets the sheets within this workbook.
getSheets() - Method in class jxl.read.biff.WorkbookParser
Gets the sheets within this workbook.
getSheets() - Method in class jxl.write.WritableWorkbook
Gets the sheets within this workbook.
getSheets() - Method in class jxl.write.biff.WritableWorkbookImpl
Gets the sheets within this workbook.
getShort(byte, byte) - Static method in class jxl.biff.IntegerHelper
Gets an short from two bytes
getShortName(String) - Method in class jxl.write.biff.HyperlinkRecord
Gets the DOS short file name in 8.3 format of the name passed in
getSmallBlockStream(BaseCompoundFile.PropertyStorage) - Method in class jxl.read.biff.CompoundFile
Build up the resultant stream using the small blocks
getStartColumn() - Method in class jxl.read.biff.ColumnInfoRecord
Accessor for the start column of this range
getStream(String) - Method in class jxl.read.biff.CompoundFile
Gets the defragmented stream from this ole compound file
getString() - Method in interface jxl.LabelCell
Gets the label for this cell.
getString() - Method in class jxl.read.biff.StringFormulaRecord
Interface method which returns the value
getString() - Method in class jxl.read.biff.LabelRecord
Gets the label
getString() - Method in class jxl.read.biff.LabelSSTRecord
Gets the label
getString() - Method in class jxl.read.biff.SharedStringFormulaRecord
Accessor for the value
getString() - Method in class jxl.read.biff.RStringRecord
Gets the label
getString() - Method in class jxl.write.biff.LabelRecord
Gets the label for this cell.
getString(byte[], int, int) - Static method in class jxl.biff.StringHelper
Gets a string from the data array
getString(int) - Method in class jxl.read.biff.SSTRecord
Gets the string at the specified position
getString(StringBuffer) - Method in class jxl.biff.formula.ParseItem
Gets the string representation of this item
getString(StringBuffer) - Method in class jxl.biff.formula.BinaryOperator
Gets the string version of this binary operator
getString(StringBuffer) - Method in class jxl.biff.formula.Parenthesis
 
getString(StringBuffer) - Method in class jxl.biff.formula.Area3d
 
getString(StringBuffer) - Method in class jxl.biff.formula.StringParseItem
Gets the string representation of this item.
getString(StringBuffer) - Method in class jxl.biff.formula.UnaryOperator
 
getString(StringBuffer) - Method in class jxl.biff.formula.Percent
 
getString(StringBuffer) - Method in class jxl.biff.formula.MissingArg
Abstract method implementation to get the string equivalent of this token
getString(StringBuffer) - Method in class jxl.biff.formula.VariableArgFunction
 
getString(StringBuffer) - Method in class jxl.biff.formula.CellReference3d
 
getString(StringBuffer) - Method in class jxl.biff.formula.SharedFormulaArea
 
getString(StringBuffer) - Method in class jxl.biff.formula.NumberValue
 
getString(StringBuffer) - Method in class jxl.biff.formula.StringValue
Abstract method implementation to get the string equivalent of this token
getString(StringBuffer) - Method in class jxl.biff.formula.BooleanValue
Abstract method implementation to get the string equivalent of this token
getString(StringBuffer) - Method in class jxl.biff.formula.Area
 
getString(StringBuffer) - Method in class jxl.biff.formula.Attribute
 
getString(StringBuffer) - Method in class jxl.biff.formula.CellReference
Gets the cell reference as a string for this item
getString(StringBuffer) - Method in class jxl.biff.formula.Name
Abstract method implementation to get the string equivalent of this token
getString(StringBuffer) - Method in class jxl.biff.formula.SharedFormulaCellReference
 
getString(StringBuffer) - Method in class jxl.biff.formula.BuiltInFunction
 
getStyle(int) - Static method in class jxl.format.BorderLineStyle
Gets the alignment from the value
getStyle(int) - Static method in class jxl.format.UnderlineStyle
Gets the UnderlineStyle from the value
getStyle(int) - Static method in class jxl.format.ScriptStyle
Gets the ScriptStyle from the value
getSupbookIndex(int) - Method in class jxl.read.biff.ExternalSheetRecord
Gets the supbook index for the specified external sheet
getSupbookRecords() - Method in class jxl.read.biff.WorkbookParser
Accessor for the supbook records, used by the WritableWorkbook when creating a copy of this
getSymbol() - Method in class jxl.biff.formula.BinaryOperator
Abstract method which gets the binary operator string symbol
getSymbol() - Method in class jxl.biff.formula.Divide
 
getSymbol() - Method in class jxl.biff.formula.UnaryOperator
Abstract method which gets the binary operator string symbol
getSymbol() - Method in class jxl.biff.formula.UnaryPlus
 
getSymbol() - Method in class jxl.biff.formula.Equal
 
getSymbol() - Method in class jxl.biff.formula.Percent
 
getSymbol() - Method in class jxl.biff.formula.GreaterEqual
 
getSymbol() - Method in class jxl.biff.formula.UnaryMinus
 
getSymbol() - Method in class jxl.biff.formula.Concatenate
 
getSymbol() - Method in class jxl.biff.formula.Add
 
getSymbol() - Method in class jxl.biff.formula.Subtract
 
getSymbol() - Method in class jxl.biff.formula.GreaterThan
 
getSymbol() - Method in class jxl.biff.formula.LessEqual
 
getSymbol() - Method in class jxl.biff.formula.Multiply
 
getSymbol() - Method in class jxl.biff.formula.Power
 
getSymbol() - Method in class jxl.biff.formula.LessThan
 
getSymbol() - Method in class jxl.biff.formula.NotEqual
 
getToken() - Method in class jxl.biff.formula.BinaryOperator
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.Divide
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.Parenthesis
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.UnaryOperator
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.UnaryPlus
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.Equal
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.Percent
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.GreaterEqual
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.UnaryMinus
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.Concatenate
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.Add
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.Subtract
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.GreaterThan
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.LessEqual
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.Multiply
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.Power
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.LessThan
Abstract method which gets the token for this operator
getToken() - Method in class jxl.biff.formula.NotEqual
Abstract method which gets the token for this operator
getToken(int) - Static method in class jxl.biff.formula.Token
Gets the type object from its integer value
getTokens() - Method in class jxl.biff.formula.StringFormulaParser
Gets the list of lexical tokens using the generated lexical analyzer
getTokens() - Method in class jxl.read.biff.BaseSharedFormulaRecord
Accessor for the tokens which make up this formula
getTopLeft() - Method in interface jxl.Range
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
getTopLeft() - Method in class jxl.read.biff.RangeImpl
Gets the cell at the top left of this range
getTopMargin() - Method in class jxl.SheetSettings
Accessor for the top margin
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() - Method in interface jxl.Cell
Returns the content type of this cell
getType() - Method in class jxl.biff.EmptyCell
Returns the content type of this cell
getType() - Method in class jxl.read.biff.DateRecord
Accessor for the cell type
getType() - Method in class jxl.read.biff.BooleanFormulaRecord
Returns the cell type
getType() - Method in class jxl.read.biff.ErrorRecord
Returns the cell type
getType() - Method in class jxl.read.biff.NumberValue
Accessor for the cell type
getType() - Method in class jxl.read.biff.BlankCell
Accessor for the cell type
getType() - Method in class jxl.read.biff.NumberRecord
Accessor for the cell type
getType() - Method in class jxl.read.biff.BooleanRecord
Returns the cell type
getType() - Method in class jxl.read.biff.NumberFormulaRecord
Returns the cell type
getType() - Method in class jxl.read.biff.StringFormulaRecord
Returns the cell type
getType() - Method in class jxl.read.biff.MulBlankCell
Accessor for the cell type
getType() - Method in class jxl.read.biff.Record
Gets the biff type
getType() - Method in class jxl.read.biff.LabelRecord
Accessor for the cell type
getType() - Method in class jxl.read.biff.RKRecord
Accessor for the cell type
getType() - Method in class jxl.read.biff.SharedDateFormulaRecord
Accessor for the cell type
getType() - Method in class jxl.read.biff.SupbookRecord
Gets the type of this supbook record
getType() - Method in class jxl.read.biff.DateFormulaRecord
Returns the cell type
getType() - Method in class jxl.read.biff.FormulaRecord
Returns the cell type
getType() - Method in class jxl.read.biff.SharedNumberFormulaRecord
Accessor for the cell type
getType() - Method in class jxl.read.biff.LabelSSTRecord
Returns the cell type
getType() - Method in class jxl.read.biff.SharedStringFormulaRecord
Accessor for the cell type
getType() - Method in class jxl.read.biff.RStringRecord
Accessor for the cell type
getType() - Method in class jxl.read.biff.ErrorFormulaRecord
Returns the cell type
getType() - Method in class jxl.write.biff.FormulaRecord
Returns the content type of this cell
getType() - Method in class jxl.write.biff.BooleanRecord
Returns the cell type
getType() - Method in class jxl.write.biff.NumberRecord
Returns the content type of this cell
getType() - Method in class jxl.write.biff.LabelRecord
Returns the content type of this cell
getType() - Method in class jxl.write.biff.DateRecord
Returns the content type of this cell
getType() - Method in class jxl.write.biff.BlankRecord
Returns the content type of this cell
getType() - Method in class jxl.write.biff.ReadFormulaRecord
Returns the content type of this cell
getType(int) - Static method in class jxl.biff.Type
Gets the type object from its integer value
getUnderlineStyle() - Method in class jxl.biff.FontRecord
Gets the underline style for this font
getUnderlineStyle() - Method in interface jxl.format.Font
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
getURL() - Method in interface jxl.Hyperlink
Gets the URL referenced by this Hyperlink
getURL() - Method in class jxl.read.biff.HyperlinkRecord
Gets the URL referenced by this Hyperlink
getURL() - Method in class jxl.write.biff.HyperlinkRecord
Gets the URL referenced by this Hyperlink
getURLData(byte[]) - Method in class jxl.write.biff.HyperlinkRecord
Gets the hyperlink stream specific to a URL link
getValue() - Method in interface jxl.NumberCell
Gets the double contents for this cell.
getValue() - Method in interface jxl.BooleanCell
Gets the boolean value stored in this cell.
getValue() - Method in class jxl.biff.formula.NumberValue
 
getValue() - Method in class jxl.biff.formula.IntegerValue
Accessor for the value
getValue() - Method in class jxl.biff.formula.DoubleValue
 
getValue() - Method in class jxl.format.PaperSize
Accessor for the internal binary value association with this paper size
getValue() - Method in class jxl.format.Colour
Gets the value of this colour.
getValue() - Method in class jxl.format.BorderLineStyle
Gets the value for this line style
getValue() - Method in class jxl.format.UnderlineStyle
Gets the value of this style.
getValue() - Method in class jxl.format.ScriptStyle
Gets the value of this style.
getValue() - Method in class jxl.format.Orientation
Accessor for the binary value
getValue() - Method in class jxl.format.Alignment
Gets the value of this alignment.
getValue() - Method in class jxl.format.Pattern
Gets the value of this pattern.
getValue() - Method in class jxl.format.BoldStyle
Gets the value of the bold weight.
getValue() - Method in class jxl.format.VerticalAlignment
Accessor for the binary value
getValue() - Method in class jxl.read.biff.BooleanFormulaRecord
Interface method which Gets the boolean value stored in this cell.
getValue() - Method in class jxl.read.biff.NumberValue
Accessor for the value
getValue() - Method in class jxl.read.biff.NumberRecord
Accessor for the value
getValue() - Method in class jxl.read.biff.BooleanRecord
Interface method which Gets the boolean value stored in this cell.
getValue() - Method in class jxl.read.biff.NumberFormulaRecord
Interface method which returns the value
getValue() - Method in class jxl.read.biff.RKRecord
Accessor for the value
getValue() - Method in class jxl.read.biff.SharedDateFormulaRecord
Accessor for the value
getValue() - Method in class jxl.read.biff.DateFormulaRecord
Interface method which returns the value
getValue() - Method in class jxl.read.biff.SharedNumberFormulaRecord
Accessor for the value
getValue() - Method in class jxl.write.biff.BooleanRecord
Interface method which Gets the boolean value stored in this cell.
getValue() - Method in class jxl.write.biff.NumberRecord
Gets the double contents for this cell.
getVersion() - Static method in class jxl.Workbook
Accessor for the software version
getVerticalAlignment() - Method in class jxl.biff.XFRecord
Gets the vertical cell alignment
getVerticalAlignment() - Method in interface jxl.format.CellFormat
Gets the vertical cell alignment
getVerticalPrintResolution() - Method in class jxl.SheetSettings
Accessor for the vertical print resolution
getVerticalPrintResolution() - Method in class jxl.read.biff.SetupRecord
Accessor for the vertical print resolution.
getWidth() - Method in class jxl.read.biff.ColumnInfoRecord
Accessor for the width of the column
getWidth() - Method in class jxl.write.biff.ColumnInfoRecord
Accessor for the width
getWorkbook(File) - Static method in class jxl.Workbook
A factory method which takes in an excel file and reads in the contents.
getWorkbook(File, WorkbookSettings) - Static method in class jxl.Workbook
A factory method which takes in an excel file and reads in the contents.
getWorkbook(InputStream) - Static method in class jxl.Workbook
A factory method which takes in an excel file and reads in the contents.
getWorkbook(InputStream, WorkbookSettings) - Static method in class jxl.Workbook
A factory method which takes in an excel file and reads in the contents.
getWorkbookBof() - Method in interface jxl.biff.formula.ExternalSheet
Parsing of formulas is only supported for a subset of the available biff version, so we need to test to see if this version is acceptable
getWorkbookBof() - Method in class jxl.read.biff.WorkbookParser
Method used when parsing formulas to make sure we are trying to parse a supported biff version
getWorkspaceOptions() - Method in class jxl.read.biff.SheetImpl
Gets the workspace options for this sheet.
getWorkspaceOptions() - Method in class jxl.read.biff.SheetReader
 
getWorkspaceOptions() - Method in class jxl.write.biff.SheetWriter
 
getWorkspaceOptions() - Method in class jxl.write.biff.WritableSheetImpl
Accessor for the workspace options
getWrap() - Method in class jxl.biff.XFRecord
Gets whether or not the contents of this cell are wrapped
getWrap() - Method in interface jxl.format.CellFormat
Gets whether or not the contents of this cell are wrapped
getWritableCell(int, int) - Method in interface jxl.write.WritableSheet
Gets the writable cell from this sheet.
getWritableCell(int, int) - Method in class jxl.write.biff.WritableSheetImpl
Returns the cell specified at this row and at this column
getWritableHyperlinks() - Method in interface jxl.write.WritableSheet
Gets the writable hyperlinks from this sheet.
getWritableHyperlinks() - Method in class jxl.write.biff.WritableSheetImpl
Gets the writable hyperlinks on this sheet
getXFIndex() - Method in class jxl.biff.XFRecord
Accessor for the XF index
getXFIndex() - Method in class jxl.read.biff.CellValue
Gets the XFRecord corresponding to the index number.
getXFIndex() - Method in class jxl.read.biff.ColumnInfoRecord
Accessor for the column format index
getXFIndex() - Method in class jxl.write.biff.CellValue
Gets the internal index of the formatting record
getXFIndex(int) - Method in class jxl.read.biff.MulRKRecord
Return a specific formatting index
getXFIndex(int) - Method in class jxl.read.biff.MulBlankRecord
Return a specific formatting index
getXFRecord(int) - Method in class jxl.biff.FormattingRecords
Gets the XFRecord for the specified index.
GMT - Static variable in class jxl.write.DateTime
Instance variable for dummy variable overload
gmtZone - Static variable in class jxl.read.biff.DateRecord
 
GOLD - Static variable in class jxl.format.Colour
 
gotoMask - Static variable in class jxl.biff.formula.Attribute
 
GRAY_25 - Static variable in class jxl.format.Colour
 
GRAY_25 - Static variable in class jxl.format.Pattern
 
GRAY_50 - Static variable in class jxl.format.Colour
 
GRAY_50 - Static variable in class jxl.format.Pattern
 
GRAY_75 - Static variable in class jxl.format.Pattern
 
GRAY_80 - Static variable in class jxl.format.Colour
 
GREATER_EQUAL - Static variable in class jxl.biff.formula.Token
 
GREATER_THAN - Static variable in class jxl.biff.formula.Token
 
GreaterEqual - class jxl.biff.formula.GreaterEqual.
A cell reference in a formula
GreaterEqual() - Constructor for class jxl.biff.formula.GreaterEqual
Constructor
GreaterThan - class jxl.biff.formula.GreaterThan.
A cell reference in a formula
GreaterThan() - Constructor for class jxl.biff.formula.GreaterThan
Constructor
GREEN - Static variable in class jxl.format.Colour
 
gridSet - Variable in class jxl.write.biff.GridSetRecord
Gridset flag
GRIDSET - Static variable in class jxl.biff.Type
 
GridSetRecord - class jxl.write.biff.GridSetRecord.
Record which indicates that the user changed the stae of the GridLines option
GridSetRecord(boolean) - Constructor for class jxl.write.biff.GridSetRecord
Constructor
growSize - Static variable in class jxl.write.biff.RowRecord
The amount to grow the cells array by
GROWTH - Static variable in class jxl.biff.formula.Function
 
GUTS - Static variable in class jxl.biff.Type
 
GuttersRecord - class jxl.write.biff.GuttersRecord.
Record which contains the size of the row and column gutters.
GuttersRecord() - Constructor for class jxl.write.biff.GuttersRecord
Constructor

H

HAIR - Static variable in class jxl.format.BorderLineStyle
 
handleFunction(StringFunction, Iterator, Stack) - Method in class jxl.biff.formula.StringFormulaParser
Handles the case when parsing a string when a token is a function
HARMEAN - Static variable in class jxl.biff.formula.Function
 
hasBorders() - Method in class jxl.biff.XFRecord
Determines if this cell format has any borders at all.
hasBorders() - Method in interface jxl.format.CellFormat
Determines if this cell format has any borders at all.
hashCode() - Method in class jxl.biff.Type
Standard hash code method
hasNext() - Method in class jxl.read.biff.BiffRecordReader
 
hasNext() - Method in class jxl.read.biff.File
Determines if the current position exceeds the end of the file
HCENTER - Static variable in class jxl.biff.Type
 
header - Variable in class jxl.read.biff.SheetImpl
The page header
header - Variable in class jxl.read.biff.HeaderRecord
The footer
header - Variable in class jxl.read.biff.SheetReader
The page header
header - Variable in class jxl.write.biff.SheetWriter
The page header
header - Variable in class jxl.write.biff.HeaderRecord
The print header string
HEADER - Static variable in class jxl.biff.Type
 
headerMargin - Variable in class jxl.SheetSettings
The margin allocated for any page headers, in inches
headerMargin - Variable in class jxl.read.biff.SetupRecord
The header margin
headerMargin - Variable in class jxl.write.biff.SetupRecord
The header margin
HeaderRecord - class jxl.read.biff.HeaderRecord.
A workbook page header record
HeaderRecord - class jxl.write.biff.HeaderRecord.
Record which specifies a print header for a work sheet
HeaderRecord.Biff7 - class jxl.read.biff.HeaderRecord.Biff7.
Dummy indicators for overloading the constructor
HeaderRecord.Biff7() - Constructor for class jxl.read.biff.HeaderRecord.Biff7
 
HeaderRecord(HeaderRecord) - Constructor for class jxl.write.biff.HeaderRecord
Consructor invoked when copying a spreadsheet
HeaderRecord(HeaderRecord) - Constructor for class jxl.write.biff.HeaderRecord
Consructor invoked when copying a sheets
HeaderRecord(Record) - Constructor for class jxl.read.biff.HeaderRecord
Constructs this object from the raw data
HeaderRecord(Record, HeaderRecord.Biff7) - Constructor for class jxl.read.biff.HeaderRecord
Constructs this object from the raw data
HeaderRecord(String, String, String) - Constructor for class jxl.write.biff.HeaderRecord
Constructor
hidden - Variable in class jxl.SheetSettings
Indicates whether or not this sheet is hidden
hidden - Variable in class jxl.biff.XFRecord
Flag to indicate whether this XF record is hidden
hidden - Variable in class jxl.read.biff.SheetImpl
The hidden flag
hidden - Variable in class jxl.write.biff.WritableSheetImpl
Flag which indicates whether this sheet is hidden
hideAll - Variable in class jxl.write.biff.HideobjRecord
Flag to hide everything
HIDEOBJ - Static variable in class jxl.biff.Type
 
HideobjRecord - class jxl.write.biff.HideobjRecord.
Stores options selected in the Options dialog box
HideobjRecord(boolean) - Constructor for class jxl.write.biff.HideobjRecord
Constructor
HLINK - Static variable in class jxl.biff.Type
 
HLOOKUP - Static variable in class jxl.biff.formula.Function
 
HORIZONTAL - Static variable in class jxl.format.Orientation
Cells with this specified orientation will be horizontal
HorizontalCentreRecord - class jxl.write.biff.HorizontalCentreRecord.
Record which indicates the whether the horizontal center option has been set
HorizontalCentreRecord(boolean) - Constructor for class jxl.write.biff.HorizontalCentreRecord
Constructor
HORIZONTALPAGEBREAKS - Static variable in class jxl.biff.Type
 
HorizontalPageBreaksRecord - class jxl.read.biff.HorizontalPageBreaksRecord.
Contains the cell dimensions of this worksheet
HorizontalPageBreaksRecord - class jxl.write.biff.HorizontalPageBreaksRecord.
Contains the list of explicit horizontal page breaks on the current sheet
HorizontalPageBreaksRecord.Biff7 - class jxl.read.biff.HorizontalPageBreaksRecord.Biff7.
Dummy indicators for overloading the constructor
HorizontalPageBreaksRecord.Biff7() - Constructor for class jxl.read.biff.HorizontalPageBreaksRecord.Biff7
 
HorizontalPageBreaksRecord(int[]) - Constructor for class jxl.write.biff.HorizontalPageBreaksRecord
Constructor
HorizontalPageBreaksRecord(Record) - Constructor for class jxl.read.biff.HorizontalPageBreaksRecord
Constructs the dimensions from the raw data
HorizontalPageBreaksRecord(Record, HorizontalPageBreaksRecord.Biff7) - Constructor for class jxl.read.biff.HorizontalPageBreaksRecord
Constructs the dimensions from the raw data
horizontalPrintResolution - Variable in class jxl.SheetSettings
The horizontal print resolution
horizontalPrintResolution - Variable in class jxl.read.biff.SetupRecord
The horizontal print resolution
horizontalPrintResolution - Variable in class jxl.write.biff.SetupRecord
The horizontal print resolution
HOUR - Static variable in class jxl.biff.formula.Function
 
Hyperlink - interface jxl.Hyperlink.
Hyperlink information.
HYPERLINK - Static variable in class jxl.biff.formula.Function
 
HYPERLINK_FONT - Static variable in class jxl.write.WritableWorkbook
The font used for hyperlinks
HYPERLINK_STYLE - Static variable in class jxl.write.WritableWorkbook
The style used for hyperlinks
HyperlinkRecord - class jxl.read.biff.HyperlinkRecord.
A number record.
HyperlinkRecord - class jxl.write.biff.HyperlinkRecord.
A number record.
HyperlinkRecord.LinkType - class jxl.read.biff.HyperlinkRecord.LinkType.
The excel type of hyperlink
HyperlinkRecord.LinkType - class jxl.write.biff.HyperlinkRecord.LinkType.
The excel type of hyperlink
HyperlinkRecord.LinkType() - Constructor for class jxl.read.biff.HyperlinkRecord.LinkType
 
HyperlinkRecord.LinkType() - Constructor for class jxl.write.biff.HyperlinkRecord.LinkType
 
HyperlinkRecord(Hyperlink, WritableSheet) - Constructor for class jxl.write.biff.HyperlinkRecord
Constructs this object from the a readable spreadsheet
HyperlinkRecord(int, int, int, int, File) - Constructor for class jxl.write.biff.HyperlinkRecord
Constructs a File hyperlink to a range of cells
HyperlinkRecord(int, int, int, int, String, WritableSheet, int, int, int, int) - Constructor for class jxl.write.biff.HyperlinkRecord
Constructs a hyperlink to some cells within this workbook
HyperlinkRecord(int, int, int, int, URL) - Constructor for class jxl.write.biff.HyperlinkRecord
Constructs a URL hyperlink to a range of cells
HyperlinkRecord(Record, Sheet) - Constructor for class jxl.read.biff.HyperlinkRecord
Constructs this object from the raw data
hyperlinks - Variable in class jxl.read.biff.SheetImpl
A list of hyperlinks on this page
hyperlinks - Variable in class jxl.read.biff.SheetReader
A list of hyperlinks on this page
hyperlinks - Variable in class jxl.write.biff.SheetWriter
Array of hyperlinks
hyperlinks - Variable in class jxl.write.biff.WritableSheetImpl
The list of hyperlinks
HYPGEOMDIST - Static variable in class jxl.biff.formula.Function
 

I

identifier - Static variable in class jxl.biff.BaseCompoundFile
The identifier at the beginning of every OLE file
IF - Static variable in class jxl.biff.formula.Function
 
ifConditions - Variable in class jxl.biff.formula.Attribute
If this attribute is an IF functions, sets the associated if conditions
ifMask - Static variable in class jxl.biff.formula.Attribute
 
ignoreSharedFormula - Static variable in class jxl.read.biff.FormulaRecord
 
includeLength - Variable in class jxl.write.biff.SSTContinueRecord
Indicates whether or not we need to include the length information for the first string
incorrectArguments - Static variable in class jxl.biff.formula.FormulaException
 
incrementColumn() - Method in class jxl.write.biff.CellValue
Increments the column of this cell by one.
incrementColumn() - Method in class jxl.write.biff.ColumnInfoRecord
Increments the column.
incrementRow() - Method in class jxl.write.biff.CellValue
Increments the row of this cell by one.
incrementRow() - Method in class jxl.write.biff.RowRecord
Increments the row of this cell by one.
index - Variable in class jxl.read.biff.LabelSSTRecord
The index into the shared string table
index - Variable in class jxl.write.NumberFormats.BuiltInFormat
The built in number format index
index - Variable in class jxl.write.DateFormats.BuiltInFormat
The index of this date format
index - Variable in class jxl.write.biff.LabelRecord
The index of the string in the shared string table
INDEX - Static variable in class jxl.biff.Type
 
INDEX - Static variable in class jxl.biff.formula.Function
 
indexCode - Variable in class jxl.biff.FormatRecord
The index code
IndexRecord - class jxl.write.biff.IndexRecord.
Index into the cell rows in an worksheet
IndexRecord(int, int, int) - Constructor for class jxl.write.biff.IndexRecord
Constructor
INDIRECT - Static variable in class jxl.biff.formula.Function
 
initExternal(SupbookRecord) - Method in class jxl.write.biff.SupbookRecord
Initializes an external supbook record
initialFileSize - Variable in class jxl.WorkbookSettings
The amount of memory allocated to store the workbook data when reading a worksheet.
initialFileSize - Variable in class jxl.read.biff.File
The initial file size
initialFileSize - Variable in class jxl.write.biff.File
The initial file size
initialize() - Method in class jxl.write.biff.FormulaRecord
Initializes the string and the formula bytes
initialize(int) - Method in interface jxl.biff.Format
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(int) - Method in interface jxl.biff.DisplayFormat
Initializes this format with the specified index number
initialize(int) - Method in class jxl.write.NumberFormats.BuiltInFormat
Initializes this format with a dynamically determined index value.
initialize(int) - Method in class jxl.write.DateFormats.BuiltInFormat
Initialize this format with the specified position.
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.
initialize(WritableSheet) - Method in class jxl.write.biff.HyperlinkRecord
Initializes the range when this hyperlink is added to the sheet
initialized - Variable in class jxl.biff.FontRecord
Flag to indicate whether the derived data (such as the font index) has been initialized or not
initialized - Variable in class jxl.biff.XFRecord
Flag to indicate whether this XF record has been initialized
initialized - Variable in class jxl.biff.FormatRecord
Initialized flag
initialized - Variable in class jxl.read.biff.DateRecord
A flag to indicate whether this objects formatting things have been initialized
initialized - Variable in class jxl.read.biff.CellValue
A lazy initialize flag for the cell format
initialized - Variable in class jxl.read.biff.NumberValue
A flag to indicate whether this object's formatting things have been initialized
initialized - Variable in class jxl.read.biff.MulBlankCell
A flag to indicate whether this object's formatting things have been initialized
initializeFormatInformation() - Method in class jxl.biff.XFRecord
Initializes the internal format information from the data read in
initInternal(SupbookRecord) - Method in class jxl.write.biff.SupbookRecord
Initializes an internal supbook record
inputWorkbook - Variable in class jxl.demo.ReadWrite
The spreadsheet to read in
insertColumn(int) - Method in class jxl.biff.SheetRangeImpl
A column has been inserted, so adjust the range objects accordingly
insertColumn(int) - Method in interface jxl.write.WritableSheet
Inserts a blank column into this spreadsheet.
insertColumn(int) - Method in class jxl.write.biff.HyperlinkRecord
A column has been inserted, so adjust the range objects accordingly
insertColumn(int) - Method in class jxl.write.biff.RowRecord
Inserts a new column at the position specified
insertColumn(int) - Method in class jxl.write.biff.WritableSheetImpl
Inserts a blank column into this spreadsheet.
insertRow(int) - Method in class jxl.biff.SheetRangeImpl
A row has been inserted, so adjust the range objects accordingly
insertRow(int) - Method in interface jxl.write.WritableSheet
Inserts a blank row into this spreadsheet.
insertRow(int) - Method in class jxl.write.biff.HyperlinkRecord
A row has been inserted, so adjust the range objects accordingly
insertRow(int) - Method in class jxl.write.biff.WritableSheetImpl
Inserts a blank row into this spreadsheet.
INT - Static variable in class jxl.biff.formula.Function
 
INTEGER - Static variable in class jxl.biff.formula.Token
 
INTEGER - Static variable in class jxl.write.NumberFormats
Formatting for an integer number.
IntegerHelper - class jxl.biff.IntegerHelper.
Converts excel byte representations into integers
IntegerHelper() - Constructor for class jxl.biff.IntegerHelper
 
IntegerValue - class jxl.biff.formula.IntegerValue.
A cell reference in a formula
IntegerValue() - Constructor for class jxl.biff.formula.IntegerValue
Constructor
IntegerValue(String) - Constructor for class jxl.biff.formula.IntegerValue
Constructor for an integer value being read from a string
INTERCEPT - Static variable in class jxl.biff.formula.Function
 
INTERFACEEND - Static variable in class jxl.biff.Type
 
InterfaceEndRecord - class jxl.write.biff.InterfaceEndRecord.
Marks the end of the user interface section of the Book stream.
InterfaceEndRecord() - Constructor for class jxl.write.biff.InterfaceEndRecord
Consructor
INTERFACEHDR - Static variable in class jxl.biff.Type
 
InterfaceHeaderRecord - class jxl.write.biff.InterfaceHeaderRecord.
Marks the beginning of the user interface record
InterfaceHeaderRecord() - Constructor for class jxl.write.biff.InterfaceHeaderRecord
Constructor
INTERNAL - Static variable in class jxl.read.biff.SupbookRecord
 
intersects(SheetRangeImpl) - Method in class jxl.biff.SheetRangeImpl
Sees whether there are any intersections between this range and the range passed in.
IPMT - Static variable in class jxl.biff.formula.Function
 
is1904() - Method in class jxl.read.biff.NineteenFourRecord
Accessor to see whether this spreadsheets dates are based around 1904
isBiff7() - Method in class jxl.read.biff.BOFRecord
Interrogates this object to see if it is a biff7 substream
isBiff8() - Method in class jxl.read.biff.BOFRecord
Interrogates this object to see if it is a biff8 substream
ISBLANK - Static variable in class jxl.biff.formula.Function
 
isBuiltIn() - Method in interface jxl.biff.Format
Accessor to determine whether or not this format is built in
isBuiltIn() - Method in class jxl.biff.FormatRecord
Indicates whether this formula is a built in
isBuiltIn() - Method in interface jxl.biff.DisplayFormat
Accessor to determine whether or not this format is built in
isBuiltIn() - Method in class jxl.write.NumberFormats.BuiltInFormat
Determines whether this format is a built in format
isBuiltIn() - Method in class jxl.write.DateFormats.BuiltInFormat
Determines whether this format is a built in format
isChart() - Method in class jxl.read.biff.BOFRecord
Interrogates the substream to see if it is a chart
isCollapsed() - Method in class jxl.read.biff.RowRecord
Queries whether the row is collapsed
isCollapsed() - Method in class jxl.write.biff.RowRecord
Queries whether the row is collapsed
isDate() - Method in class jxl.biff.XFRecord
Sees if this format is a date format
isDate() - Method in class jxl.biff.FormatRecord
Sees if this format is a date format
isDate(int) - Method in class jxl.biff.FormattingRecords
Sees if the extended formatting record at the specified position represents a date.
isDefaultHeight() - Method in class jxl.read.biff.RowRecord
Interrogates whether this row is of default height
isDefaultHeight() - Method in class jxl.write.biff.RowRecord
Interrogates whether this row is of default height
ISERR - Static variable in class jxl.biff.formula.Function
 
ISERROR - Static variable in class jxl.biff.formula.Function
 
isError() - Method in class jxl.read.biff.BooleanRecord
Interface method which queries whether this cell contains an error.
isFile() - Method in interface jxl.Hyperlink
Determines whether this is a hyperlink to a file
isFile() - Method in class jxl.read.biff.HyperlinkRecord
Determines whether this is a hyperlink to a file
isFile() - Method in class jxl.write.biff.HyperlinkRecord
Determines whether this is a hyperlink to a file
isFunction() - Method in class jxl.biff.formula.Attribute
Queries whether this attribute is a function
isGoto() - Method in class jxl.biff.formula.Attribute
Queries whether this attribute is a goto
isHidden() - Method in interface jxl.Cell
Indicates whether or not this cell is hidden, by virtue of either the entire row or column being collapsed
isHidden() - Method in interface jxl.Sheet
Deprecated. in favouf of the getSettings() method
isHidden() - Method in class jxl.SheetSettings
Accessor for the hidden nature of this sheet
isHidden() - Method in class jxl.biff.EmptyCell
Indicates whether or not this cell is hidden, by virtue of either the entire row or column being collapsed
isHidden() - Method in class jxl.read.biff.SheetImpl
Deprecated. in favour of the getSettings function
isHidden() - Method in class jxl.read.biff.DateRecord
Determines whether or not this cell has been hidden
isHidden() - Method in class jxl.read.biff.CellValue
Determines whether or not this cell has been hidden
isHidden() - Method in class jxl.read.biff.NumberValue
Determines whether or not this cell has been hidden
isHidden() - Method in class jxl.read.biff.MulBlankCell
Determines whether or not this cell has been hidden
isHidden() - Method in class jxl.read.biff.BoundsheetRecord
Accessor for the hidden flag
isHidden() - Method in class jxl.write.biff.CellValue
Indicates whether or not this cell is hidden, by virtue of either the entire row or column being collapsed
isHidden() - Method in class jxl.write.biff.WritableSheetImpl
Deprecated. in favour of the getSettings() method
isIf() - Method in class jxl.biff.formula.Attribute
Queries whether this attribute is an IF
isInitialized() - Method in interface jxl.biff.Format
Accessor to see whether this format has been initialized
isInitialized() - Method in class jxl.biff.FontRecord
Accessor to see whether this object is initialized or not.
isInitialized() - Method in class jxl.biff.XFRecord
Accessor to see if this format is initialized
isInitialized() - Method in class jxl.biff.FormatRecord
Accessor to see whether this object is initialized or not.
isInitialized() - Method in interface jxl.biff.DisplayFormat
Accessor to see whether this format has been initialized
isInitialized() - Method in class jxl.write.NumberFormats.BuiltInFormat
Accessor to determine if this format has been initialized.
isInitialized() - Method in class jxl.write.DateFormats.BuiltInFormat
Interface method which determines whether the index has been set.
isItalic() - Method in class jxl.biff.FontRecord
Returns the italic flag
isItalic() - Method in interface jxl.format.Font
Returns the italic flag
isLocation() - Method in interface jxl.Hyperlink
Determines whether this is a hyperlink to a location in this workbook
isLocation() - Method in class jxl.read.biff.HyperlinkRecord
Determines whether this is a hyperlink to a location in this workbook
isLocation() - Method in class jxl.write.biff.HyperlinkRecord
Determines whether this is a hyperlink to a location in this workbook
ISLOGICAL - Static variable in class jxl.biff.formula.Function
 
isMacroSheet() - Method in class jxl.read.biff.BOFRecord
Interrogates the substream to see if it is the commencement of a worksheet
ISNA - Static variable in class jxl.biff.formula.Function
 
ISNONTEXT - Static variable in class jxl.biff.formula.Function
 
ISNUMBER - Static variable in class jxl.biff.formula.Function
 
isNumber() - Method in class jxl.biff.XFRecord
Sees if this format is a number format
isNumber() - Method in class jxl.biff.FormatRecord
Sees if this format is a number format
isPortrait() - Method in class jxl.read.biff.SetupRecord
Accessor for the orientation.
isProtected() - Method in class jxl.Workbook
Determines whether the sheet is protected
isProtected() - Method in interface jxl.Sheet
Deprecated. in favour of the getSettings() method
isProtected() - Method in class jxl.SheetSettings
Queries whether this sheet is protected (ie.
isProtected() - Method in class jxl.read.biff.SheetImpl
Deprecated. in favour of the getSettings() api
isProtected() - Method in class jxl.read.biff.WorkbookParser
Determines whether the sheet is protected
isProtected() - Method in class jxl.read.biff.ProtectRecord
Returns the protected flag
isProtected() - Method in class jxl.write.biff.WritableSheetImpl
Deprecated. in favour of getSettings() api
isRead() - Method in class jxl.biff.XFRecord
Accessor to see if this format was read in.
ISREF - Static variable in class jxl.biff.formula.Function
 
isReferenced() - Method in class jxl.write.biff.CellValue
Internal method to see if this cell is referenced within the workbook.
isSelected() - Method in class jxl.SheetSettings
Accessor for the selected nature of the sheet
isShared() - Method in class jxl.read.biff.FormulaRecord
Interrogates this formula to determine if it forms part of a shared formula
isSheet() - Method in class jxl.read.biff.BoundsheetRecord
Accessor to determine if this is a worksheet, or some other nefarious type of object
isSum() - Method in class jxl.biff.formula.Attribute
Queries whether this attribute is a sum
ISTEXT - Static variable in class jxl.biff.formula.Function
 
isTime() - Method in interface jxl.DateCell
Indicates whether the date value contained in this cell refers to a date, or merely a time
isTime() - Method in class jxl.read.biff.DateRecord
Indicates whether the date value contained in this cell refers to a date, or merely a time
isTime() - Method in class jxl.read.biff.SharedDateFormulaRecord
Indicates whether the date value contained in this cell refers to a date, or merely a time
isTime() - Method in class jxl.write.biff.DateRecord
Indicates whether the date value contained in this cell refers to a date, or merely a time.
isURL() - Method in interface jxl.Hyperlink
Determines whether this is a hyperlink to a web resource
isURL() - Method in class jxl.read.biff.HyperlinkRecord
Determines whether this is a hyperlink to a web resource
isURL() - Method in class jxl.write.biff.HyperlinkRecord
Determines whether this is a hyperlink to a web resource
isWorkbookGlobals() - Method in class jxl.read.biff.BOFRecord
Interrogates this substream to see if it represents the commencement of the workbook globals substream
isWorksheet() - Method in class jxl.read.biff.BOFRecord
Interrogates the substream to see if it is the commencement of a worksheet
isZeroHeight() - Method in class jxl.read.biff.RowRecord
Queries whether the row has been set to zero height
italic - Variable in class jxl.biff.FontRecord
Indicates whether or not this font is italic
iterate - Variable in class jxl.write.biff.IterationRecord
The iterate flag
ITERATION - Static variable in class jxl.biff.Type
 
IterationRecord - class jxl.write.biff.IterationRecord.
Stores the iteration option from the dialog box
IterationRecord(boolean) - Constructor for class jxl.write.biff.IterationRecord
Constructor
iterationValue - Variable in class jxl.write.biff.DeltaRecord
The number of iterations

J

javaDateFormats - Static variable in class jxl.biff.XFRecord
 
javaNumberFormats - Static variable in class jxl.biff.XFRecord
 
JUSTIFY - Static variable in class jxl.format.Alignment
Data in cells with this alignment will be justified
JUSTIFY - Static variable in class jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data justified
jxl - package jxl
 
jxl.biff - package jxl.biff
 
jxl.biff.chart - package jxl.biff.chart
 
jxl.biff.formula - package jxl.biff.formula
 
jxl.demo - package jxl.demo
 
jxl.format - package jxl.format
 
jxl.read.biff - package jxl.read.biff
 
jxl.write - package jxl.write
 
jxl.write.biff - package jxl.write.biff
 
JXLException - exception jxl.JXLException.
Base exception class for JExcelAPI exceptions
JXLException(String) - Constructor for class jxl.JXLException
Constructor
JxlWriteException - exception jxl.write.biff.JxlWriteException.
Exception thrown when reading a biff file
JxlWriteException.WriteMessage - class jxl.write.biff.JxlWriteException.WriteMessage.
 
JxlWriteException.WriteMessage(String) - Constructor for class jxl.write.biff.JxlWriteException.WriteMessage
Constructs this exception with the specified message
JxlWriteException(JxlWriteException.WriteMessage) - Constructor for class jxl.write.biff.JxlWriteException
Constructs this exception with the specified message

K

KURT - Static variable in class jxl.biff.formula.Function
 

L

Label - class jxl.write.Label.
A cell containing text which may be created by user applications
LABEL - Static variable in class jxl.CellType
 
LABEL - Static variable in class jxl.biff.Type
 
Label(int, int, String) - Constructor for class jxl.write.Label
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates and will contain the specified text
Label(int, int, String, CellFormat) - Constructor for class jxl.write.Label
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates and will present the specified text in the manner specified by the CellFormat parameter
Label(LabelCell) - Constructor for class jxl.write.Label
Constructor used internally by the application when making a writable copy of a spreadsheet being read in
LabelCell - interface jxl.LabelCell.
A label cell
LabelRecord - class jxl.read.biff.LabelRecord.
A label which is stored in the cell
LabelRecord - class jxl.write.biff.LabelRecord.
A label record, used for writing out string
LabelRecord.Biff7 - class jxl.read.biff.LabelRecord.Biff7.
Dummy indicators for overloading the constructor
LabelRecord.Biff7() - Constructor for class jxl.read.biff.LabelRecord.Biff7
 
LabelRecord(int, int, String) - Constructor for class jxl.write.biff.LabelRecord
Constructor used when creating a label from the user API
LabelRecord(int, int, String, CellFormat) - Constructor for class jxl.write.biff.LabelRecord
Constructor used when creating a label from the API.
LabelRecord(LabelCell) - Constructor for class jxl.write.biff.LabelRecord
Constructor used when copying a label from a read only spreadsheet
LabelRecord(Record, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.LabelRecord
Constructs this object from the raw data
LabelRecord(Record, FormattingRecords, SheetImpl, LabelRecord.Biff7) - Constructor for class jxl.read.biff.LabelRecord
Constructs this object from the raw data
LABELSST - Static variable in class jxl.biff.Type
 
LabelSSTRecord - class jxl.read.biff.LabelSSTRecord.
A label which is stored in the shared string table
LabelSSTRecord(Record, SSTRecord, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.LabelSSTRecord
Constructor.
LANDSCAPE - Static variable in class jxl.format.PageOrientation
Landscape orientation
LARGE - Static variable in class jxl.biff.formula.Function
 
lastCol - Variable in class jxl.read.biff.SharedFormulaRecord
The last column to which this shared formula applies
lastColumn - Variable in class jxl.read.biff.HyperlinkRecord
The last column
lastColumn - Variable in class jxl.write.biff.HyperlinkRecord
The last column
lastRow - Variable in class jxl.read.biff.SharedFormulaRecord
The last row to which this shared formula applies
lastRow - Variable in class jxl.read.biff.HyperlinkRecord
The last row
lastRow - Variable in class jxl.write.biff.HyperlinkRecord
The last row
lastSheet - Variable in class jxl.read.biff.WorkbookParser
The last sheet accessed
lastSheetIndex - Variable in class jxl.read.biff.WorkbookParser
The index of the last sheet retrieved
lastTab - Variable in class jxl.read.biff.ExternalSheetRecord.XTI
 
LEFT - Static variable in class jxl.biff.formula.Function
 
LEFT - Static variable in class jxl.format.Border
 
LEFT - Static variable in class jxl.format.Alignment
Data cells with this alignment will appear at the left hand edge of the cell
LEFTB - Static variable in class jxl.biff.formula.Function
 
leftBorder - Variable in class jxl.biff.XFRecord
The border indicator for the left of this cell
leftMargin - Variable in class jxl.SheetSettings
The margin from the left hand side of the paper in inches
LEFTMARGIN - Static variable in class jxl.biff.Type
 
LeftMarginRecord - class jxl.read.biff.LeftMarginRecord.
Record for the left margin settings
LeftMarginRecord - class jxl.write.biff.LeftMarginRecord.
The settings for the left margin
LeftMarginRecord(double) - Constructor for class jxl.write.biff.LeftMarginRecord
 
LeftMarginRecord(Record) - Constructor for class jxl.read.biff.LeftMarginRecord
Constructor
LEN - Static variable in class jxl.biff.formula.Function
 
LENB - Static variable in class jxl.biff.formula.Function
 
length - Variable in class jxl.read.biff.Record
The length of this record
length - Variable in class jxl.read.biff.LabelRecord
The length of the label in characters
length - Variable in class jxl.read.biff.BoundsheetRecord
The length of the worksheet name
length - Variable in class jxl.read.biff.RStringRecord
The length of the label in characters
LESS_EQUAL - Static variable in class jxl.biff.formula.Token
 
LESS_THAN - Static variable in class jxl.biff.formula.Token
 
LessEqual - class jxl.biff.formula.LessEqual.
A cell reference in a formula
LessEqual() - Constructor for class jxl.biff.formula.LessEqual
Constructor
LessThan - class jxl.biff.formula.LessThan.
A cell reference in a formula
LessThan() - Constructor for class jxl.biff.formula.LessThan
Constructor
LETTER - Static variable in class jxl.format.PaperSize
US Letter
lexicalError - Static variable in class jxl.biff.formula.FormulaException
 
LIGHT_BLUE - Static variable in class jxl.format.Colour
 
LIGHT_GREEN - Static variable in class jxl.format.Colour
 
LIGHT_ORANGE - Static variable in class jxl.format.Colour
 
LIME - Static variable in class jxl.format.Colour
 
LINEST - Static variable in class jxl.biff.formula.Function
 
LINK - Static variable in class jxl.read.biff.SupbookRecord
 
linkType - Variable in class jxl.read.biff.HyperlinkRecord
The type of this hyperlink
linkType - Variable in class jxl.write.biff.HyperlinkRecord
The type of this hyperlink
LN - Static variable in class jxl.biff.formula.Function
 
location - Variable in class jxl.read.biff.HyperlinkRecord
The location in this workbook referred to by this hyperlink
location - Variable in class jxl.write.biff.HyperlinkRecord
The location in this workbook referred to by this hyperlink
locked - Variable in class jxl.biff.XFRecord
Flag to indicate whether this XF record represents a locked cell
LOG - Static variable in class jxl.biff.formula.Function
 
LOG10 - Static variable in class jxl.biff.formula.Function
 
LOGEST - Static variable in class jxl.biff.formula.Function
 
LOGINV - Static variable in class jxl.biff.formula.Function
 
LOGNORMDIST - Static variable in class jxl.biff.formula.Function
 
LOWER - Static variable in class jxl.biff.formula.Function
 

M

MacroSheet - Static variable in class jxl.read.biff.BOFRecord
The code used for macro sheets
main(String[]) - Static method in class jxl.demo.Demo
The main method.
manual - Static variable in class jxl.write.biff.CalcModeRecord
Manual calculation
margin - Variable in class jxl.read.biff.MarginRecord
The size of the margin
margin - Variable in class jxl.write.biff.MarginRecord
The margin
MarginRecord - class jxl.read.biff.MarginRecord.
Abstract class containing the margin value for top,left,right and bottom margins
MarginRecord - class jxl.write.biff.MarginRecord.
Record which specifies a margin value
MarginRecord(Type, double) - Constructor for class jxl.write.biff.MarginRecord
Constructor
MarginRecord(Type, Record) - Constructor for class jxl.read.biff.MarginRecord
Constructs this record from the raw data
MATCH - Static variable in class jxl.biff.formula.Function
 
MAX - Static variable in class jxl.biff.formula.Function
 
MAXA - Static variable in class jxl.biff.formula.Function
 
maxBytes - Static variable in class jxl.write.biff.SSTRecord
The maximum amount of bytes available for the SST record
maxBytes - Static variable in class jxl.write.biff.SSTContinueRecord
The maximum amount of bytes available for the SST record
maxColOutline - Variable in class jxl.write.biff.GuttersRecord
The maximum row outline level for the column gutter
maxFormatRecordsIndex - Static variable in class jxl.biff.FormattingRecords
The maximum number of format records.
maxRKValue - Static variable in class jxl.write.biff.RowRecord
The maximum integer value that can be squeezed into 30 bits
maxRowOutline - Variable in class jxl.write.biff.GuttersRecord
The maximum outline level for the row gutter
maxRowsExceeded - Static variable in class jxl.write.biff.JxlWriteException
 
MDETERM - Static variable in class jxl.biff.formula.Function
 
MEDIAN - Static variable in class jxl.biff.formula.Function
 
MEDIUM - Static variable in class jxl.format.BorderLineStyle
 
MEDIUM_DASH_DOT - Static variable in class jxl.format.BorderLineStyle
 
MEDIUM_DASH_DOT_DOT - Static variable in class jxl.format.BorderLineStyle
 
MEDIUM_DASHED - Static variable in class jxl.format.BorderLineStyle
 
mergeCells(int, int, int, int) - Method in interface jxl.write.WritableSheet
Merges the specified cells.
mergeCells(int, int, int, int) - Method in class jxl.write.biff.WritableSheetImpl
Merges the specified cells.
mergedCells - Variable in class jxl.read.biff.SheetImpl
A list of merged cells on this page
mergedCells - Variable in class jxl.read.biff.SheetReader
A list of merged cells on this page
mergedCells - Variable in class jxl.write.biff.SheetWriter
The list of merged ranges
mergedCells - Variable in class jxl.write.biff.WritableSheetImpl
The list of merged ranged
MERGEDCELLS - Static variable in class jxl.biff.Type
 
MergedCellsRecord - class jxl.read.biff.MergedCellsRecord.
A merged cells record for a given sheet
MergedCellsRecord - class jxl.write.biff.MergedCellsRecord.
A number record.
MergedCellsRecord(MergedCellsRecord, WritableSheet) - Constructor for class jxl.write.biff.MergedCellsRecord
Constructs this object from the a readable spreadsheet
MergedCellsRecord(Record, Sheet) - Constructor for class jxl.read.biff.MergedCellsRecord
Constructs this object from the raw data
MergedCellsRecord(WritableSheet) - Constructor for class jxl.write.biff.MergedCellsRecord
Constructs a merged cell record
message - Variable in class jxl.biff.formula.FormulaException.FormulaMessage
The message
message - Variable in class jxl.read.biff.BiffException.BiffMessage
 
message - Variable in class jxl.write.biff.JxlWriteException.WriteMessage
 
MID - Static variable in class jxl.biff.formula.Function
 
MIDB - Static variable in class jxl.biff.formula.Function
 
MIN - Static variable in class jxl.biff.formula.Function
 
MINA - Static variable in class jxl.biff.formula.Function
 
minRKValue - Static variable in class jxl.write.biff.RowRecord
The minimum integer value that can be squeezed into 30 bits
MINUS_90 - Static variable in class jxl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation of 90 degrees downwardswards
MINUTE - Static variable in class jxl.biff.formula.Function
 
MINVERSE - Static variable in class jxl.biff.formula.Function
 
MISSING_ARG - Static variable in class jxl.biff.formula.Token
 
MissingArg - class jxl.biff.formula.MissingArg.
Represents a missing argument in an argument list
MissingArg() - Constructor for class jxl.biff.formula.MissingArg
Constructor
MMS - Static variable in class jxl.biff.Type
 
MMSRecord - class jxl.write.biff.MMSRecord.
Stores the number of addmen and delmenu groups in the book stream
MMSRecord(int, int) - Constructor for class jxl.write.biff.MMSRecord
Constructor
MMULT - Static variable in class jxl.biff.formula.Function
 
MODE - Static variable in class jxl.biff.formula.Function
 
modified - Variable in class jxl.write.biff.HyperlinkRecord
Indicates whether this record has been modified since it was copied
modify(WritableWorkbook) - Method in class jxl.demo.ReadWrite
If the inputFile was the test spreadsheet, then it modifies certain fields of the writable copy
MONTH - Static variable in class jxl.biff.formula.Function
 
moveToFirstBof() - Method in class jxl.read.biff.File
Moves to the first bof in the file
msInADay - Static variable in class jxl.read.biff.DateRecord
 
msInADay - Static variable in class jxl.write.biff.DateRecord
 
MSODRAWING - Static variable in class jxl.biff.Type
 
msoDrawingGroup - Variable in class jxl.read.biff.WorkbookParser
The Mso Drawing Group record for this workbook
msoDrawingGroup - Variable in class jxl.write.biff.WritableWorkbookImpl
The Mso Drawing Group
MSODRAWINGGROUP - Static variable in class jxl.biff.Type
 
MsoDrawingGroupRecord - class jxl.read.biff.MsoDrawingGroupRecord.
A record which merely holds the MSODRAWINGGROUP data.
MsoDrawingGroupRecord - class jxl.write.biff.MsoDrawingGroupRecord.
An Mso Drawing Group record
MsoDrawingGroupRecord(MsoDrawingGroupRecord) - Constructor for class jxl.write.biff.MsoDrawingGroupRecord
Constructor
MsoDrawingGroupRecord(Record) - Constructor for class jxl.read.biff.MsoDrawingGroupRecord
Constructs this object from the raw data
msoDrawingRecord - Variable in class jxl.biff.chart.Chart
The MsoDrawingRecord associated with the chart
MsoDrawingRecord - class jxl.read.biff.MsoDrawingRecord.
A record which merely holds the MSODRAWING data.
MsoDrawingRecord(Record) - Constructor for class jxl.read.biff.MsoDrawingRecord
Constructs this object from the raw data
MULBLANK - Static variable in class jxl.biff.Type
 
MulBlankCell - class jxl.read.biff.MulBlankCell.
A blank cell value, initialized indirectly from a multiple biff record rather than directly from the binary data
MulBlankCell(int, int, int, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.MulBlankCell
Constructs this cell
MulBlankRecord - class jxl.read.biff.MulBlankRecord.
Contains an array of Blank, formatted cells
MulBlankRecord(Record) - Constructor for class jxl.read.biff.MulBlankRecord
Constructs the blank numbers from the raw data
MULRK - Static variable in class jxl.biff.Type
 
MulRKRecord - class jxl.read.biff.MulRKRecord.
Contains an array of RK numbers
MulRKRecord - class jxl.write.biff.MulRKRecord.
Contains an array of RK numbers
MulRKRecord(List) - Constructor for class jxl.write.biff.MulRKRecord
Constructs the rk numbers from the integer cells
MulRKRecord(Record) - Constructor for class jxl.read.biff.MulRKRecord
Constructs the rk numbers from the raw data
Multiply - class jxl.biff.formula.Multiply.
A cell reference in a formula
MULTIPLY - Static variable in class jxl.biff.formula.Token
 
Multiply() - Constructor for class jxl.biff.formula.Multiply
Constructor

N

N - Static variable in class jxl.biff.formula.Function
 
NA - Static variable in class jxl.biff.formula.Function
 
name - Variable in class jxl.biff.FontRecord
The name of this font
name - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The name of this property set
name - Variable in class jxl.read.biff.SheetImpl
The name of this sheet
name - Variable in class jxl.read.biff.NameRecord
The name
name - Variable in class jxl.read.biff.BoundsheetRecord
The worksheet name
name - Variable in class jxl.write.WritableFont.FontName
 
name - Variable in class jxl.write.biff.WritableSheetImpl
The name of this sheet
Name - class jxl.biff.formula.Name.
A name operand
NAME - Static variable in class jxl.biff.Type
 
NAME - Static variable in class jxl.biff.formula.Token
 
Name() - Constructor for class jxl.biff.formula.Name
Constructor
namedRecords - Variable in class jxl.read.biff.WorkbookParser
The named records found in this workbook
NameRecord - class jxl.read.biff.NameRecord.
Holds an excel name record, and the details of the cells/ranges it refers to
NameRecord - class jxl.write.biff.NameRecord.
A name record.
NameRecord.Biff7 - class jxl.read.biff.NameRecord.Biff7.
Dummy indicators for overloading the constructor
NameRecord.Biff7() - Constructor for class jxl.read.biff.NameRecord.Biff7
 
NameRecord.NameRange - class jxl.read.biff.NameRecord.NameRange.
A nested class to hold range information
NameRecord.NameRange(NameRecord, int, int, int, int, int, int) - Constructor for class jxl.read.biff.NameRecord.NameRange
 
NameRecord(NameRecord) - Constructor for class jxl.write.biff.NameRecord
Constructor - used when copying sheets
NameRecord(Record) - Constructor for class jxl.read.biff.NameRecord
Constructs this object from the raw data
NameRecord(Record, NameRecord.Biff7) - Constructor for class jxl.read.biff.NameRecord
Constructs this object from the raw data
names - Variable in class jxl.write.biff.WritableWorkbookImpl
The name records
namesDisabled - Static variable in class jxl.biff.Config
Flag to indicate whether the name feature is enabled or not Names deactivated using -Dnonames=true on the JVM command line Activated by default or by using -Dnonames=false on the JVM command line
NEGBINOMDIST - Static variable in class jxl.biff.formula.Function
 
next - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The next property set
NEXT_POS - Static variable in class jxl.biff.BaseCompoundFile
 
next() - Method in class jxl.read.biff.BiffRecordReader
 
next() - Method in class jxl.read.biff.File
Returns the next data record and increments the pointer
nextCustomIndexNumber - Variable in class jxl.biff.FormattingRecords
 
nineteenFour - Variable in class jxl.read.biff.SheetImpl
Indicates whether or not the dates are based around the 1904 date system
nineteenFour - Variable in class jxl.read.biff.WorkbookParser
Indicates whether or not the dates are based around the 1904 date system
nineteenFour - Variable in class jxl.read.biff.SheetReader
Indicates whether or not the dates are based around the 1904 date system
nineteenFour - Variable in class jxl.read.biff.NineteenFourRecord
The base year for dates
NINETEENFOUR - Static variable in class jxl.biff.Type
 
nineteenFourDate - Variable in class jxl.write.biff.NineteenFourRecord
Flag which indicates whether the 1904 date system is being used
NineteenFourRecord - class jxl.read.biff.NineteenFourRecord.
Identifies the date system as the 1904 system or not
NineteenFourRecord - class jxl.write.biff.NineteenFourRecord.
A record which indicates whether or the 1904 date system is in use
NineteenFourRecord(boolean) - Constructor for class jxl.write.biff.NineteenFourRecord
Constructor
NineteenFourRecord(Record) - Constructor for class jxl.read.biff.NineteenFourRecord
Constructs this object from the raw data
NO_BOLD - Static variable in class jxl.write.WritableFont
Indicates that this font should not be presented as bold
NO_BOLD - Static variable in class jxl.write.Font
Deprecated.  
NO_UNDERLINE - Static variable in class jxl.format.UnderlineStyle
 
NO_UNDERLINE - Static variable in class jxl.write.Font
Deprecated.  
NONE - Static variable in class jxl.format.Border
 
NONE - Static variable in class jxl.format.BorderLineStyle
 
NONE - Static variable in class jxl.format.Pattern
 
nonLeapDay - Static variable in class jxl.read.biff.DateRecord
 
nonLeapDay - Static variable in class jxl.write.biff.DateRecord
 
NORMAL - Static variable in class jxl.format.BoldStyle
Normal style
NORMAL_SCRIPT - Static variable in class jxl.format.ScriptStyle
 
NORMAL_SCRIPT - Static variable in class jxl.write.Font
Deprecated.  
NORMAL_STYLE - Static variable in class jxl.write.WritableWorkbook
The default style for cells
normalStyle - Static variable in class jxl.write.biff.WritableFormattingRecords
The statically defined normal style
NORMDIST - Static variable in class jxl.biff.formula.Function
 
NORMINV - Static variable in class jxl.biff.formula.Function
 
NORMSDIST - Static variable in class jxl.biff.formula.Function
 
NORMSINV - Static variable in class jxl.biff.formula.Function
 
NOT - Static variable in class jxl.biff.formula.Function
 
NOT_EQUAL - Static variable in class jxl.biff.formula.Token
 
NOTE - Static variable in class jxl.biff.Type
 
NotEqual - class jxl.biff.formula.NotEqual.
A cell reference in a formula
NotEqual() - Constructor for class jxl.biff.formula.NotEqual
Constructor
NOW - Static variable in class jxl.biff.formula.Function
 
NPER - Static variable in class jxl.biff.formula.Function
 
NPV - Static variable in class jxl.biff.formula.Function
 
NUM_BIG_BLOCK_DEPOT_BLOCKS_POS - Static variable in class jxl.biff.BaseCompoundFile
 
NUM_EXTENSION_BLOCK_POS - Static variable in class jxl.biff.BaseCompoundFile
 
numArgs - Variable in class jxl.biff.formula.Function
The number of args this function expects
number - Variable in class jxl.biff.XFRecord
Indicates whether this is a number formatting record
number - Variable in class jxl.biff.FormatRecord
Indicates whether this a number formatting record
Number - class jxl.write.Number.
A cell, created by user applications, which contains a numerical value
NUMBER - Static variable in class jxl.CellType
 
NUMBER - Static variable in class jxl.biff.Type
 
NUMBER_FORMULA - Static variable in class jxl.CellType
 
Number(int, int, double) - Constructor for class jxl.write.Number
Constructs a number, which, when added to a spreadsheet, will display the specified value at the column/row position indicated.
Number(int, int, double, CellFormat) - Constructor for class jxl.write.Number
Constructs a number, which, when added to a spreadsheet, will display the specified value at the column/row position with the specified CellFormat.
Number(NumberCell) - Constructor for class jxl.write.Number
Constructor used internally by the application when making a writable copy of a spreadsheet that has been read in
NumberCell - interface jxl.NumberCell.
A cell which contains a numerical value
numberFormat - Variable in class jxl.biff.XFRecord
The number format for this record.
NumberFormat - class jxl.write.NumberFormat.
A custom user defined number format, which may be instantiated within user applications in order to present numerical values to the appropriate level of accuracy.
NumberFormat(String) - Constructor for class jxl.write.NumberFormat
Constructor, taking in the Java compliant number format
NumberFormatRecord - class jxl.write.biff.NumberFormatRecord.
A class which contains a number format
NumberFormatRecord(String) - Constructor for class jxl.write.biff.NumberFormatRecord
Constructor.
numberFormats - Static variable in class jxl.biff.XFRecord
 
NumberFormats - class jxl.write.NumberFormats.
Static class which contains the available list of built in Number formats
NumberFormats.BuiltInFormat - class jxl.write.NumberFormats.BuiltInFormat.
Inner class which holds the format index
NumberFormats.BuiltInFormat(int, String) - Constructor for class jxl.write.NumberFormats.BuiltInFormat
Constructor, using the predetermined index
NumberFormats() - Constructor for class jxl.write.NumberFormats
 
NumberFormulaCell - interface jxl.NumberFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
NumberFormulaRecord - class jxl.read.biff.NumberFormulaRecord.
A formula's last calculated value
NumberFormulaRecord(Record, FormattingRecords, ExternalSheet, SheetImpl) - Constructor for class jxl.read.biff.NumberFormulaRecord
Constructs this object from the raw data
NumberRecord - class jxl.read.biff.NumberRecord.
A number record.
NumberRecord - class jxl.write.biff.NumberRecord.
The record which contains numerical values.
NumberRecord(int, int, double) - Constructor for class jxl.write.biff.NumberRecord
Constructor invoked by the user API
NumberRecord(int, int, double, CellFormat) - Constructor for class jxl.write.biff.NumberRecord
Overloaded constructor invoked from the API, which takes a cell format
NumberRecord(NumberCell) - Constructor for class jxl.write.biff.NumberRecord
Constructor used when copying a workbook
NumberRecord(Record, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.NumberRecord
Constructs this object from the raw data
NumberValue - class jxl.biff.formula.NumberValue.
A constant numerical value in a formula
NumberValue - class jxl.read.biff.NumberValue.
A numerical cell value, initialized indirectly from a multiple biff record rather than directly from the binary data
NumberValue() - Constructor for class jxl.biff.formula.NumberValue
 
NumberValue(int, int, double, int, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.NumberValue
Constructs this number
numBigBlockDepotBlocks - Variable in class jxl.read.biff.CompoundFile
The number of blocks it takes to store the big block depot
numBigBlockDepotBlocks - Variable in class jxl.write.biff.CompoundFile
The number of blocks it takes to store the big block depot
numblanks - Variable in class jxl.read.biff.MulBlankRecord
The number of blank numbers contained in this record
numCols - Variable in class jxl.read.biff.SheetImpl
The number of columns
numCols - Variable in class jxl.read.biff.DimensionRecord
The number of columns in this worksheet
numCols - Variable in class jxl.read.biff.SheetReader
The number of columns
numCols - Variable in class jxl.write.biff.SheetWriter
The number of columns.
numCols - Variable in class jxl.write.biff.DimensionRecord
The number of columns in the sheet
numColumns - Variable in class jxl.write.biff.RowRecord
The number of columns in this row.
numColumns - Variable in class jxl.write.biff.WritableSheetImpl
The number of columns.
numExtensionBlocks - Variable in class jxl.read.biff.CompoundFile
The number of header extension blocks
numExtensionBlocks - Variable in class jxl.write.biff.CompoundFile
The number of extension blocks required for the header to describe the BBD
NumFormatRecordsException - exception jxl.biff.NumFormatRecordsException.
Excel places a constraint on the number of format records that are allowed.
NumFormatRecordsException() - Constructor for class jxl.biff.NumFormatRecordsException
 
numFunctionGroups - Variable in class jxl.write.biff.FunctionGroupCountRecord
The number of built in function groups
numMenuItemsAdded - Variable in class jxl.write.biff.MMSRecord
The number of menu items added
numMenuItemsDeleted - Variable in class jxl.write.biff.MMSRecord
The number of menu items deleted
numReferences - Variable in class jxl.write.biff.SSTRecord
The number of string references in the workbook
numrks - Variable in class jxl.read.biff.MulRKRecord
The number of rk numbers contained in this record
numRows - Variable in class jxl.read.biff.SheetImpl
The number of rows
numRows - Variable in class jxl.read.biff.DimensionRecord
The number of rows in this sheet
numRows - Variable in class jxl.read.biff.SheetReader
The number of rows
numRows - Variable in class jxl.write.biff.SheetWriter
A number of rows.
numRows - Variable in class jxl.write.biff.WritableSheetImpl
A number of rows.
numRows - Variable in class jxl.write.biff.DimensionRecord
The number of rows in the sheet
numRowsPerSheet - Static variable in class jxl.write.biff.WritableSheetImpl
The maximum number of rows excel allows in a worksheet
numSheets - Variable in class jxl.read.biff.SupbookRecord
The number of sheets - internal & external supbooks only
numSheets - Variable in class jxl.write.biff.SupbookRecord
The number of sheets - internal & external supbooks only
numStrings - Variable in class jxl.write.biff.SSTRecord
The number of strings in this table

O

OBJ - Static variable in class jxl.biff.Type
 
objRecord - Variable in class jxl.biff.chart.Chart
The ObjRecord associated with the chart
ObjRecord - class jxl.read.biff.ObjRecord.
A record which merely holds the OBJ data.
ObjRecord(Record) - Constructor for class jxl.read.biff.ObjRecord
Constructs this object from the raw data
ODD - Static variable in class jxl.biff.formula.Function
 
offset - Variable in class jxl.read.biff.BoundsheetRecord
The offset into the sheet
OFFSET - Static variable in class jxl.biff.formula.Function
 
oldPos - Variable in class jxl.read.biff.File
The saved pos
OpenParentheses - class jxl.biff.formula.OpenParentheses.
A dummy token used when parsing strings in order to indicate the opening of some parenthesees
OpenParentheses() - Constructor for class jxl.biff.formula.OpenParentheses
Constructor
Operand - class jxl.biff.formula.Operand.
An operand in the parse tree.
Operand() - Constructor for class jxl.biff.formula.Operand
 
operands - Variable in class jxl.biff.formula.Operator
The items which this operator manipulates.
Operator - class jxl.biff.formula.Operator.
An operator is a node in a parse tree.
Operator() - Constructor for class jxl.biff.formula.Operator
Constructor
options - Variable in class jxl.biff.XFRecord
The options mask which is used to store the processed cell options (such as alignment, borders etc)
options - Variable in class jxl.biff.formula.Attribute
The options used by the attribute
OR - Static variable in class jxl.biff.formula.Function
 
ORANGE - Static variable in class jxl.format.Colour
 
orientation - Variable in class jxl.SheetSettings
The page orientation
orientation - Variable in class jxl.biff.XFRecord
The orientation of the cell
orientation - Variable in class jxl.write.biff.SetupRecord
The page orientation
Orientation - class jxl.format.Orientation.
Enumeration type which describes the orientation of data within a cell
Orientation(int, String) - Constructor for class jxl.format.Orientation
Constructor
orientations - Static variable in class jxl.format.Orientation
The list of alignments
out - Variable in class jxl.demo.XML
The output stream to write to
out - Variable in class jxl.write.biff.CompoundFile
The stream to which the jumbled up data is written to
outputFile - Variable in class jxl.write.biff.SheetWriter
A handle to the output file which the binary data is written to
outputFile - Variable in class jxl.write.biff.WritableSheetImpl
A handle to the output file which the binary data is written to
outputFile - Variable in class jxl.write.biff.WritableWorkbookImpl
The output file to write the workbook to
outputStream - Variable in class jxl.write.biff.File
The output stream
outputWorkbook - Variable in class jxl.demo.ReadWrite
The spreadsheet to output

P

PageOrientation - class jxl.format.PageOrientation.
Enumeration type which describes the page orientation
PageOrientation() - Constructor for class jxl.format.PageOrientation
Constructor
pageStart - Variable in class jxl.SheetSettings
The page number at which to commence printing
pageStart - Variable in class jxl.read.biff.SetupRecord
The page start
pageStart - Variable in class jxl.write.biff.SetupRecord
The page start
PALE_BLUE - Static variable in class jxl.format.Colour
 
paperSize - Variable in class jxl.SheetSettings
The paper size for printing
paperSize - Variable in class jxl.read.biff.SetupRecord
The paper size
paperSize - Variable in class jxl.write.biff.SetupRecord
The paper size
PaperSize - class jxl.format.PaperSize.
Enumeration type which contains the available excel paper sizes and their codes
PaperSize.Dummy - class jxl.format.PaperSize.Dummy.
 
PaperSize.Dummy() - Constructor for class jxl.format.PaperSize.Dummy
 
PaperSize(int) - Constructor for class jxl.format.PaperSize
Constructor
PaperSize(int, PaperSize.Dummy) - Constructor for class jxl.format.PaperSize
Constructor with a dummy parameter for unknown paper sizes
paperSizes - Static variable in class jxl.format.PaperSize
The paper sizes
parent - Variable in class jxl.biff.formula.ParseItem
The parent of this parse item
Parenthesis - class jxl.biff.formula.Parenthesis.
A cell reference in a formula
PARENTHESIS - Static variable in class jxl.biff.formula.Token
 
Parenthesis() - Constructor for class jxl.biff.formula.Parenthesis
Constructor
parse() - Method in class jxl.Workbook
Parses the excel file.
parse() - Method in class jxl.biff.formula.FormulaParser
Parses the formula into a parse tree
parse() - Method in class jxl.biff.formula.TokenFormulaParser
Parses the list of tokens
parse() - Method in interface jxl.biff.formula.Parser
Parses the formula
parse() - Method in class jxl.biff.formula.StringFormulaParser
Parses the list of tokens
parse() - Method in class jxl.read.biff.WorkbookParser
Does the hard work of building up the object graph from the excel bytes
parseCurrent(Iterator) - Method in class jxl.biff.formula.StringFormulaParser
Recursively parses the token array.
parsedFormula - Variable in class jxl.biff.formula.StringFormulaParser
The parsed formula string, as retrieved from the parse tree
ParsedThing - interface jxl.biff.formula.ParsedThing.
An interface for an excel ptg
ParseItem - class jxl.biff.formula.ParseItem.
Abstract base class for an item in a formula parse tree
ParseItem() - Constructor for class jxl.biff.formula.ParseItem
Constructor
parser - Variable in class jxl.biff.formula.FormulaParser
The formula parser.
parser - Variable in class jxl.write.biff.FormulaRecord
The formula parser
Parser - interface jxl.biff.formula.Parser.
Interface used by the two different types of formula parser
password - Variable in class jxl.write.biff.PasswordRecord
The password
PASSWORD - Static variable in class jxl.biff.Type
 
PasswordException - exception jxl.read.biff.PasswordException.
A properly typed exception in case consumers of the API specifically wish to handle the case when the workbook is password protected
PasswordException() - Constructor for class jxl.read.biff.PasswordException
Constructor
passwordProtected - Static variable in class jxl.read.biff.BiffException
 
PasswordRecord - class jxl.write.biff.PasswordRecord.
A password record
PasswordRecord(String) - Constructor for class jxl.write.biff.PasswordRecord
Constructor
pattern - Variable in class jxl.biff.XFRecord
The background pattern
Pattern - class jxl.format.Pattern.
Enumeration class which contains the various patterns available within the standard Excel pattern palette
Pattern - class jxl.write.Pattern.
Deprecated. Repackaged as jxl.format.Pattern
Pattern() - Constructor for class jxl.write.Pattern
Deprecated. Private constructor
Pattern(int, String) - Constructor for class jxl.format.Pattern
Private constructor
patterns - Static variable in class jxl.format.Pattern
The list of patterns
PEARSON - Static variable in class jxl.biff.formula.Function
 
peek() - Method in class jxl.read.biff.File
 
Percent - class jxl.biff.formula.Percent.
A cell reference in a formula
PERCENT - Static variable in class jxl.biff.formula.Token
 
PERCENT_FLOAT - Static variable in class jxl.write.NumberFormats
Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"
PERCENT_INTEGER - Static variable in class jxl.write.NumberFormats
Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"
Percent() - Constructor for class jxl.biff.formula.Percent
Constructor
PERCENTILE - Static variable in class jxl.biff.formula.Function
 
PERCENTRANK - Static variable in class jxl.biff.formula.Function
 
PERMUT - Static variable in class jxl.biff.formula.Function
 
PI - Static variable in class jxl.biff.formula.Function
 
PINK - Static variable in class jxl.format.Colour
 
PLUS_90 - Static variable in class jxl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation of 90 degrees upwards
PMT - Static variable in class jxl.biff.formula.Function
 
pointHeight - Variable in class jxl.biff.FontRecord
The point height of this font
POISSON - Static variable in class jxl.biff.formula.Function
 
PORTRAIT - Static variable in class jxl.format.PageOrientation
Portrait orientation
portraitOrientation - Variable in class jxl.read.biff.SetupRecord
The orientation flag
pos - Variable in class jxl.biff.formula.TokenFormulaParser
The current position within the array
pos - Variable in class jxl.read.biff.File
The current position within the file
pos - Variable in class jxl.write.biff.File
The current position within the file
position - Variable in class jxl.write.biff.DBCellRecord
The position of this record in the file.
Power - class jxl.biff.formula.Power.
A cell reference in a formula
POWER - Static variable in class jxl.biff.formula.Function
 
POWER - Static variable in class jxl.biff.formula.Token
 
Power() - Constructor for class jxl.biff.formula.Power
Constructor
PPMT - Static variable in class jxl.biff.formula.Function
 
PRECISION - Static variable in class jxl.biff.Type
 
PrecisionRecord - class jxl.write.biff.PrecisionRecord.
Stores the Precision As Displayed option from the dialog box
PrecisionRecord(boolean) - Constructor for class jxl.write.biff.PrecisionRecord
Constructor
previous - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The previous property set
PREVIOUS_POS - Static variable in class jxl.biff.BaseCompoundFile
 
printGridLines - Variable in class jxl.write.biff.PrintGridLinesRecord
The print grid lines option
PRINTGRIDLINES - Static variable in class jxl.biff.Type
 
PrintGridLinesRecord - class jxl.write.biff.PrintGridLinesRecord.
The grid lines option from the Page Setup dialog box
PrintGridLinesRecord(boolean) - Constructor for class jxl.write.biff.PrintGridLinesRecord
Constructor
printHeaders - Variable in class jxl.write.biff.PrintHeadersRecord
Flag to print headers
PRINTHEADERS - Static variable in class jxl.biff.Type
 
PrintHeadersRecord - class jxl.write.biff.PrintHeadersRecord.
The headings options from the Page Setup dialog box
PrintHeadersRecord(boolean) - Constructor for class jxl.write.biff.PrintHeadersRecord
Constructor
PROB - Static variable in class jxl.biff.formula.Function
 
PRODUCT - Static variable in class jxl.biff.formula.Function
 
PROPER - Static variable in class jxl.biff.formula.Function
 
PROPERTY_STORAGE_BLOCK_SIZE - Static variable in class jxl.biff.BaseCompoundFile
 
propertySets - Variable in class jxl.read.biff.CompoundFile
The list of property sets
prot - Variable in class jxl.read.biff.ProtectRecord
Protected flag
PROT4REV - Static variable in class jxl.biff.Type
 
PROT4REVPASS - Static variable in class jxl.biff.Type
 
Prot4RevPassRecord - class jxl.write.biff.Prot4RevPassRecord.
Stores the shared workbook protection flag
Prot4RevPassRecord() - Constructor for class jxl.write.biff.Prot4RevPassRecord
Constructor
Prot4RevRecord - class jxl.write.biff.Prot4RevRecord.
The shared workbook protection flag
Prot4RevRecord(boolean) - Constructor for class jxl.write.biff.Prot4RevRecord
Constructor
PROTECT - Static variable in class jxl.biff.Type
 
protection - Variable in class jxl.write.biff.Prot4RevRecord
The protection flag
protection - Variable in class jxl.write.biff.WindowProtectRecord
Protect flag
protection - Variable in class jxl.write.biff.ProtectRecord
The protection state
ProtectRecord - class jxl.read.biff.ProtectRecord.
A record detailing whether the sheet is protected
ProtectRecord - class jxl.write.biff.ProtectRecord.
The protection state for a sheet or workbook
ProtectRecord(boolean) - Constructor for class jxl.write.biff.ProtectRecord
Constructor
ProtectRecord(Record) - Constructor for class jxl.read.biff.ProtectRecord
Constructs this object from the raw data
PV - Static variable in class jxl.biff.formula.Function
 

Q

QUARTILE - Static variable in class jxl.biff.formula.Function
 

R

RADIANS - Static variable in class jxl.biff.formula.Function
 
RAND - Static variable in class jxl.biff.formula.Function
 
range - Variable in class jxl.read.biff.HyperlinkRecord
The range of cells which activate this hyperlink
range - Variable in class jxl.write.biff.HyperlinkRecord
The range of this hyperlink.
Range - interface jxl.Range.
Represents a 3-D range of cells in a workbook.
RangeImpl - class jxl.read.biff.RangeImpl.
Implementation class for the Range interface.
RangeImpl(WorkbookParser, int, int, int, int, int, int) - Constructor for class jxl.read.biff.RangeImpl
Constructor
ranges - Variable in class jxl.read.biff.NameRecord
The ranges referenced by this name
ranges - Variable in class jxl.read.biff.MergedCellsRecord
The ranges of the cells merged on this sheet
ranges - Variable in class jxl.write.biff.MergedCellsRecord
The ranges of all the cells which are merged on this sheet
RANK - Static variable in class jxl.biff.formula.Function
 
RATE - Static variable in class jxl.biff.formula.Function
 
read - Variable in class jxl.biff.XFRecord
Indicates whether this cell was constructed by an API or read from an existing Excel file
read() - Method in class jxl.read.biff.SheetReader
Reads in the contents of this sheet
read(byte[], int) - Method in class jxl.biff.formula.BinaryOperator
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.Parenthesis
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.Area3d
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.UnaryOperator
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.MissingArg
Reads the ptg data from the array starting at the specified position.
read(byte[], int) - Method in class jxl.biff.formula.VariableArgFunction
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.CellReference3d
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in interface jxl.biff.formula.ParsedThing
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.SharedFormulaArea
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.IntegerValue
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.DoubleValue
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.StringValue
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.BooleanValue
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.Area
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.Attribute
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.CellReference
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.Name
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.SharedFormulaCellReference
Reads the ptg data from the array starting at the specified position
read(byte[], int) - Method in class jxl.biff.formula.BuiltInFunction
Reads the ptg data from the array starting at the specified position
read(int, int) - Method in class jxl.read.biff.File
Copies the bytes into a new array and returns it.
read10ByteData(byte[]) - Method in class jxl.read.biff.DimensionRecord
Reads in the data for data records of length 10
read14ByteData(byte[]) - Method in class jxl.read.biff.DimensionRecord
Reads in the data for data records of length 14
readBigBlockDepot() - Method in class jxl.read.biff.CompoundFile
Reads the big block depot entries
readBlanks(byte[]) - Method in class jxl.read.biff.MulBlankRecord
Reads the blanks from the raw data
readData(int) - Method in class jxl.read.biff.CompoundFile
Reads the block chain from the specified block and returns the data as a continuous stream of bytes
reader - Variable in class jxl.demo.BiffDump
 
reader - Variable in class jxl.demo.WriteAccess
 
readExternal(byte[]) - Method in class jxl.read.biff.SupbookRecord
Reads the external data records
ReadFormulaRecord - class jxl.write.biff.ReadFormulaRecord.
A formula record.
ReadFormulaRecord(FormulaData) - Constructor for class jxl.write.biff.ReadFormulaRecord
Constructor
readFromSheet - Variable in class jxl.biff.formula.VariableArgFunction
Flag which indicates whether this was initialized from the client api or from an excel sheet
readPropertySets() - Method in class jxl.read.biff.CompoundFile
Reads all the property sets
readRks(byte[]) - Method in class jxl.read.biff.MulRKRecord
Reads the rks from the raw data
readSheet() - Method in class jxl.read.biff.SheetImpl
Reads in the contents of this sheet
readSmallBlockDepot() - Method in class jxl.read.biff.CompoundFile
Reads the small block depot entries
readString(byte[]) - Method in class jxl.read.biff.StringFormulaRecord
Reads in the string
readStrings(byte[], int) - Method in class jxl.read.biff.SSTRecord
Reads in all the strings from the raw data
ReadWrite - class jxl.demo.ReadWrite.
Demo class which uses the api to read in a spreadsheet and generate a clone of that spreadsheet which contains the same data.
readWrite() - Method in class jxl.demo.ReadWrite
Reads in the inputFile and creates a writable copy of it called outputFile
ReadWrite(String, String) - Constructor for class jxl.demo.ReadWrite
Constructor
recalc - Variable in class jxl.write.biff.SaveRecalcRecord
The recalculate before save flag
record - Variable in class jxl.biff.RecordData
The raw data
record - Variable in class jxl.read.biff.BiffRecordReader
The current record retrieved
Record - class jxl.read.biff.Record.
A container for the raw record data within a biff file
Record(byte[], int, File) - Constructor for class jxl.read.biff.Record
Constructor
RecordData - class jxl.biff.RecordData.
The record data within a record
RecordData(Record) - Constructor for class jxl.biff.RecordData
Constructs this object from the raw data
RecordData(Type) - Constructor for class jxl.biff.RecordData
Constructor used by the writable records
recordNames - Variable in class jxl.demo.BiffDump
 
RED - Static variable in class jxl.format.Colour
 
REF - Static variable in class jxl.biff.formula.Token
 
REF3D - Static variable in class jxl.biff.formula.Token
 
referenced - Variable in class jxl.write.biff.CellValue
A flag to indicate that this record is already referenced within a worksheet
REFMODE - Static variable in class jxl.biff.Type
 
RefModeRecord - class jxl.write.biff.RefModeRecord.
Stores the reference style option from the options dialog box
RefModeRecord() - Constructor for class jxl.write.biff.RefModeRecord
Constructor
refreshall - Variable in class jxl.write.biff.RefreshAllRecord
The refresh all flag
REFRESHALL - Static variable in class jxl.biff.Type
 
RefreshAllRecord - class jxl.write.biff.RefreshAllRecord.
Record which indicates whether or not data ranges and pivot tables should be refreshed when the workbook is loaded
RefreshAllRecord(boolean) - Constructor for class jxl.write.biff.RefreshAllRecord
Constructor
REFV - Static variable in class jxl.biff.formula.Token
 
relativeTo - Variable in class jxl.biff.formula.CellReference3d
The cell containing the formula.
relativeTo - Variable in class jxl.biff.formula.TokenFormulaParser
The cell containing the formula.
relativeTo - Variable in class jxl.biff.formula.SharedFormulaArea
The cell containing the formula.
relativeTo - Variable in class jxl.biff.formula.CellReference
The cell containing the formula.
relativeTo - Variable in class jxl.biff.formula.SharedFormulaCellReference
The cell containing the formula.
removeCell(int) - Method in class jxl.write.biff.RowRecord
Removes a cell from this row
removeColumn(int) - Method in class jxl.biff.SheetRangeImpl
A column has been removed, so adjust the range objects accordingly
removeColumn(int) - Method in interface jxl.write.WritableSheet
Removes a column from this spreadsheet.
removeColumn(int) - Method in class jxl.write.biff.HyperlinkRecord
A column has been removed, so adjust the range objects accordingly
removeColumn(int) - Method in class jxl.write.biff.RowRecord
Remove the new column at the position specified
removeColumn(int) - Method in class jxl.write.biff.WritableSheetImpl
Removes a column from this spreadsheet.
removeHyperlink(WritableHyperlink) - Method in interface jxl.write.WritableSheet
Removes the specified hyperlink.
removeHyperlink(WritableHyperlink) - Method in class jxl.write.biff.WritableSheetImpl
Removes the specified hyperlink.
removeHyperlink(WritableHyperlink, boolean) - Method in interface jxl.write.WritableSheet
Removes the specified hyperlink.
removeHyperlink(WritableHyperlink, boolean) - Method in class jxl.write.biff.WritableSheetImpl
Removes the specified hyperlink.
removeRow(int) - Method in class jxl.biff.SheetRangeImpl
A row has been removed, so adjust the range objects accordingly
removeRow(int) - Method in interface jxl.write.WritableSheet
Removes a row from this spreadsheet.
removeRow(int) - Method in class jxl.write.biff.HyperlinkRecord
A row has been removed, so adjust the range objects accordingly
removeRow(int) - Method in class jxl.write.biff.WritableSheetImpl
Removes a row from this spreadsheet.
removeSheet(int) - Method in class jxl.write.WritableWorkbook
Removes the sheet at the specified index from this workbook
removeSheet(int) - Method in class jxl.write.biff.WritableWorkbookImpl
Removes a sheet from this workbook, the other sheets indices being altered accordingly.
REPLACE - Static variable in class jxl.biff.formula.Function
 
replace(String, String, String) - Method in class jxl.biff.FormatRecord
Replaces all instances of search with replace in the input.
REPLACEB - Static variable in class jxl.biff.formula.Function
 
requiredSize - Variable in class jxl.write.biff.CompoundFile
The size the excel data should be in order to comply with the general compound file format
restorePos() - Method in class jxl.read.biff.File
Restores the original position These methods are used by the SheetImpl.readSheet() when it is reading in all the cell values
revertSharedFormula(BaseSharedFormulaRecord) - Method in class jxl.read.biff.SheetReader
Reverts the shared formula passed in to an ordinary formula and adds it to the list
RIGHT - Static variable in class jxl.biff.formula.Function
 
RIGHT - Static variable in class jxl.format.Border
 
RIGHT - Static variable in class jxl.format.Alignment
Data in cells with this alignment will be right aligned
RIGHTB - Static variable in class jxl.biff.formula.Function
 
rightBorder - Variable in class jxl.biff.XFRecord
The border indicator for the right of the cell
rightMargin - Variable in class jxl.SheetSettings
The margin from the right hand side of the paper in inches
RIGHTMARGIN - Static variable in class jxl.biff.Type
 
RightMarginRecord - class jxl.read.biff.RightMarginRecord.
Record for the left margin settings
RightMarginRecord - class jxl.write.biff.RightMarginRecord.
The settings for the left margin
RightMarginRecord(double) - Constructor for class jxl.write.biff.RightMarginRecord
 
RightMarginRecord(Record) - Constructor for class jxl.read.biff.RightMarginRecord
Constructor
RK - Static variable in class jxl.biff.Type
 
RK2 - Static variable in class jxl.biff.Type
 
RKHelper - class jxl.read.biff.RKHelper.
Helper to convert an RK number into a double or an integer
RKHelper() - Constructor for class jxl.read.biff.RKHelper
 
rknumbers - Variable in class jxl.read.biff.MulRKRecord
The array of rk numbers
rknumbers - Variable in class jxl.write.biff.MulRKRecord
The array of rk numbers
RKRecord - class jxl.read.biff.RKRecord.
An individual RK record
RKRecord(Record, FormattingRecords, SheetImpl) - Constructor for class jxl.read.biff.RKRecord
Constructs this object from the raw data
root - Variable in class jxl.biff.formula.TokenFormulaParser
The parse tree
root - Variable in class jxl.biff.formula.StringFormulaParser
The parse tree
ROOT_START_BLOCK_POS - Static variable in class jxl.biff.BaseCompoundFile
 
rootEntry - Variable in class jxl.read.biff.CompoundFile
The root entry
rootStartBlock - Variable in class jxl.read.biff.CompoundFile
The start block of the root entry
rootStartBlock - Variable in class jxl.write.biff.CompoundFile
The start block of the root entry
ROSE - Static variable in class jxl.format.Colour
 
ROUND - Static variable in class jxl.biff.formula.Function
 
ROUNDDOWN - Static variable in class jxl.biff.formula.Function
 
ROUNDUP - Static variable in class jxl.biff.formula.Function
 
row - Variable in class jxl.biff.EmptyCell
The row of this empty cell
row - Variable in class jxl.biff.formula.CellReference3d
The row reference
row - Variable in class jxl.biff.formula.CellReference
The row reference
row - Variable in class jxl.biff.formula.SharedFormulaCellReference
The row reference
row - Variable in class jxl.read.biff.DateRecord
The row number of this cell record
row - Variable in class jxl.read.biff.CellValue
The row number of this cell record
row - Variable in class jxl.read.biff.NumberValue
The row containing this number
row - Variable in class jxl.read.biff.MulBlankCell
The row containing this blank
row - Variable in class jxl.read.biff.MulRKRecord
The row containing these numbers
row - Variable in class jxl.read.biff.MulBlankRecord
The row containing these numbers
row - Variable in class jxl.write.biff.CellValue
The row in the worksheet at which this cell is located
row - Variable in class jxl.write.biff.MulRKRecord
The row containing these numbers
ROW - Static variable in class jxl.biff.Type
 
ROW - Static variable in class jxl.biff.formula.Function
 
row1 - Variable in class jxl.biff.SheetRangeImpl
The row number of the cell at the top left of the range
row1 - Variable in class jxl.read.biff.RangeImpl
The row number of the cell at the top left of the range
row2 - Variable in class jxl.biff.SheetRangeImpl
The row index of the cell at the bottom right
row2 - Variable in class jxl.read.biff.RangeImpl
The row index of the cell at the bottom right
rowBreaks - Variable in class jxl.read.biff.SheetImpl
The horizontal page breaks contained on this sheet
rowBreaks - Variable in class jxl.read.biff.HorizontalPageBreaksRecord
The row page breaks
rowBreaks - Variable in class jxl.read.biff.SheetReader
The horizontal page breaks contained on this sheet
rowBreaks - Variable in class jxl.write.biff.SheetWriter
Array of row page breaks
rowBreaks - Variable in class jxl.write.biff.WritableSheetImpl
Array of row page breaks
rowBreaks - Variable in class jxl.write.biff.HorizontalPageBreaksRecord
The row breaks
rowFirst - Variable in class jxl.biff.formula.Area3d
 
rowFirst - Variable in class jxl.biff.formula.SharedFormulaArea
 
rowFirst - Variable in class jxl.biff.formula.Area
 
rowFirst - Variable in class jxl.read.biff.NameRecord.NameRange
 
rowFirstRelative - Variable in class jxl.biff.formula.Area3d
 
rowFirstRelative - Variable in class jxl.biff.formula.SharedFormulaArea
 
rowFirstRelative - Variable in class jxl.biff.formula.Area
 
rowGrowSize - Static variable in class jxl.write.biff.WritableSheetImpl
The amount by which to grow the rows array
rowGutter - Variable in class jxl.write.biff.GuttersRecord
The rowGutter
rowHeight - Variable in class jxl.read.biff.RowRecord
The height of this row
rowHeight - Variable in class jxl.write.biff.RowRecord
The height of this row
rowHeight - Variable in class jxl.write.biff.DefaultRowHeightRecord
The default row height
rowLast - Variable in class jxl.biff.formula.Area3d
 
rowLast - Variable in class jxl.biff.formula.SharedFormulaArea
 
rowLast - Variable in class jxl.biff.formula.Area
 
rowLast - Variable in class jxl.read.biff.NameRecord.NameRange
 
rowLastRelative - Variable in class jxl.biff.formula.Area3d
 
rowLastRelative - Variable in class jxl.biff.formula.SharedFormulaArea
 
rowLastRelative - Variable in class jxl.biff.formula.Area
 
rowNumber - Variable in class jxl.read.biff.RowRecord
The number of this row
rowNumber - Variable in class jxl.write.biff.RowRecord
The number of this row within the worksheet
rowPos - Variable in class jxl.write.biff.DBCellRecord
The file position of the first Row record in this block
rowProperties - Variable in class jxl.read.biff.SheetImpl
The list of non-default row properties
rowProperties - Variable in class jxl.read.biff.SheetReader
The list of non-default row properties
RowRecord - class jxl.read.biff.RowRecord.
A row record
RowRecord - class jxl.write.biff.RowRecord.
Contains all the cells for a given row in a sheet
RowRecord(int) - Constructor for class jxl.write.biff.RowRecord
Constructs an empty row which has the specified row number
RowRecord(Record) - Constructor for class jxl.read.biff.RowRecord
Constructs this object from the raw data
rowRecords - Variable in class jxl.read.biff.SheetImpl
The array of row records
rowRecordsInitialized - Variable in class jxl.read.biff.SheetImpl
Indicates whether the rowRecords array has been initialized
rowRelative - Variable in class jxl.biff.formula.CellReference3d
Indicates whether the row reference is relative or absolute
rowRelative - Variable in class jxl.biff.formula.CellReference
Indicates whether the row reference is relative or absolute
rowRelative - Variable in class jxl.biff.formula.SharedFormulaCellReference
Indicates whether the row reference is relative or absolute
rows - Variable in class jxl.write.biff.SheetWriter
The rows within this sheet
rows - Variable in class jxl.write.biff.WritableSheetImpl
The rows within this sheet
rows - Variable in class jxl.write.biff.IndexRecord
The numbe of rows served by this index record
ROWS - Static variable in class jxl.biff.formula.Function
 
RowsExceededException - exception jxl.write.biff.RowsExceededException.
Exception thrown when attempting to add a row to a spreadsheet which has already reached the maximum amount
RowsExceededException() - Constructor for class jxl.write.biff.RowsExceededException
Constructor
RSQ - Static variable in class jxl.biff.formula.Function
 
RSTRING - Static variable in class jxl.biff.Type
 
RStringRecord - class jxl.read.biff.RStringRecord.
A label which is stored in the cell
RStringRecord.Biff7 - class jxl.read.biff.RStringRecord.Biff7.
Dummy indicators for overloading the constructor
RStringRecord.Biff7() - Constructor for class jxl.read.biff.RStringRecord.Biff7
 
RStringRecord(Record, FormattingRecords, SheetImpl, RStringRecord.Biff7) - Constructor for class jxl.read.biff.RStringRecord
Constructs this object from the raw data

S

SAVERECALC - Static variable in class jxl.biff.Type
 
SaveRecalcRecord - class jxl.write.biff.SaveRecalcRecord.
Stores the recalculate before save flag as set in the options dialog box
SaveRecalcRecord(boolean) - Constructor for class jxl.write.biff.SaveRecalcRecord
Constructor
sbdStartBlock - Variable in class jxl.read.biff.CompoundFile
The start block of the small block depot
scaleFactor - Variable in class jxl.SheetSettings
The scale factor used when printing
scaleFactor - Variable in class jxl.read.biff.SetupRecord
The scale factor
scaleFactor - Variable in class jxl.write.biff.SetupRecord
The scale factor
scriptStyle - Variable in class jxl.biff.FontRecord
The style of the script (italic or normal)
ScriptStyle - class jxl.format.ScriptStyle.
Enumeration class which contains the various script styles available within the standard Excel ScriptStyle palette
ScriptStyle(int, String) - Constructor for class jxl.format.ScriptStyle
Private constructor
SEARCHB - Static variable in class jxl.biff.formula.Function
 
SECOND - Static variable in class jxl.biff.formula.Function
 
selected - Variable in class jxl.SheetSettings
Indicates whether or not this sheet is selected
SELECTION - Static variable in class jxl.biff.Type
 
SelectionRecord - class jxl.write.biff.SelectionRecord.
Stores the current selection
SelectionRecord() - Constructor for class jxl.write.biff.SelectionRecord
Constructor
setAlignment(Alignment) - Method in class jxl.biff.EmptyCell
 
setAlignment(Alignment) - Method in class jxl.write.WritableCellFormat
Sets the horizontal alignment for this format
setAlignment(Alignment) - Method in class jxl.write.biff.CellXFRecord
Sets the alignment for the cell
setArrayGrowSize(int) - Method in class jxl.WorkbookSettings
Sets the amount of memory by which to increase the amount of memory allocated to storing the workbook data.
setBackground(Colour) - Method in class jxl.write.WritableCellFormat
Sets the background colour for this cell format
setBackground(Colour, Pattern) - Method in class jxl.write.WritableCellFormat
Sets the background colour and pattern for this cell format
setBackground(Colour, Pattern) - Method in class jxl.write.biff.CellXFRecord
Sets the background for the cell
setBoldStyle(int) - Method in class jxl.write.biff.WritableFontRecord
Sets the bold style for this font, if the font hasn't been initialized
setBoldStyle(WritableFont.BoldStyle) - Method in class jxl.write.WritableFont
Sets the bold style for this font, if the font hasn't been initialized
setBorder(Border, BorderLineStyle) - Method in class jxl.biff.EmptyCell
 
setBorder(Border, BorderLineStyle) - Method in class jxl.write.WritableCellFormat
Sets the specified border for this format
setBorder(Border, BorderLineStyle) - Method in class jxl.write.biff.CellXFRecord
Sets the border style for cells with this format
setBottomMargin(double) - Method in class jxl.SheetSettings
Sets the bottom margin
setCellDetails(FormattingRecords, SharedStrings, WritableSheetImpl) - Method in class jxl.write.biff.CellValue
Called when the cell is added to the worksheet in order to indicate that this object is already added to the worksheet This method also verifies that the associated formats and formats have been initialized correctly
setCellDetails(FormattingRecords, SharedStrings, WritableSheetImpl) - Method in class jxl.write.biff.LabelRecord
Overrides the method in the base class in order to add the string content to the shared string table, and to store its shared string index
setCellFormat(CellFormat) - Method in class jxl.biff.EmptyCell
 
setCellFormat(CellFormat) - Method in class jxl.biff.EmptyCell
Deprecated.  
setCellFormat(CellFormat) - Method in interface jxl.write.WritableCell
Sets the cell format for this cell
setCellFormat(CellFormat) - Method in class jxl.write.biff.CellValue
An API function which sets the format to apply to this cell
setCellOffset(int) - Method in class jxl.write.biff.DBCellRecord
Sets the offset of this cell record within the sheet stream
setCellOptions(int) - Method in class jxl.write.biff.StyleXFRecord
Sets the raw cell options.
setCharts(Chart[]) - Method in class jxl.write.biff.SheetWriter
 
setCollapsed(boolean) - Method in class jxl.write.biff.RowRecord
Sets the collapsed status of this row
setColour(Colour) - Method in class jxl.write.WritableFont
Sets the colour for this font, if the font hasn't been initialized
setColour(int) - Method in class jxl.write.biff.WritableFontRecord
Sets the colour for this font, if the font hasn't been initialized
setColumnView(int, int) - Method in interface jxl.write.WritableSheet
Sets the width of the column on this sheet, in characters.
setColumnView(int, int) - Method in class jxl.write.biff.WritableSheetImpl
Sets the width (in characters) for a particular column in this sheet
setColumnView(int, int, CellFormat) - Method in interface jxl.write.WritableSheet
Sets the width and style of every cell in the specified column.
setColumnView(int, int, CellFormat) - Method in class jxl.write.biff.WritableSheetImpl
Sets the width (in characters) and format options for a particular column in this sheet
setData(byte[], int) - Method in class jxl.write.biff.File
Used to manually alter the contents of the written out data.
setDataStartPosition(int) - Method in class jxl.write.biff.IndexRecord
Sets the position of the data start.
setDate(Date) - Method in class jxl.write.DateTime
Sets the date for this cell
setDate(Date) - Method in class jxl.write.biff.DateRecord
Sets the date in this cell
setDate(Date, DateRecord.GMTDate) - Method in class jxl.write.DateTime
Sets the date for this cell, performing the necessary timezone adjustments
setDate(Date, DateRecord.GMTDate) - Method in class jxl.write.biff.DateRecord
Sets the date in this cell, taking the timezone into account
setDimensions(int, int) - Method in class jxl.write.biff.SheetWriter
Sets the dimensions of this spreadsheet.
setDirectory(int) - Method in class jxl.biff.BaseCompoundFile.PropertyStorage
Sets the directory
setFile(File) - Method in class jxl.write.WritableHyperlink
Sets the file activated by this hyperlink
setFile(File) - Method in class jxl.write.biff.HyperlinkRecord
Sets the file activated by this hyperlink
setFirstString(String, boolean) - Method in class jxl.write.biff.SSTContinueRecord
Adds the first string to this SST record
setFitHeight(int) - Method in class jxl.SheetSettings
Sets the number of pages vertically that this sheet will be printed into
setFitWidth(int) - Method in class jxl.SheetSettings
Sets the number of pages widthwise which this sheet should be printed into
setFontBoldStyle(int) - Method in class jxl.biff.FontRecord
Sets the bold style for this font, if the font hasn't been initialized
setFontColour(int) - Method in class jxl.biff.FontRecord
Sets the colour for this font, if the font hasn't been initialized
setFontItalic(boolean) - Method in class jxl.biff.FontRecord
Sets the italic indicator for this font, if the font hasn't been initialized
setFontPointSize(int) - Method in class jxl.biff.FontRecord
Sets the point size for this font, if the font hasn't been initialized
setFontScriptStyle(int) - Method in class jxl.biff.FontRecord
Sets the script style (eg.
setFontUnderlineStyle(int) - Method in class jxl.biff.FontRecord
Sets the underline style for this font, if the font hasn't been initialized
setFooter(FooterRecord) - Method in class jxl.write.biff.SheetWriter
 
setFooter(String, String, String) - Method in interface jxl.write.WritableSheet
Sets the footer for this page
setFooter(String, String, String) - Method in class jxl.write.biff.WritableSheetImpl
Sets the footer for this page
setFooterMargin(double) - Method in class jxl.SheetSettings
Sets the margin for any page footer
setFormatString(String) - Method in class jxl.biff.FormatRecord
Called by the immediate subclass to set the string once the Java-Excel replacements have been done
setHeader(HeaderRecord) - Method in class jxl.write.biff.SheetWriter
 
setHeader(String, String, String) - Method in interface jxl.write.WritableSheet
Sets the header for this page
setHeader(String, String, String) - Method in class jxl.write.biff.WritableSheetImpl
Sets the header for this page
setHeaderMargin(double) - Method in class jxl.SheetSettings
Sets the margin for any page headers
setHidden(boolean) - Method in class jxl.SheetSettings
Sets the hidden status of this worksheet
setHidden(boolean) - Method in class jxl.biff.EmptyCell
 
setHidden(boolean) - Method in class jxl.read.biff.SheetImpl
Sets the visibility of this sheet
setHidden(boolean) - Method in interface jxl.write.WritableSheet
Indicates whether or not this sheet is hidden
setHidden(boolean) - Method in class jxl.write.biff.WritableSheetImpl
Sets the hidden status of this sheet
setHorizontalPrintResolution(int) - Method in class jxl.SheetSettings
Sets the horizontal print resolution
setIfConditions(VariableArgFunction) - Method in class jxl.biff.formula.Attribute
Sets the if conditions for this attribute, if it represents an IF function
setInitialFileSize(int) - Method in class jxl.WorkbookSettings
Sets the initial amount of memory allocated to store the workbook data when reading a worksheet.
setItalic(boolean) - Method in class jxl.write.WritableFont
Sets the italic indicator for this font, if the font hasn't been initialized
setItalic(boolean) - Method in class jxl.write.biff.WritableFontRecord
Sets the italic indicator for this font, if the font hasn't been initialized
setLeftMargin(double) - Method in class jxl.SheetSettings
Sets the left margin
setLocation(String, WritableSheet, int, int, int, int) - Method in class jxl.write.WritableHyperlink
Sets the location of the cells to be linked to within this workbook
setLocation(String, WritableSheet, int, int, int, int) - Method in class jxl.write.biff.HyperlinkRecord
Sets the location of the cells to be linked to within this workbook
setLocation(WritableSheet, int, int, int, int) - Method in class jxl.write.biff.HyperlinkRecord
Initializes the location from the data passed in
setLocked(boolean) - Method in class jxl.biff.XFRecord
Sets whether or not this XF record locks the cell
setLocked(boolean) - Method in class jxl.biff.EmptyCell
 
setMargins(double, double) - Method in class jxl.write.biff.SetupRecord
Sets the header and footer margins
setName(String) - Method in class jxl.read.biff.SheetImpl
Sets the name of this sheet
setName(String) - Method in interface jxl.write.WritableSheet
Sets the name of this sheet
setName(String) - Method in class jxl.write.biff.WritableSheetImpl
Sets the name of this worksheet
setNext(int) - Method in class jxl.biff.BaseCompoundFile.PropertyStorage
Sets the next block
setNumberFormat(NumberFormat) - Method in class jxl.read.biff.NumberValue
Sets the format for the number based on the Excel spreadsheets' format.
setNumberFormat(NumberFormat) - Method in class jxl.read.biff.SharedNumberFormulaRecord
Sets the format for the number based on the Excel spreadsheets' format.
setOrientation(Orientation) - Method in class jxl.write.WritableCellFormat
Sets the text orientation for this format
setOrientation(Orientation) - Method in class jxl.write.biff.CellXFRecord
Sets the text orientation for cells with this style
setOrientation(PageOrientation) - Method in class jxl.SheetSettings
Sets the paper orientation for printing this sheet
setOrientation(PageOrientation) - Method in class jxl.write.biff.SetupRecord
Sets the orientation
setPageSetup(PageOrientation) - Method in interface jxl.write.WritableSheet
Sets the page setup details
setPageSetup(PageOrientation) - Method in class jxl.write.biff.WritableSheetImpl
Deprecated. use the SheetSettings bean
setPageSetup(PageOrientation, double, double) - Method in interface jxl.write.WritableSheet
Sets the page setup details
setPageSetup(PageOrientation, double, double) - Method in class jxl.write.biff.WritableSheetImpl
Deprecated. use the SheetSettings bean
setPageSetup(PageOrientation, PaperSize, double, double) - Method in interface jxl.write.WritableSheet
Sets the page setup details
setPageSetup(PageOrientation, PaperSize, double, double) - Method in class jxl.write.biff.WritableSheetImpl
Deprecated. use the SheetSettings bean
setPageStart(int) - Method in class jxl.SheetSettings
Sets the page number at which to commence printing
setPaperSize(PaperSize) - Method in class jxl.SheetSettings
Sets the paper size to be used when printing this sheet
setPaperSize(PaperSize) - Method in class jxl.write.biff.SetupRecord
Sets the paper size
setParent(ParseItem) - Method in class jxl.biff.formula.ParseItem
Called by this class to initialize the parent
setPointSize(int) - Method in class jxl.write.WritableFont
Sets the point size for this font, if the font hasn't been initialized
setPointSize(int) - Method in class jxl.write.biff.WritableFontRecord
Sets the point size for this font, if the font hasn't been initialized
setPos(int) - Method in class jxl.read.biff.File
Saves the current position and temporarily sets the position to be the new one.
setPosition(int) - Method in class jxl.write.biff.DBCellRecord
Sets the position of this cell within the sheet stream
setPrevious(int) - Method in class jxl.biff.BaseCompoundFile.PropertyStorage
Sets the previous block
setProtected(boolean) - Method in class jxl.SheetSettings
Sets the protected (ie.
setProtected(boolean) - Method in class jxl.write.WritableWorkbook
Indicates whether or not this workbook is protected
setProtected(boolean) - Method in interface jxl.write.WritableSheet
Indicates whether or not this sheet is protected
setProtected(boolean) - Method in class jxl.write.biff.WritableSheetImpl
Deprecated. use the settings bean
setProtected(boolean) - Method in class jxl.write.biff.WritableWorkbookImpl
Indicates whether or not this workbook is protected
setRightMargin(double) - Method in class jxl.SheetSettings
Sets the right margin
setRowDetails(int, boolean) - Method in class jxl.write.biff.RowRecord
Sets the row details based upon the readable row record passed in Called when copying spreadsheets
setRowHeight(int) - Method in class jxl.write.biff.RowRecord
Sets the height of this row
setRowView(int, boolean) - Method in interface jxl.write.WritableSheet
Sets the properties of the specified row
setRowView(int, boolean) - Method in class jxl.write.biff.WritableSheetImpl
Sets the height of the specified row, as well as its collapse status
setRowView(int, int) - Method in interface jxl.write.WritableSheet
Sets the height of the specified row, as well as its collapse status
setRowView(int, int) - Method in class jxl.write.biff.WritableSheetImpl
Sets the height of the specified row, as well as its collapse status
setRowView(int, int, boolean) - Method in interface jxl.write.WritableSheet
Sets the height of the specified row, as well as its collapse status
setRowView(int, int, boolean) - Method in class jxl.write.biff.WritableSheetImpl
Sets the height of the specified row, as well as its collapse status
setScaleFactor(int) - Method in class jxl.SheetSettings
Sets the scale factor for this sheet to be used when printing.
setScriptStyle(int) - Method in class jxl.write.biff.WritableFontRecord
Sets the script style (eg.
setScriptStyle(ScriptStyle) - Method in class jxl.write.WritableFont
Sets the script style (eg.
setSelected() - Method in class jxl.SheetSettings
Sets this sheet to be when it is opened in excel
setSelected() - Method in class jxl.write.biff.WritableSheetImpl
Deprecated. use the settings bean
setSettings(SheetSettings) - Method in class jxl.write.biff.SheetWriter
Sets the sheet settings for this particular sheet.
setSize(int) - Method in class jxl.biff.BaseCompoundFile.PropertyStorage
Sets the size of the file
setStartBlock(int) - Method in class jxl.biff.BaseCompoundFile.PropertyStorage
Sets the number of the start block
setString(String) - Method in class jxl.write.Label
Sets the string contents of this cell
setString(String) - Method in class jxl.write.biff.LabelRecord
Sets the string contents of this cell
settings - Variable in class jxl.read.biff.SheetImpl
The sheet settings
settings - Variable in class jxl.read.biff.SheetReader
The sheet settings
settings - Variable in class jxl.write.biff.SheetWriter
The settings for the sheet
settings - Variable in class jxl.write.biff.WritableSheetImpl
The settings for this sheet
setTokens(byte[]) - Method in class jxl.read.biff.BaseSharedFormulaRecord
Called by the shared formula record to set the tokens for this formula
setTopMargin(double) - Method in class jxl.SheetSettings
Sets the top margin
setType(int) - Method in class jxl.biff.BaseCompoundFile.PropertyStorage
Sets the type
setUnderlineStyle(int) - Method in class jxl.write.biff.WritableFontRecord
Sets the underline style for this font, if the font hasn't been initialized
setUnderlineStyle(UnderlineStyle) - Method in class jxl.write.WritableFont
Sets the underline style for this font, if the font hasn't been initialized
SETUP - Static variable in class jxl.biff.Type
 
SetupRecord - class jxl.read.biff.SetupRecord.
Contains the page set up for a sheet
SetupRecord - class jxl.write.biff.SetupRecord.
Stores the options and measurements from the Page Setup dialog box
SetupRecord() - Constructor for class jxl.write.biff.SetupRecord
Deprecated. in favour of the sheet settings constructor
SetupRecord(Record) - Constructor for class jxl.read.biff.SetupRecord
Constructor which creates this object from the binary data
SetupRecord(SetupRecord) - Constructor for class jxl.write.biff.SetupRecord
Deprecated. in favour of the SheetSettings constructor
SetupRecord(SheetSettings) - Constructor for class jxl.write.biff.SetupRecord
Constructor, taking the sheet settings.
setURL(URL) - Method in class jxl.write.WritableHyperlink
Sets the URL of this hyperlink
setURL(URL) - Method in class jxl.write.biff.HyperlinkRecord
Sets the URL of this hyperlink
setValue(boolean) - Method in class jxl.write.Boolean
Sets the boolean value for this cell
setValue(boolean) - Method in class jxl.write.biff.BooleanRecord
Sets the value
setValue(double) - Method in class jxl.write.Number
Sets the numerical value for this cell
setValue(double) - Method in class jxl.write.biff.NumberRecord
Sets the value of the contents for this cell
setVerticalAlignment(VerticalAlignment) - Method in class jxl.biff.EmptyCell
 
setVerticalAlignment(VerticalAlignment) - Method in class jxl.write.WritableCellFormat
Sets the vertical alignment for this format
setVerticalAlignment(VerticalAlignment) - Method in class jxl.write.biff.CellXFRecord
Sets the vertical alignment for cells with this style
setVerticalPrintResolution(int) - Method in class jxl.SheetSettings
Sets the vertical print reslution
setWorkspaceOptions(int) - Method in class jxl.write.biff.SheetWriter
 
setWrap(boolean) - Method in class jxl.write.WritableCellFormat
Sets the wrap indicator for this format.
setWrap(boolean) - Method in class jxl.write.biff.CellXFRecord
Sets the text wrapping for cells with this style.
setWriteData(RowRecord[], ArrayList, ArrayList, ArrayList, TreeSet) - Method in class jxl.write.biff.SheetWriter
Sets the data necessary for writing out the sheet.
setXFAlignment(Alignment) - Method in class jxl.biff.XFRecord
Sets the horizontal alignment for the data in this cell.
setXFBackground(Colour, Pattern) - Method in class jxl.biff.XFRecord
Sets the horizontal alignment for the data in this cell.
setXFBorder(Border, BorderLineStyle) - Method in class jxl.biff.XFRecord
Sets the border for this cell This method should only be called from its writable subclass CellXFRecord
setXFCellOptions(int) - Method in class jxl.biff.XFRecord
Sets the raw cell options
setXFOrientation(Orientation) - Method in class jxl.biff.XFRecord
Sets the vertical alignment for the data in this cell This method should only be called from its writable subclass CellXFRecord
setXFVerticalAlignment(VerticalAlignment) - Method in class jxl.biff.XFRecord
Sets the vertical alignment for the data in this cell This method should only be called from its writable subclass CellXFRecord
setXFWrap(boolean) - Method in class jxl.biff.XFRecord
Sets whether the data in this cell is wrapped This method should only be called from its writable subclass CellXFRecord
shared - Variable in class jxl.read.biff.FormulaRecord
Flag to indicate whether this is a shared formula
SharedDateFormulaRecord - class jxl.read.biff.SharedDateFormulaRecord.
A number formula record, manufactured out of the Shared Formula "optimization"
SharedDateFormulaRecord(SharedNumberFormulaRecord, FormattingRecords, boolean, SheetImpl) - Constructor for class jxl.read.biff.SharedDateFormulaRecord
Constructs this number
SHAREDFORMULA - Static variable in class jxl.biff.Type
 
SharedFormulaArea - class jxl.biff.formula.SharedFormulaArea.
A cell reference in a formula
SharedFormulaArea(Cell) - Constructor for class jxl.biff.formula.SharedFormulaArea
Constructor
SharedFormulaCellReference - class jxl.biff.formula.SharedFormulaCellReference.
A cell reference in a formula
SharedFormulaCellReference(Cell) - Constructor for class jxl.biff.formula.SharedFormulaCellReference
Constructor
SharedFormulaRecord - class jxl.read.biff.SharedFormulaRecord.
A shared formula
SharedFormulaRecord(Record, BaseSharedFormulaRecord, ExternalSheet, SheetImpl) - Constructor for class jxl.read.biff.SharedFormulaRecord
Constructs this object from the raw data.
sharedFormulas - Variable in class jxl.read.biff.SheetImpl
A list of shared formula groups
sharedFormulas - Variable in class jxl.read.biff.SheetReader
A list of shared formula groups
SharedNumberFormulaRecord - class jxl.read.biff.SharedNumberFormulaRecord.
A number formula record, manufactured out of the Shared Formula "optimization"
SharedNumberFormulaRecord(Record, double, FormattingRecords, ExternalSheet, SheetImpl) - Constructor for class jxl.read.biff.SharedNumberFormulaRecord
Constructs this number
SharedStringFormulaRecord - class jxl.read.biff.SharedStringFormulaRecord.
A string formula record, manufactured out of the Shared Formula "optimization"
SharedStringFormulaRecord(Record, File, FormattingRecords, ExternalSheet, SheetImpl) - Constructor for class jxl.read.biff.SharedStringFormulaRecord
Constructs this string formula
sharedStrings - Variable in class jxl.read.biff.SheetImpl
A handle to the shared string table
sharedStrings - Variable in class jxl.read.biff.WorkbookParser
The shared string table
sharedStrings - Variable in class jxl.read.biff.SheetReader
A handle to the shared string table
sharedStrings - Variable in class jxl.write.biff.LabelRecord
A handle to the shared strings used within this workbook
sharedStrings - Variable in class jxl.write.biff.WritableSheetImpl
A handle to the shared strings used by this workbook
sharedStrings - Variable in class jxl.write.biff.WritableWorkbookImpl
The shared strings used by this workbook
SharedStrings - class jxl.write.biff.SharedStrings.
The list of available shared strings.
SharedStrings() - Constructor for class jxl.write.biff.SharedStrings
Constructor
sheet - Variable in class jxl.biff.SheetRangeImpl
A handle to the sheet containing this range
sheet - Variable in class jxl.biff.formula.Area3d
 
sheet - Variable in class jxl.biff.formula.CellReference3d
The sheet which the reference is present on
sheet - Variable in class jxl.read.biff.DateRecord
A handle to the sheet
sheet - Variable in class jxl.read.biff.CellValue
A handle back to the sheet
sheet - Variable in class jxl.read.biff.NumberValue
A handle to the sheet
sheet - Variable in class jxl.read.biff.MulBlankCell
A handle to the sheet
sheet - Variable in class jxl.read.biff.SharedFormulaRecord
A handle to the sheet
sheet - Variable in class jxl.read.biff.SheetReader
A handle to the sheet
sheet - Variable in class jxl.write.biff.CellValue
A handle to the sheet
sheet - Variable in class jxl.write.biff.HyperlinkRecord
The sheet containing this hyperlink
sheet - Static variable in class jxl.write.biff.BOFRecord
 
sheet - Variable in class jxl.write.biff.SheetWriter
A handle back to the writable sheet, in order for this class to invoke the get accessor methods
sheet - Variable in class jxl.write.biff.MergedCellsRecord
The sheet containing this hyperlink
Sheet - interface jxl.Sheet.
Represents a sheet within a workbook.
sheet1 - Variable in class jxl.read.biff.RangeImpl
The sheet index containing the column at the top left
sheet2 - Variable in class jxl.read.biff.RangeImpl
The sheet index of the cell at the bottom right
sheetBof - Variable in class jxl.read.biff.SheetImpl
A handle to the sheet BOF record, which indicates the stream type
sheetFirst - Variable in class jxl.read.biff.NameRecord.NameRange
 
SheetImpl - class jxl.read.biff.SheetImpl.
Represents a sheet within a workbook.
SheetImpl(File, SSTRecord, FormattingRecords, BOFRecord, BOFRecord, boolean, WorkbookParser) - Constructor for class jxl.read.biff.SheetImpl
Constructor
sheetLast - Variable in class jxl.read.biff.NameRecord.NameRange
 
sheetNames - Variable in class jxl.read.biff.SupbookRecord
The names of the external sheets
sheetNames - Variable in class jxl.write.biff.SupbookRecord
The names of the external sheets
sheetProtected - Variable in class jxl.SheetSettings
Indicates whether or not this sheet is protected
SheetRangeImpl - class jxl.biff.SheetRangeImpl.
Implementation class for the Range interface.
SheetRangeImpl(Sheet, int, int, int, int) - Constructor for class jxl.biff.SheetRangeImpl
Constructor
SheetRangeImpl(SheetRangeImpl, Sheet) - Constructor for class jxl.biff.SheetRangeImpl
A copy constructor used for copying ranges between sheets
SheetReader - class jxl.read.biff.SheetReader.
Reads the sheet.
SheetReader(File, SSTRecord, FormattingRecords, BOFRecord, boolean, WorkbookParser, int, SheetImpl) - Constructor for class jxl.read.biff.SheetReader
Constructor
sheets - Variable in class jxl.read.biff.WorkbookParser
The sheets contained in this workbook
sheets - Variable in class jxl.write.biff.WritableWorkbookImpl
The list of sheets within this workbook
SheetSettings - class jxl.SheetSettings.
This is a bean which client applications may use to get/set various properties which are associated with a particular worksheet, such as headers and footers, page orientation etc.
SheetSettings() - Constructor for class jxl.SheetSettings
Default constructor
SheetSettings(SheetSettings) - Constructor for class jxl.SheetSettings
Copy constructor.
sheetWriter - Variable in class jxl.write.biff.WritableSheetImpl
The sheet writer engine
SheetWriter - class jxl.write.biff.SheetWriter.
Contains the functionality necessary for writing out a sheet.
SheetWriter(File, WritableSheetImpl) - Constructor for class jxl.write.biff.SheetWriter
Creates a new SheetWriter instance.
SIGN - Static variable in class jxl.biff.formula.Function
 
SIN - Static variable in class jxl.biff.formula.Function
 
SINGLE - Static variable in class jxl.format.UnderlineStyle
 
SINGLE - Static variable in class jxl.write.Font
Deprecated.  
SINGLE_ACCOUNTING - Static variable in class jxl.format.UnderlineStyle
 
SINGLE_ACCOUNTING - Static variable in class jxl.write.Font
Deprecated.  
SINH - Static variable in class jxl.biff.formula.Function
 
size - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The size, in bytes, of this property set
size - Variable in class jxl.write.biff.CompoundFile
The size of the array
SIZE_OF_NAME_POS - Static variable in class jxl.biff.BaseCompoundFile
 
SIZE_POS - Static variable in class jxl.biff.BaseCompoundFile
 
SKEW - Static variable in class jxl.biff.formula.Function
 
skip(int) - Method in class jxl.read.biff.File
Skips forward the specified number of bytes
SKY_BLUE - Static variable in class jxl.format.Colour
 
SLANTED_DASH_DOT - Static variable in class jxl.format.BorderLineStyle
 
SLN - Static variable in class jxl.biff.formula.Function
 
SLOPE - Static variable in class jxl.biff.formula.Function
 
SMALL - Static variable in class jxl.biff.formula.Function
 
SMALL_BLOCK_DEPOT_BLOCK_POS - Static variable in class jxl.biff.BaseCompoundFile
 
SMALL_BLOCK_SIZE - Static variable in class jxl.biff.BaseCompoundFile
 
SMALL_BLOCK_THRESHOLD - Static variable in class jxl.biff.BaseCompoundFile
 
smallBlockChain - Variable in class jxl.read.biff.CompoundFile
The sequence of blocks which comprise the small block chain
SOLID - Static variable in class jxl.format.Pattern
 
SQRT - Static variable in class jxl.biff.formula.Function
 
SST - Static variable in class jxl.biff.Type
 
SSTContinueRecord - class jxl.write.biff.SSTContinueRecord.
A continuation of a shared string table record.
SSTContinueRecord() - Constructor for class jxl.write.biff.SSTContinueRecord
Constructor
SSTRecord - class jxl.read.biff.SSTRecord.
Holds all the strings in the shared string table
SSTRecord - class jxl.write.biff.SSTRecord.
A shared string table record.
SSTRecord.BooleanHolder - class jxl.read.biff.SSTRecord.BooleanHolder.
A holder for a boolean
SSTRecord.BooleanHolder() - Constructor for class jxl.read.biff.SSTRecord.BooleanHolder
 
SSTRecord.ByteArrayHolder - class jxl.read.biff.SSTRecord.ByteArrayHolder.
A holder for a byte array
SSTRecord.ByteArrayHolder() - Constructor for class jxl.read.biff.SSTRecord.ByteArrayHolder
 
SSTRecord(int, int) - Constructor for class jxl.write.biff.SSTRecord
Constructor
SSTRecord(Record, Record[]) - Constructor for class jxl.read.biff.SSTRecord
Constructs this object from the raw data
STANDARDIZE - Static variable in class jxl.biff.formula.Function
 
START_BLOCK_POS - Static variable in class jxl.biff.BaseCompoundFile
 
startBlock - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The block number in the stream which this property sets starts at
startColumn - Variable in class jxl.read.biff.ColumnInfoRecord
The start for which to apply the format information
startpos - Variable in class jxl.biff.chart.Chart
The start pos of the chart bof stream in the data file
startPosition - Variable in class jxl.read.biff.SheetImpl
The start position in the stream of this sheet
startPosition - Variable in class jxl.read.biff.SheetReader
The start position in the stream of this sheet
STDEV - Static variable in class jxl.biff.formula.Function
 
STDEVA - Static variable in class jxl.biff.formula.Function
 
STDEVP - Static variable in class jxl.biff.formula.Function
 
STDEVPA - Static variable in class jxl.biff.formula.Function
 
STEYX - Static variable in class jxl.biff.formula.Function
 
streamNotFound - Static variable in class jxl.read.biff.BiffException
 
string - Variable in class jxl.biff.formula.Function
The string value of this function
string - Variable in class jxl.format.Colour
The display string for the colour.
string - Variable in class jxl.format.Border
The string description
string - Variable in class jxl.format.BorderLineStyle
The string description
string - Variable in class jxl.format.UnderlineStyle
The display string for the underline style.
string - Variable in class jxl.format.ScriptStyle
The display string for the script style.
string - Variable in class jxl.format.Orientation
The textual description
string - Variable in class jxl.format.Alignment
The string description of this alignment
string - Variable in class jxl.format.Pattern
The textual description
string - Variable in class jxl.format.BoldStyle
The description
string - Variable in class jxl.format.VerticalAlignment
The textual description
string - Variable in class jxl.read.biff.LabelRecord
The label
string - Variable in class jxl.read.biff.LabelSSTRecord
The label
string - Variable in class jxl.read.biff.RStringRecord
The label
STRING - Static variable in class jxl.biff.Type
 
STRING - Static variable in class jxl.biff.formula.Token
 
STRING_FORMULA - Static variable in class jxl.CellType
 
StringFormulaCell - interface jxl.StringFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for strings
StringFormulaParser - class jxl.biff.formula.StringFormulaParser.
Parses a string formula into a parse tree
StringFormulaParser(String) - Constructor for class jxl.biff.formula.StringFormulaParser
Constructor
StringFormulaRecord - class jxl.read.biff.StringFormulaRecord.
A string formula's last calculated value
StringFormulaRecord(Record, File, FormattingRecords, ExternalSheet, SheetImpl) - Constructor for class jxl.read.biff.StringFormulaRecord
Constructs this object from the raw data.
StringFunction - class jxl.biff.formula.StringFunction.
Class used to hold a function when reading it in from a string.
StringFunction(String) - Constructor for class jxl.biff.formula.StringFunction
 
StringHelper - class jxl.biff.StringHelper.
Helper function to convert Java string objects to and from the byte representations
StringHelper() - Constructor for class jxl.biff.StringHelper
 
stringLengths - Variable in class jxl.write.biff.SSTRecord
The list of string lengths
stringLengths - Variable in class jxl.write.biff.SSTContinueRecord
The list of string lengths
stringList - Variable in class jxl.write.biff.SharedStrings
Contains the same strings, held in a list
StringParseItem - class jxl.biff.formula.StringParseItem.
A dummy implementation used for typing information when tokens are read when parsing strings.
StringParseItem() - Constructor for class jxl.biff.formula.StringParseItem
Constructor
StringRecord - class jxl.write.biff.StringRecord.
Stores the string result of a formula calculation.
StringRecord(String) - Constructor for class jxl.write.biff.StringRecord
Constructor
strings - Variable in class jxl.read.biff.SSTRecord
The shared strings
strings - Variable in class jxl.write.biff.SSTRecord
The list of strings
strings - Variable in class jxl.write.biff.SSTContinueRecord
The list of strings
strings - Variable in class jxl.write.biff.SharedStrings
All the strings in the spreadsheet, keyed on the string itself
StringValue - class jxl.biff.formula.StringValue.
A string constant operand in a formula
StringValue() - Constructor for class jxl.biff.formula.StringValue
Constructor
StringValue(String) - Constructor for class jxl.biff.formula.StringValue
Constructor used when parsing a string formula
style - Variable in class jxl.write.biff.ColumnInfoRecord
The style for the column
STYLE - Static variable in class jxl.biff.Type
 
styleNumber - Variable in class jxl.biff.BuiltInStyle
The reference number of this style
styles - Static variable in class jxl.format.BorderLineStyle
The list of alignments
styles - Static variable in class jxl.format.UnderlineStyle
The list of UnderlineStyles
styles - Static variable in class jxl.format.ScriptStyle
The list of ScriptStyles
StyleXFRecord - class jxl.write.biff.StyleXFRecord.
A style XF Record
StyleXFRecord(FontRecord, DisplayFormat) - Constructor for class jxl.write.biff.StyleXFRecord
Constructor
subExpression - Static variable in class jxl.read.biff.NameRecord
 
SUBSCRIPT - Static variable in class jxl.format.ScriptStyle
 
SUBSCRIPT - Static variable in class jxl.write.Font
Deprecated.  
SUBSTITUTE - Static variable in class jxl.biff.formula.Function
 
substreamType - Variable in class jxl.read.biff.BOFRecord
The type of this substream
SUBTOTAL - Static variable in class jxl.biff.formula.Function
 
Subtract - class jxl.biff.formula.Subtract.
A cell reference in a formula
SUBTRACT - Static variable in class jxl.biff.formula.Token
 
Subtract() - Constructor for class jxl.biff.formula.Subtract
Constructor
SUM - Static variable in class jxl.biff.formula.Function
 
SUMIF - Static variable in class jxl.biff.formula.Function
 
sumMask - Static variable in class jxl.biff.formula.Attribute
 
SUMPRODUCT - Static variable in class jxl.biff.formula.Function
 
SUMSQ - Static variable in class jxl.biff.formula.Function
 
SUMX2MY2 - Static variable in class jxl.biff.formula.Function
 
SUMX2PY2 - Static variable in class jxl.biff.formula.Function
 
SUMXMY2 - Static variable in class jxl.biff.formula.Function
 
SUPBOOK - Static variable in class jxl.biff.Type
 
supbookIndex - Variable in class jxl.read.biff.ExternalSheetRecord.XTI
 
SupbookRecord - class jxl.read.biff.SupbookRecord.
A record containing the references to the various sheets (internal and external) referenced by formulas in this workbook
SupbookRecord - class jxl.write.biff.SupbookRecord.
Stores the supporting workbook information.
SupbookRecord.Type - class jxl.read.biff.SupbookRecord.Type.
The type of supbook this refers to
SupbookRecord.Type() - Constructor for class jxl.read.biff.SupbookRecord.Type
 
SupbookRecord(int) - Constructor for class jxl.write.biff.SupbookRecord
Constructor for internal sheets
SupbookRecord(Record) - Constructor for class jxl.read.biff.SupbookRecord
Constructs this object from the raw data
SupbookRecord(SupbookRecord) - Constructor for class jxl.write.biff.SupbookRecord
Constructor used when copying from an external workbook
supbooks - Variable in class jxl.read.biff.WorkbookParser
The list of supporting workbooks - used by formulas
supbooks - Variable in class jxl.write.biff.WritableWorkbookImpl
The supbook records
SUPERSCRIPT - Static variable in class jxl.format.ScriptStyle
 
SUPERSCRIPT - Static variable in class jxl.write.Font
Deprecated.  
SYD - Static variable in class jxl.biff.formula.Function
 

T

T - Static variable in class jxl.biff.formula.Function
 
TABID - Static variable in class jxl.biff.Type
 
TabIdRecord - class jxl.write.biff.TabIdRecord.
Contains an array of sheet tab index numbers
TabIdRecord(int) - Constructor for class jxl.write.biff.TabIdRecord
Constructor
TAN - Static variable in class jxl.biff.formula.Function
 
TANH - Static variable in class jxl.biff.formula.Function
 
TDIST - Static variable in class jxl.biff.formula.Function
 
templateFormula - Variable in class jxl.read.biff.SharedFormulaRecord
The first (template) formula comprising this group
TEXT - Static variable in class jxl.biff.formula.Function
 
THICK - Static variable in class jxl.format.BorderLineStyle
 
THIN - Static variable in class jxl.format.BorderLineStyle
 
THOUSANDS_FLOAT - Static variable in class jxl.write.NumberFormats
Formatting for a float that has a thousands separator.
THOUSANDS_INTEGER - Static variable in class jxl.write.NumberFormats
Formatting for an integer that has a thousands separator.
time - Variable in class jxl.read.biff.DateRecord
Indicates whether this is a full date, or merely a time
time - Variable in class jxl.write.biff.DateRecord
Indicates whether this is a full date, or just a time only
TIME - Static variable in class jxl.biff.formula.Function
 
timeFormat - Static variable in class jxl.read.biff.DateRecord
 
TIMES - Static variable in class jxl.write.WritableFont
Objects created with this font name will be rendered within Excel as TIMES fonts
TIMES - Static variable in class jxl.write.Font
Deprecated.  
TIMEVALUE - Static variable in class jxl.biff.formula.Function
 
TINV - Static variable in class jxl.biff.formula.Function
 
TODAY - Static variable in class jxl.biff.formula.Function
 
Token - class jxl.biff.formula.Token.
An enumeration detailing the Excel parsed tokens A particular token may be associated with more than one token code
Token(int) - Constructor for class jxl.biff.formula.Token
Constructor Sets the token value and adds this token to the array of all token
Token(int, int) - Constructor for class jxl.biff.formula.Token
Constructor Sets the token value and adds this token to the array of all token
Token(int, int, int) - Constructor for class jxl.biff.formula.Token
Constructor Sets the token value and adds this token to the array of all token
Token(int, int, int, int) - Constructor for class jxl.biff.formula.Token
Constructor Sets the token value and adds this token to the array of all token
Token(int, int, int, int, int) - Constructor for class jxl.biff.formula.Token
Constructor Sets the token value and adds this token to the array of all token
tokenData - Variable in class jxl.biff.formula.TokenFormulaParser
The Excel ptgs
TokenFormulaParser - class jxl.biff.formula.TokenFormulaParser.
Parses the excel ptgs into a parse tree
TokenFormulaParser(byte[], Cell, ExternalSheet) - Constructor for class jxl.biff.formula.TokenFormulaParser
Constructor
tokens - Static variable in class jxl.biff.formula.Token
All available tokens, keyed on value
tokens - Variable in class jxl.read.biff.SharedFormulaRecord
The token data
tokens - Variable in class jxl.read.biff.BaseSharedFormulaRecord
The array of parsed tokens
tokenStack - Variable in class jxl.biff.formula.TokenFormulaParser
The hash table of items that have been parsed
TOP - Static variable in class jxl.format.Border
 
TOP - Static variable in class jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned at the top
topBorder - Variable in class jxl.biff.XFRecord
The border indicator for the top of the cell
topMargin - Variable in class jxl.SheetSettings
The margin from the top of the paper in inches
TOPMARGIN - Static variable in class jxl.biff.Type
 
TopMarginRecord - class jxl.read.biff.TopMarginRecord.
Record for the left margin settings
TopMarginRecord - class jxl.write.biff.TopMarginRecord.
The settings for the left margin
TopMarginRecord(double) - Constructor for class jxl.write.biff.TopMarginRecord
 
TopMarginRecord(Record) - Constructor for class jxl.read.biff.TopMarginRecord
Constructor
toString() - Method in class jxl.CellType
Returns a string description of this cell
toString() - Method in class jxl.biff.SheetRangeImpl
To string method - primarily used during debugging
toString() - Method in class jxl.write.biff.HyperlinkRecord
A standard toString method
totalOccurrences - Variable in class jxl.write.biff.SharedStrings
The total occurrence of strings in the workbook
totalStrings - Variable in class jxl.read.biff.SSTRecord
The total number of strings in this table
TRANSPOSE - Static variable in class jxl.biff.formula.Function
 
TREND - Static variable in class jxl.biff.formula.Function
 
TRIM - Static variable in class jxl.biff.formula.Function
 
trimInvalidChars(String) - Method in class jxl.write.biff.NumberFormatRecord
Remove all but the first characters preceding the # or the 0.
TRIMMEAN - Static variable in class jxl.biff.formula.Function
 
TRUE - Static variable in class jxl.biff.formula.Function
 
TRUNC - Static variable in class jxl.biff.formula.Function
 
TTEST - Static variable in class jxl.biff.formula.Function
 
TXO - Static variable in class jxl.biff.Type
 
type - Variable in class jxl.biff.BaseCompoundFile.PropertyStorage
The type of the property set
type - Variable in class jxl.read.biff.SupbookRecord
The type of this supbook record
Type - class jxl.biff.Type.
The biff types
TYPE - Static variable in class jxl.biff.formula.Function
 
TYPE_POS - Static variable in class jxl.biff.BaseCompoundFile
 
Type(int) - Constructor for class jxl.biff.Type
Constructor Sets the biff value and adds this type to the array of all types
typeFlag - Variable in class jxl.read.biff.BoundsheetRecord
The type of sheet this is
types - Static variable in class jxl.biff.Type
An array of all types

U

UNARY_MINUS - Static variable in class jxl.biff.formula.Token
 
UNARY_PLUS - Static variable in class jxl.biff.formula.Token
 
UnaryMinus - class jxl.biff.formula.UnaryMinus.
A cell reference in a formula
UnaryMinus() - Constructor for class jxl.biff.formula.UnaryMinus
Constructor
UnaryOperator - class jxl.biff.formula.UnaryOperator.
A cell reference in a formula
UnaryOperator() - Constructor for class jxl.biff.formula.UnaryOperator
Constructor
UnaryPlus - class jxl.biff.formula.UnaryPlus.
A cell reference in a formula
UnaryPlus() - Constructor for class jxl.biff.formula.UnaryPlus
Constructor
underlineStyle - Variable in class jxl.biff.FontRecord
The underline style for this font (none, single, double etc)
UnderlineStyle - class jxl.format.UnderlineStyle.
Enumeration class which contains the various underline styles available within the standard Excel UnderlineStyle palette
UnderlineStyle(int, String) - Constructor for class jxl.format.UnderlineStyle
Private constructor
uninitialize() - Method in class jxl.biff.FontRecord
Resets the initialize flag.
uninitialize() - Method in class jxl.biff.XFRecord
Resets the initialize flag.
union - Static variable in class jxl.read.biff.NameRecord
 
uniqueStrings - Variable in class jxl.read.biff.SSTRecord
The number of unique strings
unknown - Static variable in class jxl.format.PaperSize
 
unknown - Static variable in class jxl.read.biff.HyperlinkRecord
 
unknown - Static variable in class jxl.write.biff.HyperlinkRecord
 
UNKNOWN - Static variable in class jxl.biff.Type
 
UNKNOWN - Static variable in class jxl.biff.formula.Function
 
UNKNOWN - Static variable in class jxl.biff.formula.Token
 
UNKNOWN - Static variable in class jxl.format.Colour
 
UNKNOWN - Static variable in class jxl.read.biff.SupbookRecord
 
unmergeCells(Range) - Method in interface jxl.write.WritableSheet
Unmerges the specified cells.
unmergeCells(Range) - Method in class jxl.write.biff.WritableSheetImpl
Unmerges the specified cells.
unpackFromString(int, int, String) - Method in class jxl.biff.formula.Yylex
 
unrecognizedBiffVersion - Static variable in class jxl.read.biff.BiffException
 
unrecognizedFunction - Static variable in class jxl.biff.formula.FormulaException
 
unrecognizedOLEFile - Static variable in class jxl.read.biff.BiffException
 
unrecognizedToken - Static variable in class jxl.biff.formula.FormulaException
 
UPPER - Static variable in class jxl.biff.formula.Function
 
url - Variable in class jxl.read.biff.HyperlinkRecord
The URL referred to by this hyperlink
url - Variable in class jxl.write.biff.HyperlinkRecord
The URL referred to by this hyperlink
urlLink - Static variable in class jxl.read.biff.HyperlinkRecord
 
urlLink - Static variable in class jxl.write.biff.HyperlinkRecord
 
usesElfs - Variable in class jxl.write.biff.UsesElfsRecord
The uses ELFs flag
USESELFS - Static variable in class jxl.biff.Type
 
UsesElfsRecord - class jxl.write.biff.UsesElfsRecord.
Stores the flag which indicates whether the version of excel can understand natural language input for formulae
UsesElfsRecord() - Constructor for class jxl.write.biff.UsesElfsRecord
Constructor
utcOffsetDays - Static variable in class jxl.read.biff.DateRecord
 
utcOffsetDays - Static variable in class jxl.write.biff.DateRecord
 
utcOffsetDays1904 - Static variable in class jxl.read.biff.DateRecord
 

V

val - Variable in class jxl.format.PaperSize
The excel encoding
valign - Variable in class jxl.biff.XFRecord
The vertical alignment for the cell (top, bottom, centre)
value - Variable in class jxl.biff.Type
The biff value for this type
value - Variable in class jxl.biff.formula.IntegerValue
The value of this integer
value - Variable in class jxl.biff.formula.DoubleValue
The value of this double in the formula
value - Variable in class jxl.biff.formula.StringValue
The string value
value - Variable in class jxl.biff.formula.BooleanValue
The boolean value
value - Variable in class jxl.biff.formula.Token
The array of values which apply to this token
value - Variable in class jxl.format.Colour
The internal numerical representation of the colour
value - Variable in class jxl.format.BorderLineStyle
The value
value - Variable in class jxl.format.UnderlineStyle
The internal numerical representation of the UnderlineStyle
value - Variable in class jxl.format.ScriptStyle
The internal numerical representation of the ScriptStyle
value - Variable in class jxl.format.Orientation
The internal binary value which gets written to the generated Excel file
value - Variable in class jxl.format.Alignment
The internal numerical repreentation of the alignment
value - Variable in class jxl.format.Pattern
The internal numerical representation of the colour
value - Variable in class jxl.format.BoldStyle
The bold weight
value - Variable in class jxl.format.VerticalAlignment
The internal binary value which gets written to the generated Excel file
value - Variable in class jxl.read.biff.BooleanFormulaRecord
The boolean value of this cell.
value - Variable in class jxl.read.biff.NumberValue
The value of this number
value - Variable in class jxl.read.biff.NumberRecord
The value
value - Variable in class jxl.read.biff.BooleanRecord
The boolean value of this cell.
value - Variable in class jxl.read.biff.NumberFormulaRecord
The last calculated value of the formula
value - Variable in class jxl.read.biff.StringFormulaRecord
The last calculated value of the formula
value - Variable in class jxl.read.biff.RKRecord
The value
value - Variable in class jxl.read.biff.SharedDateFormulaRecord
The double value
value - Variable in class jxl.read.biff.DateFormulaRecord
The last calculated value of the formula
value - Variable in class jxl.read.biff.SSTRecord.BooleanHolder
 
value - Variable in class jxl.read.biff.SharedNumberFormulaRecord
The value of this number
value - Variable in class jxl.read.biff.SharedStringFormulaRecord
The value of this string formula
value - Variable in class jxl.write.WritableFont.BoldStyle
 
value - Variable in class jxl.write.biff.BooleanRecord
The boolean value of this cell.
value - Variable in class jxl.write.biff.NumberRecord
The number
value - Variable in class jxl.write.biff.DateRecord
The excel value of the date
value - Variable in class jxl.write.biff.StringRecord
The string value
value - Variable in class jxl.write.biff.CalcModeRecord.CalcMode
The indicator as written to the output file
VALUE - Static variable in class jxl.biff.formula.Function
 
VAR - Static variable in class jxl.biff.formula.Function
 
VARA - Static variable in class jxl.biff.formula.Function
 
VariableArgFunction - class jxl.biff.formula.VariableArgFunction.
A built in function in a formula.
VariableArgFunction() - Constructor for class jxl.biff.formula.VariableArgFunction
Constructor
VariableArgFunction(Function, int) - Constructor for class jxl.biff.formula.VariableArgFunction
Constructor used when parsing a function from a string
VARP - Static variable in class jxl.biff.formula.Function
 
VARPA - Static variable in class jxl.biff.formula.Function
 
VCENTER - Static variable in class jxl.biff.Type
 
VDB - Static variable in class jxl.biff.formula.Function
 
version - Static variable in class jxl.Workbook
The current version of the software
version - Variable in class jxl.read.biff.BOFRecord
The biff version of this substream
VERTICAL - Static variable in class jxl.format.Orientation
Cells with this specified orientation have their data presented vertically
VerticalAlignment - class jxl.format.VerticalAlignment.
Enumeration type which describes the vertical alignment of data within a cell
VerticalAlignment - class jxl.write.VerticalAlignment.
Deprecated. Repackaged as jxl.format.VerticalAlignment
VerticalAlignment() - Constructor for class jxl.write.VerticalAlignment
Deprecated. Constructor
VerticalAlignment(int, String) - Constructor for class jxl.format.VerticalAlignment
Constructor
VerticalCentreRecord - class jxl.write.biff.VerticalCentreRecord.
Indicates whether the centre vertically on page option has been set from the options dialog box
VerticalCentreRecord(boolean) - Constructor for class jxl.write.biff.VerticalCentreRecord
Constructor
verticalPrintResolution - Variable in class jxl.SheetSettings
The vertical print resolution
verticalPrintResolution - Variable in class jxl.read.biff.SetupRecord
The vertical print resolution
verticalPrintResolution - Variable in class jxl.write.biff.SetupRecord
The vertical print resolution
VERY_LIGHT_ORANGE - Static variable in class jxl.format.Colour
 
VERY_LIGHT_YELLOW - Static variable in class jxl.format.Colour
 
VIOLET - Static variable in class jxl.format.Colour
 
visibilityFlag - Variable in class jxl.read.biff.BoundsheetRecord
The visibility flag
VLOOKUP - Static variable in class jxl.biff.formula.Function
 

W

wbProtected - Variable in class jxl.read.biff.WorkbookParser
Workbook protected flag
wbProtected - Variable in class jxl.write.biff.WritableWorkbookImpl
The workbook protection flag
WEEKDAY - Static variable in class jxl.biff.formula.Function
 
WEIBULL - Static variable in class jxl.biff.formula.Function
 
WHITE - Static variable in class jxl.format.Colour
 
width - Variable in class jxl.read.biff.ColumnInfoRecord
The width of the column in 1/256 of a character
width - Variable in class jxl.write.biff.DefaultColumnWidth
The default column widt
width - Variable in class jxl.write.biff.ColumnInfoRecord
The width of the column in 1/256 of a character
WINDOW1 - Static variable in class jxl.biff.Type
 
Window1Record - class jxl.write.biff.Window1Record.
Contains workbook level windowing attributes
Window1Record() - Constructor for class jxl.write.biff.Window1Record
Constructor
WINDOW2 - Static variable in class jxl.biff.Type
 
Window2Record - class jxl.write.biff.Window2Record.
Contains the window attributes for a worksheet
Window2Record(boolean) - Constructor for class jxl.write.biff.Window2Record
Constructor
WINDOWPROTECT - Static variable in class jxl.biff.Type
 
WindowProtectRecord - class jxl.write.biff.WindowProtectRecord.
Stores an option from the Protect Workbook dialog box
WindowProtectRecord(boolean) - Constructor for class jxl.write.biff.WindowProtectRecord
Constructor
word - Variable in class jxl.biff.formula.Attribute
The word contained in this attribute
workbook - Variable in class jxl.biff.formula.Area3d
A handle to the workbook
workbook - Variable in class jxl.biff.formula.CellReference3d
A handle to the container of the external sheets ie.
workbook - Variable in class jxl.biff.formula.TokenFormulaParser
A reference to the workbook which holds the external sheet information
workbook - Variable in class jxl.demo.XML
The workbook we are reading from
workbook - Variable in class jxl.read.biff.SheetImpl
A handle to the workbook which contains this sheet.
workbook - Variable in class jxl.read.biff.SheetReader
A handle to the workbook which contains this sheet.
workbook - Variable in class jxl.read.biff.RangeImpl
A handle to the workbook
Workbook - class jxl.Workbook.
Represents a Workbook.
Workbook() - Constructor for class jxl.Workbook
The constructor
workbookBof - Variable in class jxl.read.biff.SheetImpl
A handle to the workbook BOF record, which indicates the stream type
workbookBof - Variable in class jxl.read.biff.WorkbookParser
The bof record for this workbook
workbookBof - Variable in class jxl.read.biff.SheetReader
A handle to the workbook BOF record, which indicates the stream type
workbookGlobals - Static variable in class jxl.write.biff.BOFRecord
 
WorkbookGlobals - Static variable in class jxl.read.biff.BOFRecord
The code used for workbook globals
workbookLink - Static variable in class jxl.read.biff.HyperlinkRecord
 
workbookLink - Static variable in class jxl.write.biff.HyperlinkRecord
 
WorkbookParser - class jxl.read.biff.WorkbookParser.
Parses the biff file passed in, and builds up an internal representation of the spreadsheet
WorkbookParser(File) - Constructor for class jxl.read.biff.WorkbookParser
Constructs this object from the raw excel data
WorkbookSettings - class jxl.WorkbookSettings.
This is a bean which client applications may use to set various advanced workbook properties.
WorkbookSettings() - Constructor for class jxl.WorkbookSettings
Default constructor
Worksheet - Static variable in class jxl.read.biff.BOFRecord
The code used for worksheets
WorkspaceInformationRecord - class jxl.read.biff.WorkspaceInformationRecord.
A record detailing whether the sheet is protected
WorkspaceInformationRecord - class jxl.write.biff.WorkspaceInformationRecord.
Stores information about the workspace settings
WorkspaceInformationRecord(int) - Constructor for class jxl.write.biff.WorkspaceInformationRecord
Constructor
WorkspaceInformationRecord(Record) - Constructor for class jxl.read.biff.WorkspaceInformationRecord
Constructs this object from the raw data
workspaceOptions - Variable in class jxl.read.biff.SheetImpl
The workspace options
workspaceOptions - Variable in class jxl.read.biff.SheetReader
The workspace options
workspaceOptions - Variable in class jxl.write.biff.SheetWriter
The workspace options
wrap - Variable in class jxl.biff.XFRecord
Flag to indicates whether the data (normally text) in the cell will be wrapped around to fit in the cell width
WritableCell - interface jxl.write.WritableCell.
The interface for all writable cells
WritableCellFormat - class jxl.write.WritableCellFormat.
A user specified cell format, which may be reused across many cells.
WritableCellFormat() - Constructor for class jxl.write.WritableCellFormat
A default constructor, which uses the default font and format.
WritableCellFormat(DisplayFormat) - Constructor for class jxl.write.WritableCellFormat
A constructor which specifies a date/number format for Cells which use this format object
WritableCellFormat(WritableFont) - Constructor for class jxl.write.WritableCellFormat
A CellFormat which specifies the font for cells with this format
WritableCellFormat(WritableFont, DisplayFormat) - Constructor for class jxl.write.WritableCellFormat
A constructor which specifies the font and date/number format for cells which wish to use this format
WritableFont - class jxl.write.WritableFont.
A class which is instantiated when the user application wishes to specify the font for a particular cell
WritableFont.BoldStyle - class jxl.write.WritableFont.BoldStyle.
Static inner class used for the boldness of the fonts
WritableFont.BoldStyle(int) - Constructor for class jxl.write.WritableFont.BoldStyle
 
WritableFont.FontName - class jxl.write.WritableFont.FontName.
Static inner class used for classifying the font names
WritableFont.FontName(String) - Constructor for class jxl.write.WritableFont.FontName
 
WritableFont(WritableFont.FontName) - Constructor for class jxl.write.WritableFont
Creates a default font, vanilla font of the specified face and with default point size.
WritableFont(WritableFont.FontName, int) - Constructor for class jxl.write.WritableFont
Constructs of font of the specified face and of size given by the specified point size
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle) - Constructor for class jxl.write.WritableFont
Creates a font of the specified face, point size and bold style
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean) - Constructor for class jxl.write.WritableFont
Creates a font of the specified face, point size, bold weight and italicised option.
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle) - Constructor for class jxl.write.WritableFont
Creates a font of the specified face, point size, bold weight, italicisation and underline style
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour) - Constructor for class jxl.write.WritableFont
Creates a font of the specified face, point size, bold style, italicisation, underline style and colour
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour, ScriptStyle) - Constructor for class jxl.write.WritableFont
Creates a font of the specified face, point size, bold style, italicisation, underline style, colour, and script style (superscript/subscript)
WritableFontRecord - class jxl.write.biff.WritableFontRecord.
A writable Font record.
WritableFontRecord(String, int, int, boolean, int, int, int) - Constructor for class jxl.write.biff.WritableFontRecord
Constructor, used when creating a new font for writing out.
WritableFonts - class jxl.write.biff.WritableFonts.
A container for the list of fonts used in this workbook The writable subclass instantiates the predetermined list of fonts available to users of the writable API
WritableFonts() - Constructor for class jxl.write.biff.WritableFonts
Constructor.
WritableFormattingRecords - class jxl.write.biff.WritableFormattingRecords.
Handles the Format and XF record indexing.
WritableFormattingRecords(Fonts) - Constructor for class jxl.write.biff.WritableFormattingRecords
Constructor.
WritableHyperlink - class jxl.write.WritableHyperlink.
A writable hyperlink.
WritableHyperlink(Hyperlink, WritableSheet) - Constructor for class jxl.write.WritableHyperlink
Constructor used internally by the worksheet when making a copy of worksheet
WritableHyperlink(int, int, File) - Constructor for class jxl.write.WritableHyperlink
Constructs a file hyperlink in a single cell
WritableHyperlink(int, int, int, int, File) - Constructor for class jxl.write.WritableHyperlink
Constructs a File hyperlink to a range of cells
WritableHyperlink(int, int, int, int, String, WritableSheet, int, int, int, int) - Constructor for class jxl.write.WritableHyperlink
Constructs a hyperlink to some cells within this workbook
WritableHyperlink(int, int, int, int, URL) - Constructor for class jxl.write.WritableHyperlink
Constructs a url hyperlink to a range of cells
WritableHyperlink(int, int, String, WritableSheet, int, int) - Constructor for class jxl.write.WritableHyperlink
Constructs a hyperlink to some cells within this workbook
WritableHyperlink(int, int, URL) - Constructor for class jxl.write.WritableHyperlink
Constructs a URL hyperlink in a single cell
WritableRecordData - class jxl.biff.WritableRecordData.
Extension of the standard RecordData which is used to support those records which, once read, may also be written
WritableRecordData(Record) - Constructor for class jxl.biff.WritableRecordData
Constructor used when reading a record
WritableRecordData(Type) - Constructor for class jxl.biff.WritableRecordData
Constructor used by the writable records
WritableSheet - interface jxl.write.WritableSheet.
Interface for a worksheet that may be modified.
WritableSheetImpl - class jxl.write.biff.WritableSheetImpl.
A writable sheet.
WritableSheetImpl.ColumnInfoComparator - class jxl.write.biff.WritableSheetImpl.ColumnInfoComparator.
The comparator for column info record
WritableSheetImpl.ColumnInfoComparator() - Constructor for class jxl.write.biff.WritableSheetImpl.ColumnInfoComparator
 
WritableSheetImpl(String, File, FormattingRecords, SharedStrings) - Constructor for class jxl.write.biff.WritableSheetImpl
Constructor
WritableWorkbook - class jxl.write.WritableWorkbook.
A writable workbook
WritableWorkbook() - Constructor for class jxl.write.WritableWorkbook
Constructor used by the implemenation class
WritableWorkbookImpl - class jxl.write.biff.WritableWorkbookImpl.
A writable workbook
WritableWorkbookImpl(OutputStream, boolean, WorkbookSettings) - Constructor for class jxl.write.biff.WritableWorkbookImpl
Constructor.
WritableWorkbookImpl(OutputStream, Workbook, boolean, WorkbookSettings) - Constructor for class jxl.write.biff.WritableWorkbookImpl
A pseudo copy constructor.
Write - class jxl.demo.Write.
Demo class which writes a spreadsheet.
write() - Method in class jxl.demo.Write
Uses the JExcelAPI to create a spreadsheet
write() - Method in class jxl.write.WritableWorkbook
Writes out the data held in this workbook in Excel format
write() - Method in class jxl.write.biff.SheetWriter
Writes out this sheet.
write() - Method in class jxl.write.biff.WritableSheetImpl
Writes out this sheet.
write() - Method in class jxl.write.biff.WritableWorkbookImpl
Writes out this sheet to the output file.
write() - Method in class jxl.write.biff.CompoundFile
Writes out the excel file in OLE compound file format
write(ByteData) - Method in class jxl.write.biff.File
Adds the biff record data to the memory allocated for this File
write(File) - Method in class jxl.biff.FormattingRecords
Writes out all the format records and the XF records
write(File) - Method in class jxl.biff.Fonts
Writes out the list of fonts
write(File) - Method in class jxl.write.biff.RowRecord
Writes out the row information data (but not the individual cells)
write(File) - Method in class jxl.write.biff.SharedStrings
Writes out the shared string table
Write(String) - Constructor for class jxl.demo.Write
Constructor
WriteAccess - class jxl.demo.WriteAccess.
Displays whatever generated the excel file (ie.
WRITEACCESS - Static variable in class jxl.biff.Type
 
WriteAccess(File) - Constructor for class jxl.demo.WriteAccess
 
WriteAccessRecord - class jxl.write.biff.WriteAccessRecord.
The name used when Excel was installed.
WriteAccessRecord() - Constructor for class jxl.write.biff.WriteAccessRecord
Constructor
writeBigBlockDepot() - Method in class jxl.write.biff.CompoundFile
Writes out the Big Block Depot
writeBordersSheet(WritableSheet) - Method in class jxl.demo.Write
Adds cells to the specified sheet which test the various border styles
writeByte(byte, StringBuffer) - Method in class jxl.demo.BiffDump
Writes the string passed in as a minimum of four digits
writeCells(File) - Method in class jxl.write.biff.RowRecord
Writes out all the cells in this row.
writeDateFormatSheet(WritableSheet) - Method in class jxl.demo.Write
Adds cells to the specified sheet which test the various date formats
writeExcelData() - Method in class jxl.write.biff.CompoundFile
Writes out the excel data, padding it out with empty bytes as necessary
WriteException - exception jxl.write.WriteException.
Exception thrown when using the API to generate an Excel file
WriteException(String) - Constructor for class jxl.write.WriteException
Constructs this exception with the specified message
writeFormattedXML() - Method in class jxl.demo.XML
Writes out the workbook data as XML, with formatting information
writeFormulaSheet(WritableSheet) - Method in class jxl.demo.Write
Test out the formula parser
writeHeader() - Method in class jxl.write.biff.CompoundFile
Writes the compound file header
writeIntegerValues(ArrayList, File) - Method in class jxl.write.biff.RowRecord
Writes out the list of integer values.
writeLabelFormatSheet(WritableSheet) - Method in class jxl.demo.Write
Adds cells to the specified sheet which test the various label formatting styles, such as different fonts, different sizes and bold, underline etc.
writeLabelsSheet(WritableSheet) - Method in class jxl.demo.Write
Write out loads of labels, in order to test the shared string table
writeNumberFormatSheet(WritableSheet) - Method in class jxl.demo.Write
Writes out a sheet containing the various numerical formats
writePropertySets() - Method in class jxl.write.biff.CompoundFile
Writes out the property sets
writer - Variable in class jxl.demo.BiffDump
 
writeRecord(Record) - Method in class jxl.demo.BiffDump
Writes out the biff record
writeSixDigitValue(int, StringBuffer) - Method in class jxl.demo.BiffDump
Writes the string passed in as a minimum of four digits
writeXML() - Method in class jxl.demo.XML
Writes out the workbook data as XML, without formatting information
WSBOOL - Static variable in class jxl.biff.Type
 
wsoptions - Variable in class jxl.read.biff.WorkspaceInformationRecord
The options byte

X

XF - Static variable in class jxl.biff.Type
 
xfIndex - Variable in class jxl.biff.BuiltInStyle
The XF index of this style
xfIndex - Variable in class jxl.biff.XFRecord
The index of this XF record within the workbook
xfIndex - Variable in class jxl.read.biff.DateRecord
The index to the XF Record
xfIndex - Variable in class jxl.read.biff.CellValue
The XF index
xfIndex - Variable in class jxl.read.biff.NumberValue
The index to the XF Record
xfIndex - Variable in class jxl.read.biff.ColumnInfoRecord
The index to the XF record, which applies to each cell in this column
xfIndex - Variable in class jxl.read.biff.MulBlankCell
The index to the XF Record
xfIndex - Variable in class jxl.write.biff.ColumnInfoRecord
The index for the style of this column
xfIndices - Variable in class jxl.read.biff.MulRKRecord
The array of xf indices
xfIndices - Variable in class jxl.read.biff.MulBlankRecord
The array of xf indices
xfIndices - Variable in class jxl.write.biff.MulRKRecord
The array of xf indices
XFRecord - class jxl.biff.XFRecord.
Holds an extended formatting record
XFRecord.BiffType - class jxl.biff.XFRecord.BiffType.
 
XFRecord.BiffType() - Constructor for class jxl.biff.XFRecord.BiffType
 
XFRecord(FontRecord, DisplayFormat) - Constructor for class jxl.biff.XFRecord
A constructor used when creating a writable record
XFRecord(Record, XFRecord.BiffType) - Constructor for class jxl.biff.XFRecord
Constructs this object from the raw data
XFRecord(XFRecord) - Constructor for class jxl.biff.XFRecord
Copy constructor.
xfRecords - Variable in class jxl.biff.FormattingRecords
The list of extended format records
XML - class jxl.demo.XML.
Simple demo class which uses the api to present the contents of an excel 97 spreadsheet as an XML document, using a workbook and output stream of your choice
XML(Workbook, OutputStream, String, boolean) - Constructor for class jxl.demo.XML
Constructor
XMLFormat - Static variable in class jxl.demo.Demo
 
xtiArray - Variable in class jxl.read.biff.ExternalSheetRecord
The array of XTI structures

Y

YEAR - Static variable in class jxl.biff.formula.Function
 
YELLOW - Static variable in class jxl.format.Colour
 
yy_acpt - Variable in class jxl.biff.formula.Yylex
 
yy_advance() - Method in class jxl.biff.formula.Yylex
 
yy_at_bol - Variable in class jxl.biff.formula.Yylex
 
YY_BOL - Variable in class jxl.biff.formula.Yylex
 
yy_buffer - Variable in class jxl.biff.formula.Yylex
 
yy_buffer_end - Variable in class jxl.biff.formula.Yylex
 
yy_buffer_index - Variable in class jxl.biff.formula.Yylex
 
yy_buffer_read - Variable in class jxl.biff.formula.Yylex
 
YY_BUFFER_SIZE - Variable in class jxl.biff.formula.Yylex
 
yy_buffer_start - Variable in class jxl.biff.formula.Yylex
 
yy_cmap - Variable in class jxl.biff.formula.Yylex
 
yy_double(char[]) - Method in class jxl.biff.formula.Yylex
 
YY_E_INTERNAL - Variable in class jxl.biff.formula.Yylex
 
YY_E_MATCH - Variable in class jxl.biff.formula.Yylex
 
YY_END - Variable in class jxl.biff.formula.Yylex
 
YY_EOF - Variable in class jxl.biff.formula.Yylex
 
yy_eof_done - Variable in class jxl.biff.formula.Yylex
 
yy_error_string - Variable in class jxl.biff.formula.Yylex
 
yy_error(int, boolean) - Method in class jxl.biff.formula.Yylex
 
YY_F - Variable in class jxl.biff.formula.Yylex
 
yy_last_was_cr - Variable in class jxl.biff.formula.Yylex
 
yy_lexical_state - Variable in class jxl.biff.formula.Yylex
 
yy_mark_end() - Method in class jxl.biff.formula.Yylex
 
yy_mark_start() - Method in class jxl.biff.formula.Yylex
 
yy_move_end() - Method in class jxl.biff.formula.Yylex
 
YY_NO_ANCHOR - Variable in class jxl.biff.formula.Yylex
 
YY_NO_STATE - Variable in class jxl.biff.formula.Yylex
 
YY_NOT_ACCEPT - Variable in class jxl.biff.formula.Yylex
 
yy_nxt - Variable in class jxl.biff.formula.Yylex
 
yy_reader - Variable in class jxl.biff.formula.Yylex
 
yy_rmap - Variable in class jxl.biff.formula.Yylex
 
YY_START - Variable in class jxl.biff.formula.Yylex
 
yy_state_dtrans - Variable in class jxl.biff.formula.Yylex
 
yy_to_mark() - Method in class jxl.biff.formula.Yylex
 
yybegin(int) - Method in class jxl.biff.formula.Yylex
 
yychar - Variable in class jxl.biff.formula.Yylex
 
YYINITIAL - Variable in class jxl.biff.formula.Yylex
 
yylength() - Method in class jxl.biff.formula.Yylex
 
Yylex - class jxl.biff.formula.Yylex.
This file is generated by JLex.
yylex() - Method in class jxl.biff.formula.Yylex
 
Yylex() - Constructor for class jxl.biff.formula.Yylex
 
Yylex(InputStream) - Constructor for class jxl.biff.formula.Yylex
 
Yylex(Reader) - Constructor for class jxl.biff.formula.Yylex
 
yyline - Variable in class jxl.biff.formula.Yylex
 
YYSTRING - Variable in class jxl.biff.formula.Yylex
 
yytext() - Method in class jxl.biff.formula.Yylex
 

Z

zeroHeight - Variable in class jxl.read.biff.RowRecord
Indicates whether this row has zero height (ie.
ZTEST - Static variable in class jxl.biff.formula.Function
 

< A B C D E F G H I J K L M N O P Q R S T U V W X Y Z