# Index

A B C D E F G H I J L M N O P Q R S T U V W X Y
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form

## A

A2 - Static variable in class jxl.format.PaperSize
  A2 420mm × 594mm
A3 - Static variable in class jxl.format.PaperSize
  A3 297mm x 420mm
A3_EXTRA - Static variable in class jxl.format.PaperSize
  A3 Extra 322mm × 445mm
A3_EXTRA_TRANSVERSE - Static variable in class jxl.format.PaperSize
  A3 Extra Transverse 322mm × 445mm
A3_ROTATED - Static variable in class jxl.format.PaperSize
  A3 Rotated 420mm × 297mm
A3_TRANSVERSE - Static variable in class jxl.format.PaperSize
  A3 Transverse 297mm × 420mm
A4 - Static variable in class jxl.format.PaperSize
  A4 210mm x 297mm
A4_EXTRA - Static variable in class jxl.format.PaperSize
  A4 Extra 235mm × 322mm
A4_PLUS - Static variable in class jxl.format.PaperSize
  A4 Plus 210mm × 330mm
A4_ROTATED - Static variable in class jxl.format.PaperSize
  A4 Rotated 297mm × 210mm
A4_SMALL - Static variable in class jxl.format.PaperSize
  A4 Small 210mm x 297 mm
A4_TRANSVERSE - Static variable in class jxl.format.PaperSize
  A4 Transverse 210mm × 297mm
A5 - Static variable in class jxl.format.PaperSize
  A5 148mm x 210mm
A5_EXTRA - Static variable in class jxl.format.PaperSize
  A5 Extra 174mm × 235mm
A5_ROTATED - Static variable in class jxl.format.PaperSize
  A5 Rotated 210mm × 148mm
A5_TRANSVERSE - Static variable in class jxl.format.PaperSize
  A5 Transverse 148mm × 210mm
A6 - Static variable in class jxl.format.PaperSize
  A6 105mm × 148mm
A6_ROTATED - Static variable in class jxl.format.PaperSize
  A6 Rotated 148mm × 105mm
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
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.
addColumnPageBreak(int) - Method in interface jxl.write.WritableSheet
  Forces a page break at the specified column
addHyperlink(WritableHyperlink) - Method in interface jxl.write.WritableSheet
  Adds the specified hyperlink.
addImage(WritableImage) - Method in interface jxl.write.WritableSheet
  Adds an image to the sheet
addNameArea(String, WritableSheet, int, int, int, int) - Method in class jxl.write.WritableWorkbook
  Add new named area to this workbook with the given information.
addRowPageBreak(int) - Method in interface jxl.write.WritableSheet
  Forces a page break at the specified row
Alignment - Class in jxl.format
  Enumeration class which contains the various alignments for data within a cell
Alignment - Class in jxl.write
  Deprecated.
  Repackaged as jxl.Alignment. This version is retained for backwards compatibility
ALL - Static variable in class jxl.format.Border
append(String) - Method in class jxl.HeaderFooter.Contents
  Appends the text to the string buffer
appendDate() - Method in class jxl.HeaderFooter.Contents
  Appends the current date
appendPageNumber() - Method in class jxl.HeaderFooter.Contents
  Appends the page number
appendTime() - Method in class jxl.HeaderFooter.Contents
  Appends the current time
appendTotalPages() - Method in class jxl.HeaderFooter.Contents
  Appends the total number of pages
appendWorkbookName() - Method in class jxl.HeaderFooter.Contents
  Appends the workbook name
appendWorkSheetName() - Method in class jxl.HeaderFooter.Contents
  Appends the worksheet name
applySharedDataValidation(WritableCell, int, int) - Method in interface jxl.write.WritableSheet
  Extend the data validation contained in the specified cell across and downwards.
AQUA - Static variable in class jxl.format.Colour
ARIAL - Static variable in class jxl.write.Font
  Deprecated.
ARIAL - Static variable in class jxl.write.WritableFont
  Objects created with this font name will be rendered within Excel as ARIAL fonts
ARIAL_10_PT - Static variable in class jxl.write.WritableWorkbook
  The default font for Cell formats
AUTOMATIC - Static variable in class jxl.format.Colour

## B

B4 - Static variable in class jxl.format.PaperSize
  B4 (JIS) 257mm x 364mm
B4_ISO - Static variable in class jxl.format.PaperSize
  B4 (ISO) 250mm × 353mm
B4_ISO_2 - Static variable in class jxl.format.PaperSize
  B4 (ISO) 250mm × 353mm
B4_ROTATED - Static variable in class jxl.format.PaperSize
  B4 (JIS) Rotated 364mm × 257mm
B5 - Static variable in class jxl.format.PaperSize
  B5 (JIS) 182mm x 257mm
B5_EXTRA - Static variable in class jxl.format.PaperSize
  B5 (ISO) Extra 201mm × 276mm
B5_ISO - Static variable in class jxl.format.PaperSize
  B5 (ISO) 176mm × 250mm
B5_ROTATED - Static variable in class jxl.format.PaperSize
  B5 (JIS) Rotated 257mm × 182mm
B5_TRANSVERSE - Static variable in class jxl.format.PaperSize
  B5 (JIS) Transverse 182mm × 257mm
B6 - Static variable in class jxl.format.PaperSize
  B6 (JIS) 128mm × 182mm
B6_ISO - Static variable in class jxl.format.PaperSize
  B6 (ISO) 125mm × 176mm
B6_ROTATED - Static variable in class jxl.format.PaperSize
  B6 (JIS) Rotated 182mm × 128mm
BETWEEN - Static variable in class jxl.write.WritableCellFeatures
BLACK - Static variable in class jxl.format.Colour
Blank - Class in jxl.write
  A blank cell.
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
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
BLUE - Static variable in class jxl.format.Colour
BLUE_GREY - Static variable in class jxl.format.Colour
BLUE2 - Static variable in class jxl.format.Colour
BOLD - Static variable in class jxl.format.BoldStyle
  Emboldened style
BOLD - Static variable in class jxl.write.Font
  Deprecated.
BOLD - Static variable in class jxl.write.WritableFont
  Indicates that this font should be presented in a BOLD style
BoldStyle - Class in jxl.format
  Enumeration class containing the various bold styles for data
BoldStyle - Class in jxl.write
  Enumeration class containing the various bold styles for data
Boolean - Class in jxl.write
  A cell, created by user applications, which contains a boolean (or in some cases an error) value
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.
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 - Static variable in class jxl.CellType
BOOLEAN_FORMULA - Static variable in class jxl.CellType
BooleanCell - Interface in jxl
  This type represents the Microsoft concept of a Boolean.
BooleanFormulaCell - Interface in jxl
  A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
Border - Class in jxl.format
  The location of a border
Border - Class in jxl.write
  Deprecated.
  repackaged as jxl.format.Border
BorderLineStyle - Class in jxl.format
  The border line style
BorderLineStyle - Class in jxl.write
  Deprecated.
  Repackaged as jxl.format.BorderLineStyle
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
BRIGHT_GREEN - Static variable in class jxl.format.Colour
BROWN - Static variable in class jxl.format.Colour

## C

C - Static variable in class jxl.format.PaperSize
  C 17" x 22"
Cell - Interface in jxl
  Represents an individual Cell within a Sheet.
CellFeatures - Class in jxl
  Container for any additional cell features
CellFeatures() - Constructor for class jxl.CellFeatures
  Constructor
CellFormat - Interface in jxl
  Deprecated.
  Repackaged as jxl.format.CellFormat
CellFormat - Interface in jxl.format
  Interface for cell formats
CellReferenceHelper - Class in jxl
  Exposes some cell reference helper methods to the public interface.
CellType - Class in jxl
  An enumeration type listing the available content types for a cell
CellView - Class in jxl
  This is a bean which client applications may use to get/set various properties for a row or column on a spreadsheet
CellView() - Constructor for class jxl.CellView
  Default constructor
CellView(CellView) - Constructor for class jxl.CellView
  Copy constructor
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
clear() - Method in class jxl.HeaderFooter
  Clears the contents of the header/footer
clear() - Method in class jxl.HeaderFooter.Contents
  Clears the contents of this portion
close() - Method in class jxl.Workbook
  Closes this workbook, and frees makes any memory allocated available for garbage collection
close() - Method in class jxl.write.WritableWorkbook
  Closes this workbook, and makes any memory allocated available for garbage collection.
Colour - Class in jxl.format
  Enumeration class which contains the various colours available within the standard Excel colour palette
Colour - Class in jxl.write
  Deprecated.
  This has been repackaged as jxl.format.Colour
COMPLEX_FORMAT - Static variable in class jxl.write.NumberFormat
  Pass in to the constructor to bypass the format validation
copy(Workbook) - Method in class jxl.write.WritableWorkbook
  Deprecated.
  Copying now occurs implicitly as part of the overloaded factory method Workbook.createWorkbood
copySheet(int, String, int) - Method in class jxl.write.WritableWorkbook
  Copy sheet within the same workbook.
copySheet(String, String, int) - Method in class jxl.write.WritableWorkbook
  Copies the specified sheet and places it at the index specified by the parameter
copyTo(int, int) - Method in class jxl.write.Blank
  Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.Boolean
  Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.DateTime
  Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.Formula
  Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.Label
  Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.Number
  Implementation of the deep copy function
copyTo(int, int) - Method in interface jxl.write.WritableCell
  A deep copy.
CORAL - Static variable in class jxl.format.Colour
COURIER - Static variable in class jxl.write.WritableFont
  Objects created with this font name will be rendered within Excel as COURIER fonts
createFont(String) - Static method in class jxl.write.WritableFont
  Factory method which creates the specified font name.
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.
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, 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(File, WorkbookSettings) - Static method in class jxl.Workbook
  Creates a writable workbook with the given file name
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, Workbook, WorkbookSettings) - 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.
CSV - Class in jxl.demo
  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
CURRENCY_DOLLAR - Static variable in class jxl.write.NumberFormat
  Constant format string for the US Dollar sign
CURRENCY_EURO_PREFIX - Static variable in class jxl.write.NumberFormat
  Constant format string for the Euro currency symbol where it precedes the format
CURRENCY_EURO_SUFFIX - Static variable in class jxl.write.NumberFormat
  Constant format string for the Euro currency symbol where it precedes the format
CURRENCY_JAPANESE_YEN - Static variable in class jxl.write.NumberFormat
  Constant format string for the Japanese Yen sign
CURRENCY_POUND - Static variable in class jxl.write.NumberFormat
  Constant format string for the UK pound sign

## D

D - Static variable in class jxl.format.PaperSize
  D 22" x 34"
DARK_BLUE - Static variable in class jxl.format.Colour
DARK_BLUE2 - Static variable in class jxl.format.Colour
DARK_GREEN - Static variable in class jxl.format.Colour
DARK_PURPLE - Static variable in class jxl.format.Colour
DARK_RED - Static variable in class jxl.format.Colour
DARK_RED2 - Static variable in class jxl.format.Colour
DARK_TEAL - Static variable in class jxl.format.Colour
DARK_YELLOW - 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
DATE - Static variable in class jxl.CellType
DATE_FORMULA - Static variable in class jxl.CellType
DateCell - Interface in jxl
  A date cell
DateFormat - Class in jxl.write
  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.
DateFormats - Class in jxl.write
  Static class which contains Excels predefined Date formats
DateFormats() - Constructor for class jxl.write.DateFormats
DateFormulaCell - Interface in jxl
  A mixin interface for date formulas, which combines the interfaces for formulas and for dates
DateTime - Class in jxl.write
  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(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.
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
DEFAULT - Static variable in class jxl.write.DateFormats
  The default format.
DEFAULT - Static variable in class jxl.write.NumberFormats
  The default format.
DEFAULT_BACKGROUND - Static variable in class jxl.format.Colour
DEFAULT_BACKGROUND1 - Static variable in class jxl.format.Colour
DEFAULT_DEFAULT_ROW_HEIGHT - Static variable in class jxl.SheetSettings
  The default value for the default row height
DEFAULT_POINT_SIZE - Static variable in class jxl.write.WritableFont
  The default point size for all Fonts
Demo - Class in jxl.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
depUsed() - Method in class jxl.CellView
  Accessor for the depUsed attribute
DOTTED - Static variable in class jxl.format.BorderLineStyle
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.
DOUBLE_JAPANESE_POSTCARD - Static variable in class jxl.format.PaperSize
  Dbl.
DOUBLE_JAPANESE_POSTCARD_ROTATED - Static variable in class jxl.format.PaperSize
  Dbl.
DOWN_THEN_RIGHT - Static variable in class jxl.format.PageOrder
  Top to Down then Right.

## E

E - Static variable in class jxl.format.PaperSize
  E 34" x 44"
empty() - Method in class jxl.HeaderFooter.Contents
  Queries if the contents are empty
EMPTY - Static variable in class jxl.CellType
  An empty cell can still contain formatting information and comments
ENVELOPE_10 - Static variable in class jxl.format.PaperSize
  Envelope #10 4 1/8" x 9.5"
ENVELOPE_11 - Static variable in class jxl.format.PaperSize
  Envelope #11 4.5" x 10 3/8"
ENVELOPE_12 - Static variable in class jxl.format.PaperSize
  Envelope #12 4.75" x 11"
ENVELOPE_14 - Static variable in class jxl.format.PaperSize
  Envelope #14 5" x 11.5"
ENVELOPE_6_75 - Static variable in class jxl.format.PaperSize
  6.75 Envelope 3 5/8" × 6.5"
ENVELOPE_9 - Static variable in class jxl.format.PaperSize
  Envelope #9 3 7/8" x 8 7/8"
ENVELOPE_C3 - Static variable in class jxl.format.PaperSize
  Envelope C3 324mm × 458mm
ENVELOPE_C4 - Static variable in class jxl.format.PaperSize
  Envelope C4 229mm × 324mm
ENVELOPE_C5 - Static variable in class jxl.format.PaperSize
  Envelope C5 162mm × 229mm
ENVELOPE_C6 - Static variable in class jxl.format.PaperSize
  Envelope C6 114mm × 162mm
ENVELOPE_C6_C5 - Static variable in class jxl.format.PaperSize
  Envelope C6/C5 114mm × 229mm
ENVELOPE_DL - Static variable in class jxl.format.PaperSize
  Envelope DL 110mm × 220mm
ENVELOPE_INVITE - Static variable in class jxl.format.PaperSize
  Envelope Invite 220mm × 220mm
ENVELOPE_ITALY - Static variable in class jxl.format.PaperSize
  Envelope Italy 110mm × 230mm
ENVELOPE_MONARCH - Static variable in class jxl.format.PaperSize
  Envelope Monarch 3 7/8" × 7.5"
EQUAL - Static variable in class jxl.write.WritableCellFeatures
ERROR - Static variable in class jxl.CellType
ErrorCell - Interface in jxl
  This type represents a cell which contains an error.
ErrorFormulaCell - Interface in jxl
  A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
Escher - Class in jxl.demo
  Displays the escher data
Escher(Workbook, OutputStream, String) - Constructor for class jxl.demo.Escher
  Constructor
EscherDrawingGroup - Class in jxl.demo
  Displays the escher data
EscherDrawingGroup(Workbook, OutputStream, String) - Constructor for class jxl.demo.EscherDrawingGroup
  Constructor
EXECUTIVE - Static variable in class jxl.format.PaperSize
  Executive 7.25" x 10.5"
EXPONENTIAL - Static variable in class jxl.write.NumberFormats
  Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00"

## F

Features - Class in jxl.demo
  Goes through each cell in the workbook, and if the cell has any features associated with, it prints out the cell contents and the features
Features(Workbook, OutputStream, String) - Constructor for class jxl.demo.Features
  Constructor
FILL - Static variable in class jxl.format.Alignment
  Data in cells with this alignment will fill the cell
findByName(String) - Method in class jxl.Workbook
  Gets the named range from this workbook.
findByName(String) - Method in class jxl.write.WritableWorkbook
  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, int, int, int, int, boolean) - Method in interface jxl.Sheet
  Gets the cell whose contents match the string passed in.
findCell(Pattern, int, int, int, int, boolean) - Method in interface jxl.Sheet
  Gets the cell whose contents match the regular expressionstring passed in.
findCellByName(String) - Method in class jxl.Workbook
  Gets the named cell from this workbook.
findCellByName(String) - Method in class jxl.write.WritableWorkbook
  Gets the named cell from this workbook.
findLabelCell(String) - Method in interface jxl.Sheet
  Gets the cell whose contents match the string passed in.
FLOAT - Static variable in class jxl.write.NumberFormats
  Formatting for a float.
FOLIO - Static variable in class jxl.format.PaperSize
  Folio 8.5" x 13"
Font - Class in jxl.write
  Deprecated.
  Renamed to writable font
Font - Interface in jxl.format
  Interface which exposes the user font display information to the user
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
Format - Interface in jxl.format
  Exposes the cell formatting information
FORMAT1 - Static variable in class jxl.write.DateFormats
  The default format.
FORMAT1 - Static variable in class jxl.write.NumberFormats
  Equivalent to a DecimalFormat "#,##0;(#,##0)"
FORMAT10 - Static variable in class jxl.write.DateFormats
  Equivalent to a date format of "mm:ss"
FORMAT10 - Static variable in class jxl.write.NumberFormats
  Equivalent to DecimalFormat "##0.0E0"
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.DateFormats
  Equivalent to a date format of "d-MMM-yy"
FORMAT2 - Static variable in class jxl.write.NumberFormats
  Equivalent to FORMAT1 except deficits are coloured red
FORMAT3 - Static variable in class jxl.write.DateFormats
  Equivalent to a date format of "d-MMM"
FORMAT3 - Static variable in class jxl.write.NumberFormats
  Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
FORMAT4 - Static variable in class jxl.write.DateFormats
  Equivalent to a date format of "MMM-yy"
FORMAT4 - Static variable in class jxl.write.NumberFormats
  Equivalent to FORMAT3 except deficits are coloured red
FORMAT5 - Static variable in class jxl.write.DateFormats
  Equivalent to a date format of "h:mm a"
FORMAT5 - Static variable in class jxl.write.NumberFormats
  Equivalent to DecimalFormat "#,##0;(#,##0)"
FORMAT6 - Static variable in class jxl.write.DateFormats
  Equivalent to a date format of "h:mm:ss a"
FORMAT6 - Static variable in class jxl.write.NumberFormats
  Equivalent to FORMAT5 except deficits are coloured red
FORMAT7 - Static variable in class jxl.write.DateFormats
  Equivalent to a date format of "H:mm"
FORMAT7 - Static variable in class jxl.write.NumberFormats
  Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
FORMAT8 - Static variable in class jxl.write.DateFormats
  Equivalent to a date format of "H:mm:ss"
FORMAT8 - Static variable in class jxl.write.NumberFormats
  Equivalent to FORMAT7 except deficits are coloured red
FORMAT9 - Static variable in class jxl.write.DateFormats
  Equivalent to a date format of "M/d/yy H:mm"
FORMAT9 - Static variable in class jxl.write.NumberFormats
  Equivalent to FORMAT7
Formula - Class in jxl.write
  A cell, created by user applications, which contains a numerical value
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
FORMULA_ERROR - Static variable in class jxl.CellType
FormulaCell - Interface in jxl
  Interface for formulas which allow clients to read the Excel formula
Formulas - Class in jxl.demo
  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
FRACTION_HALVES - Static variable in class jxl.write.NumberFormat
  Constant format string for fractions as halves
FRACTION_HUNDREDTHS - Static variable in class jxl.write.NumberFormat
  Constant format string for fractions as hundredths
FRACTION_ONE_DIGIT - Static variable in class jxl.write.NumberFormats
  Formatting for one digit fractions
FRACTION_QUARTERS - Static variable in class jxl.write.NumberFormat
  Constant format string for fractions as quarter
FRACTION_SIXTEENTHS - Static variable in class jxl.write.NumberFormat
  Constant format string for fractions as sixteenths
FRACTION_TENTHS - Static variable in class jxl.write.NumberFormat
  Constant format string for fractions as tenths
FRACTION_THREE_DIGITS - Static variable in class jxl.write.NumberFormat
  Constant format string for three digit fractions
FRACTION_TWO_DIGITS - Static variable in class jxl.write.NumberFormats
  Formatting for two digit fractions
FRACTIONS_EIGHTHS - Static variable in class jxl.write.NumberFormat
  Constant format string for fractions as eighths

## G

GENERAL - Static variable in class jxl.format.Alignment
  The standard alignment
GERMAN_FANFOLD - Static variable in class jxl.format.PaperSize
  German Std.
GERMAN_LEGAL_FANFOLD - Static variable in class jxl.format.PaperSize
  German Legal Fanfold 8.5" × 13"
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
getAllColours() - Static method in class jxl.format.Colour
  Returns all available colours - used when generating the default palette
getArrayGrowSize() - Method in class jxl.WorkbookSettings
  Accessor for the array grow size property
getAutoFilterDisabled() - Method in class jxl.WorkbookSettings
  Accessor for the autofilter disabled feature
getAutomaticFormulaCalculation() - Method in class jxl.SheetSettings
  Retrieves the automatic formula calculation flag
getBackgroundColour() - Method in interface jxl.format.CellFormat
  Gets the background colour used by this cell
getBlue() - Method in class jxl.format.RGB
  Accessor for the blue component
getBoldWeight() - Method in interface jxl.format.Font
  Gets the bold weight for this font
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
getBorderColour(Border) - Method in interface jxl.format.CellFormat
  Gets the colour for the given cell border If a border type of ALL or NONE is specified, then a line style of NONE is returned If the specified cell does not have an associated line style, then the colour the line would be is still returned
getBorderLine(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
getCell(int, int) - Method in interface jxl.Sheet
  Returns the cell specified at this row and at this column.
getCell(String) - Method in interface jxl.Sheet
  Returns the cell for the specified location eg.
getCell(String) - Method in class jxl.Workbook
  Returns the cell for the specified location eg.
getCellFeatures() - Method in interface jxl.Cell
  Gets any special cell features, such as comments (notes) or cell validation present for this cell
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.
getCellReference(int, boolean, int, boolean, StringBuffer) - Static method in class jxl.CellReferenceHelper
  Overloaded method which prepends $ for absolute reference
getCellReference(int, int) - Static method in class jxl.CellReferenceHelper
  Gets the cell reference for the specified column and row
getCellReference(int, int, boolean, int, boolean, Workbook, StringBuffer) - Static method in class jxl.CellReferenceHelper
  Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, int, Workbook) - Static method in class jxl.CellReferenceHelper
  Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, int, Workbook, StringBuffer) - Static method in class jxl.CellReferenceHelper
  Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, int, WritableWorkbook) - Static method in class jxl.CellReferenceHelper
  Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, int, WritableWorkbook, StringBuffer) - Static method in class jxl.CellReferenceHelper
  Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, StringBuffer) - Static method in class jxl.CellReferenceHelper
  Appends the cell reference for the column and row passed in to the string buffer
getCellReference(Cell) - Static method in class jxl.CellReferenceHelper
  Gets the cell reference for the cell
getCellReference(Cell, StringBuffer) - Static method in class jxl.CellReferenceHelper
  Gets the cell reference for the cell
getCellValidationDisabled() - Method in class jxl.WorkbookSettings
  Accessor for the ignore cell validation
getCentre() - Method in class jxl.HeaderFooter
  Accessor for the contents which in the centre of the page
getCharacterSet() - Method in class jxl.WorkbookSettings
  Accessor for the character set.
getColour() - Method in interface jxl.format.Font
  Gets the colour for this font
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 interface jxl.Image
  Accessor for the image position
getColumn() - Method in class jxl.write.WritableImage
  Accessor for the image position
getColumn(int) - Method in interface jxl.Sheet
  Gets all the cells on the specified column
getColumn(String) - Static method in class jxl.CellReferenceHelper
  Gets the columnn number of the string cell reference
getColumnFormat(int) - Method in interface jxl.Sheet
  Deprecated.
  Use getColumnView and the CellView bean instead
getColumnPageBreaks() - Method in interface jxl.Sheet
  Accessor for the page breaks on this sheet
getColumnReference(int) - Static method in class jxl.CellReferenceHelper
  Gets the column letter corresponding to the 0-based column number
getColumns() - Method in interface jxl.Sheet
  Returns the number of columns in this sheet
getColumnView(int) - Method in interface jxl.Sheet
  Gets the column width for the specified column
getColumnWidth(int) - Method in interface jxl.Sheet
  Deprecated.
  Use getColumnView instead
getComment() - Method in class jxl.CellFeatures
  Accessor for the cell comment
getContents() - Method in interface jxl.Cell
  Quick and dirty function to return the contents of this cell as a string.
getCopies() - Method in class jxl.SheetSettings
  Accessor for the number of copies to print
getDataValidationList() - Method in class jxl.CellFeatures
  Gets the data validation list
getDate() - Method in interface jxl.DateCell
  Gets the date contained in this cell
getDateFormat() - Method in interface jxl.DateCell
  Gets the DateFormat used to format the cell.
getDefaultBlue() - Method in class jxl.format.Colour
  Deprecated.
  use getDefaultRGB instead
getDefaultColumnWidth() - Method in class jxl.SheetSettings
  Accessor for the default column width
getDefaultGreen() - Method in class jxl.format.Colour
  Deprecated.
  use getDefaultRGB instead
getDefaultHeightMargin() - Method in class jxl.SheetSettings
  Gets the default margin height
getDefaultRed() - Method in class jxl.format.Colour
  Deprecated.
  use getDefaultRGB instead
getDefaultRGB() - Method in class jxl.format.Colour
  Returns the default RGB of the colour
getDefaultRowHeight() - Method in class jxl.SheetSettings
  Accessor for the default row height
getDefaultWidthMargin() - Method in class jxl.SheetSettings
  Gets the default margin width
getDescription() - Method in class jxl.format.Alignment
  Gets the string description of this alignment
getDescription() - Method in class jxl.format.BoldStyle
  Gets the string description of the bold style
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.Colour
  Gets the string description for display purposes
getDescription() - Method in class jxl.format.Orientation
  Gets the textual description
getDescription() - Method in class jxl.format.Pattern
  Gets the textual description
getDescription() - Method in class jxl.format.ScriptStyle
  Gets the string description for display purposes
getDescription() - Method in class jxl.format.UnderlineStyle
  Gets the string description for display purposes
getDescription() - Method in class jxl.format.VerticalAlignment
  Gets the textual description
getDimension() - Method in class jxl.CellView
  Deprecated.
  use getSize() instead
getDisplayZeroValues() - Method in class jxl.SheetSettings
  Accessor for the displayZeroValues property
getDrawing(int) - Method in interface jxl.Sheet
  Accessor for the image
getDrawingsDisabled() - Method in class jxl.WorkbookSettings
  Gets the drawings disabled flag
getEncoding() - Method in class jxl.WorkbookSettings
  Accessor for the character encoding
getErrorCode() - Method in interface jxl.ErrorCell
  Gets the error code for this cell.
getExcel9File() - Method in class jxl.WorkbookSettings
  Has this file been written by excel 2000?
getExcelDisplayLanguage() - Method in class jxl.WorkbookSettings
  Returns the two character ISO 3166 mnemonic used by excel for user language displayto display
getExcelRegionalSettings() - Method in class jxl.WorkbookSettings
  Returns the two character ISO 3166 mnemonic used by excel for its regional settings
getFile() - Method in interface jxl.Hyperlink
  Returns the local file eferenced by this Hyperlink
getFirstSheetIndex() - Method in interface jxl.Range
  Gets the index of the first sheet in the range
getFitHeight() - Method in class jxl.SheetSettings
  Accessor for the fit height
getFitToPages() - Method in class jxl.SheetSettings
  Accessor for the fit width print flag
getFitWidth() - Method in class jxl.SheetSettings
  Accessor for the fit width
getFont() - Method in interface jxl.format.CellFormat
  Gets the font information used by this format
getFooter() - Method in class jxl.SheetSettings
  Accessor for the footer
getFooterMargin() - Method in class jxl.SheetSettings
  Accessor for the footer margin
getFormat() - Method in class jxl.CellView
  Accessor for the cell format for this group.
getFormat() - Method in interface jxl.format.CellFormat
  Gets the format used by this format
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
getFormula() - Method in interface jxl.FormulaCell
  Gets the formula as a string
getFormulaAdjust() - Method in class jxl.WorkbookSettings
  Accessor for the formula adjust disabled
getFunctionNames() - Method in class jxl.WorkbookSettings
  Gets the function names.
getGCDisabled() - Method in class jxl.WorkbookSettings
  Accessor for the disabling of garbage collection
getGreen() - Method in class jxl.format.RGB
  Accessor for the green component
getHeader() - Method in class jxl.SheetSettings
  Accessor for the header
getHeaderMargin() - Method in class jxl.SheetSettings
  Accessor for the header margin
getHeight() - Method in interface jxl.Image
  Accessor for the image dimensions
getHeight() - Method in class jxl.write.WritableImage
  Accessor for the image dimensions
getHeight(LengthUnit) - Method in interface jxl.Image
  Get the height of this image as rendered within Excel
getHideobj() - Method in class jxl.WorkbookSettings
  The HIDEOBJ record stores options selected in the Options dialog,View tab Possible values are: HIDEOBJ_HIDE_ALL, HIDEOBJ_SHOW_ALL and HIDEOBJ_SHOW_PLACEHOLDERS
getHorizontalFreeze() - Method in class jxl.SheetSettings
  Gets the row at which the pane is frozen horizontally
getHorizontalPrintResolution() - Method in class jxl.SheetSettings
  Accessor for the horizontal print resolution
getHorizontalResolution(LengthUnit) - Method in interface jxl.Image
  Gets the horizontal resolution of the image, if that information is available.
getHyperlinks() - Method in interface jxl.Sheet
  Gets the hyperlinks on this sheet
getIgnoreBlanks() - Method in class jxl.WorkbookSettings
  Accessor for the ignore blanks flag
getImage(int) - Method in interface jxl.write.WritableSheet
  Accessor for the image
getImageAnchor() - Method in class jxl.write.WritableImage
  Accessor for the anchor properties
getImageData() - Method in interface jxl.Image
  Accessor for the image data
getImageData() - Method in class jxl.write.WritableImage
  Accessor for the image data
getImageFile() - Method in interface jxl.Image
  Accessor for the image file
getImageFile() - Method in class jxl.write.WritableImage
  Accessor for the image file
getImageHeight() - Method in interface jxl.Image
  Gets the height of the image.
getImageWidth() - Method in interface jxl.Image
  Gets the width of the image.
getIndentation() - Method in interface jxl.format.CellFormat
  Gets the indentation of the cell text
getInitialFileSize() - Method in class jxl.WorkbookSettings
  Accessor for the initial file size property
getInternalColour(int) - Static method in class jxl.format.Colour
  Gets the internal colour from the value
getLastColumn() - Method in interface jxl.Hyperlink
  Returns the column number of the bottom right cell
getLastRow() - Method in interface jxl.Hyperlink
  Returns the row number of the bottom right cell
getLastSheetIndex() - Method in interface jxl.Range
  Gets the index of the last sheet in the range
getLeft() - Method in class jxl.HeaderFooter
  Accessor for the contents which appear on the left hand side of the page
getLeftMargin() - Method in class jxl.SheetSettings
  Accessor for the left margin
getLocale() - Method in class jxl.WorkbookSettings
  Returns the locale used by JExcelAPI to read the spreadsheet
getMergedCellCheckingDisabled() - Method in class jxl.WorkbookSettings
  Accessor to retrieve the merged cell checking flag
getMergedCells() - Method in interface jxl.Sheet
  Gets the cells which have been merged on this sheet
getName() - Method in interface jxl.format.Font
  Gets the name of this font
getName() - Method in interface jxl.Sheet
  Gets the name of this sheet
getNamesDisabled() - Method in class jxl.WorkbookSettings
  Accessor for the disabling of interpretation of named ranges
getNormalMagnification() - Method in class jxl.SheetSettings
  Accessor for the nomral view magnificaton factor.
getNumberFormat() - Method in interface jxl.NumberCell
  Gets the NumberFormat used to format this cell.
getNumberOfImages() - Method in interface jxl.Sheet
  Accessor for the number of images on the sheet
getNumberOfImages() - Method in interface jxl.write.WritableSheet
  Accessor for the number of images on the sheet
getNumberOfSheets() - Method in class jxl.Workbook
  Returns the number of sheets in this workbook
getNumberOfSheets() - Method in class jxl.write.WritableWorkbook
  Returns the number of sheets in this workbook
getOrientation() - Method in interface jxl.format.CellFormat
  Gets the orientation
getOrientation() - Method in class jxl.SheetSettings
  Accessor for the orientation
getOrientation(int) - Static method in class jxl.format.Orientation
  Gets the alignment from the value
getPageBreakPreviewMagnification() - Method in class jxl.SheetSettings
  Accessor for the page break preview mangificaton factor.
getPageBreakPreviewMode() - Method in class jxl.SheetSettings
  Accessor for the pageBreakPreview mode
getPageOrder() - Method in class jxl.SheetSettings
  Accessor for the order
getPageStart() - Method in class jxl.SheetSettings
  Accessor for the page start
getPaperSize() - Method in class jxl.SheetSettings
  Accessor for the paper size
getPaperSize(int) - Static method in class jxl.format.PaperSize
  Gets the paper size for a specific value
getPassword() - Method in class jxl.SheetSettings
  Accessor for the password
getPasswordHash() - Method in class jxl.SheetSettings
  Accessor for the password hash - used only when copying sheets
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 interface jxl.format.Font
  Gets the point size for this font, if the font hasn't been initialized
getPrintArea() - Method in class jxl.SheetSettings
  Accessor for the print area
getPrintGridLines() - Method in class jxl.SheetSettings
  Accessor for the printGridLines property
getPrintHeaders() - Method in class jxl.SheetSettings
  Accessor for the printHeaders property
getPrintTitlesCol() - Method in class jxl.SheetSettings
  Accessor for the print column titles
getPrintTitlesRow() - Method in class jxl.SheetSettings
  Accessor for the print row titles
getPropertySetsDisabled() - Method in class jxl.WorkbookSettings
  Accessor to retrieve the property sets disabled flag
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
getRangeNames() - Method in class jxl.Workbook
  Gets the named ranges
getRangeNames() - Method in class jxl.write.WritableWorkbook
  Gets the named ranges
getRationalizationDisabled() - Method in class jxl.WorkbookSettings
  Accessor to retrieve the rationalization flag
getRecalculateFormulasBeforeSave() - Method in class jxl.SheetSettings
  Retrieves the recalculate formulas before save flag
getRed() - Method in class jxl.format.RGB
  Accessor for the red component
getRefreshAll() - Method in class jxl.WorkbookSettings
  When true then Refresh All should be done on all external data ranges and PivotTables when loading the workbook (the default is =0)
getRight() - Method in class jxl.HeaderFooter
  Accessor for the contents which appear on the right hand side of the page
getRightMargin() - Method in class jxl.SheetSettings
  Accessor for the right margin
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 interface jxl.Image
  Accessor for the image position
getRow() - Method in class jxl.write.WritableImage
  Accessor for the image position
getRow(int) - Method in interface jxl.Sheet
  Gets all the cells on the specified row
getRow(String) - Static method in class jxl.CellReferenceHelper
  Gets the row number of the cell reference
getRowHeight(int) - Method in interface jxl.Sheet
  Deprecated.
  use getRowView instead
getRowPageBreaks() - Method in interface jxl.Sheet
  Accessor for the page breaks on this sheet
getRows() - Method in interface jxl.Sheet
  Returns the number of rows in this sheet
getRowView(int) - Method in interface jxl.Sheet
  Gets the row height for the specified column
getScaleFactor() - Method in class jxl.SheetSettings
  Accessor for the scale factor
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
getSharedDataValidationRange() - Method in class jxl.CellFeatures
  Gets the range of cells to which the data validation applies.
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.write.WritableWorkbook
  Gets the specified sheet within this workbook
getSheet(String) - Static method in class jxl.CellReferenceHelper
  Gets the sheet name from the cell reference string
getSheet(String) - Method in class jxl.Workbook
  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
getSheetNames() - Method in class jxl.Workbook
  Gets the sheet names
getSheetNames() - Method in class jxl.write.WritableWorkbook
  Gets the sheet names
getSheets() - Method in class jxl.Workbook
  Gets the sheets within this workbook.
getSheets() - Method in class jxl.write.WritableWorkbook
  Gets the sheets within this workbook.
getShowGridLines() - Method in class jxl.SheetSettings
  Accessor for the showGridLines property
getSize() - Method in class jxl.CellView
  Gets the width of the column in characters multiplied by 256, or the height of the row in 1/20ths of a point
getString() - Method in interface jxl.LabelCell
  Gets the label for this cell.
getStyle(int) - Static method in class jxl.format.BorderLineStyle
  Gets the alignment from the value
getStyle(int) - Static method in class jxl.format.ScriptStyle
  Gets the ScriptStyle from the value
getStyle(int) - Static method in class jxl.format.UnderlineStyle
  Gets the UnderlineStyle from the value
getTemplate() - Method in class jxl.WorkbookSettings
  Workbook Is a Template
getTemporaryFileDuringWriteDirectory() - Method in class jxl.WorkbookSettings
  Used in conjunction with the UseTemporaryFileDuringWrite setting to set the target directory for the temporary files.
getTopLeft() - Method in interface jxl.Range
  Gets the cell at the top left of this range
getTopMargin() - Method in class jxl.SheetSettings
  Accessor for the top margin
getType() - Method in interface jxl.Cell
  Returns the content type of this cell
getUnderlineStyle() - Method in interface jxl.format.Font
  Gets the underline style for this font
getURL() - Method in interface jxl.Hyperlink
  Gets the URL referenced by this Hyperlink
getUseTemporaryFileDuringWrite() - Method in class jxl.WorkbookSettings
  Accessor for the temporary file during write.
getValue() - Method in interface jxl.BooleanCell
  Gets the boolean value stored in this cell.
getValue() - Method in class jxl.format.Alignment
  Gets the value of this alignment.
getValue() - Method in class jxl.format.BoldStyle
  Gets the value of the bold weight.
getValue() - Method in class jxl.format.BorderLineStyle
  Gets the value for this line style
getValue() - Method in class jxl.format.Colour
  Gets the value of this colour.
getValue() - Method in class jxl.format.Orientation
  Accessor for the binary value
getValue() - Method in class jxl.format.PaperSize
  Accessor for the internal binary value association with this paper size
getValue() - Method in class jxl.format.Pattern
  Gets the value of this pattern.
getValue() - Method in class jxl.format.ScriptStyle
  Gets the value of this style.
getValue() - Method in class jxl.format.UnderlineStyle
  Gets the value of this style.
getValue() - Method in class jxl.format.VerticalAlignment
  Accessor for the binary value
getValue() - Method in interface jxl.NumberCell
  Gets the double contents for this cell.
getVersion() - Static method in class jxl.Workbook
  Accessor for the software version
getVerticalAlignment() - Method in interface jxl.format.CellFormat
  Gets the vertical cell alignment
getVerticalFreeze() - Method in class jxl.SheetSettings
  Gets the column at which the pane is frozen vertically
getVerticalPrintResolution() - Method in class jxl.SheetSettings
  Accessor for the vertical print resolution
getVerticalResolution(LengthUnit) - Method in interface jxl.Image
  Gets the vertical resolution of the image, if that information is available.
getWidth() - Method in interface jxl.Image
  Accessor for the image dimensions
getWidth() - Method in class jxl.write.WritableImage
  Accessor for the image dimensions
getWidth(LengthUnit) - Method in interface jxl.Image
  Get the width of this image as rendered within Excel
getWindowProtected() - Method in class jxl.WorkbookSettings
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.
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(String) - Method in interface jxl.write.WritableSheet
  Returns the cell for the specified location eg.
getWritableCell(String) - Method in class jxl.write.WritableWorkbook
  Returns the cell for the specified location eg.
getWritableCellFeatures() - Method in interface jxl.write.WritableCell
  Accessor for the cell features
getWritableHyperlinks() - Method in interface jxl.write.WritableSheet
  Gets the writable hyperlinks from this sheet.
getWriteAccess() - Method in class jxl.WorkbookSettings
getZoomFactor() - Method in class jxl.SheetSettings
  Accessor for the zoom factor.
GMT - Static variable in class jxl.write.DateTime
  Instance variable for dummy variable overload
GOLD - Static variable in class jxl.format.Colour
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.write.WritableCellFeatures
GREATER_THAN - Static variable in class jxl.write.WritableCellFeatures
GREEN - Static variable in class jxl.format.Colour
GREY_25_PERCENT - Static variable in class jxl.format.Colour
GREY_40_PERCENT - Static variable in class jxl.format.Colour
GREY_50_PERCENT - Static variable in class jxl.format.Colour
GREY_80_PERCENT - Static variable in class jxl.format.Colour

## H

HAIR - Static variable in class jxl.format.BorderLineStyle
hasBorders() - Method in interface jxl.format.CellFormat
  Determines if this cell format has any borders at all.
HeaderFooter - Class in jxl
  Class which represents an Excel header or footer.
HeaderFooter() - Constructor for class jxl.HeaderFooter
  Default constructor.
HeaderFooter(String) - Constructor for class jxl.HeaderFooter
  Constructor used when reading workbooks to separate the left, right a central part of the strings into their constituent parts
HeaderFooter(HeaderFooter) - Constructor for class jxl.HeaderFooter
  Copy constructor
HeaderFooter.Contents - Class in jxl
  The contents - a simple wrapper around a string buffer
HIDDEN_STYLE - Static variable in class jxl.write.WritableWorkbook
  A cell format used to hide the cell contents
HIDEOBJ_HIDE_ALL - Static variable in class jxl.WorkbookSettings
  The HIDEOBJ record stores options selected in the Options dialog,View tab.
HIDEOBJ_SHOW_ALL - Static variable in class jxl.WorkbookSettings
  The HIDEOBJ record stores options selected in the Options dialog,View tab.
HIDEOBJ_SHOW_PLACEHOLDERS - Static variable in class jxl.WorkbookSettings
  The HIDEOBJ record stores options selected in the Options dialog,View tab.
HORIZONTAL - Static variable in class jxl.format.Orientation
  Cells with this specified orientation will be horizontal
Hyperlink - Interface in jxl
  Hyperlink information.
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

## I

ICE_BLUE - Static variable in class jxl.format.Colour
Image - Interface in jxl
  Accessor functions for an image
importSheet(String, int, Sheet) - Method in class jxl.write.WritableWorkbook
  Imports a sheet from a different workbook.
INDIGO - Static variable in class jxl.format.Colour
insertColumn(int) - Method in interface jxl.write.WritableSheet
  Inserts a blank column into this spreadsheet.
insertRow(int) - Method in interface jxl.write.WritableSheet
  Inserts a blank row into this spreadsheet.
INTEGER - Static variable in class jxl.write.NumberFormats
  Formatting for an integer number.
isAutosize() - Method in class jxl.CellView
  Accessor for the autosize flag NOTE: use of the autosize function is very processor intensive, so use with care
isColumnRelative(String) - Static method in class jxl.CellReferenceHelper
  Sees if the column component is relative or not
isFile() - Method in interface jxl.Hyperlink
  Determines whether this is a hyperlink to a file
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 class jxl.CellView
  Accessor for the hidden nature of this row/column
isHidden() - Method in interface jxl.Sheet
  Deprecated.
  in favour of the getSettings() method
isHidden() - Method in class jxl.SheetSettings
  Accessor for the hidden nature of this sheet
isHorizontalCentre() - Method in class jxl.SheetSettings
  Accessor for the horizontal centre
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
isLocked() - Method in interface jxl.format.CellFormat
  Accessor for whether a particular cell is locked
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.Workbook
  Determines whether the sheet is protected
isRowRelative(String) - Static method in class jxl.CellReferenceHelper
  Sees if the row component is relative or not
isSelected() - Method in class jxl.SheetSettings
  Accessor for the selected nature of the sheet
isShrinkToFit() - Method in interface jxl.format.CellFormat
  Gets the shrink to fit flag
isStruckout() - Method in interface jxl.format.Font
  Returns the strike-out flag
isStruckout() - Method in class jxl.write.WritableFont
  Accessor for the strike-out flag
isTime() - Method in interface jxl.DateCell
  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
isVerticalCentre() - Method in class jxl.SheetSettings
  Accessor for the vertical centre
IVORY - Static variable in class jxl.format.Colour

## J

JAPANESE_POSTCARD - Static variable in class jxl.format.PaperSize
  Japanese Postcard 100mm × 148mm
JAPANESE_POSTCARD_ROTATED - Static variable in class jxl.format.PaperSize
  Japanese Postcard Rot.
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.demo - package jxl.demo
jxl.format - package jxl.format
jxl.write - package jxl.write
JXLException - Exception Class in jxl
  Base exception class for JExcelAPI exceptions

## L

Label - Class in jxl.write
  A cell containing text which may be created by user applications
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
LABEL - Static variable in class jxl.CellType
LabelCell - Interface in jxl
  A label cell
LANDSCAPE - Static variable in class jxl.format.PageOrientation
  Landscape orientation
LAVENDER - Static variable in class jxl.format.Colour
LEDGER - Static variable in class jxl.format.PaperSize
  Leger 17" x 11"
LEFT - Static variable in class jxl.format.Alignment
  Data cells with this alignment will appear at the left hand edge of the cell
LEFT - Static variable in class jxl.format.Border
LEGAL - Static variable in class jxl.format.PaperSize
  US Legal 8.5" x 14"
LEGAL_EXTRA - Static variable in class jxl.format.PaperSize
  Legal Extra 9.5" × 15"
LESS_EQUAL - Static variable in class jxl.write.WritableCellFeatures
LESS_THAN - Static variable in class jxl.write.WritableCellFeatures
LETTER - Static variable in class jxl.format.PaperSize
  US Letter 8.5 x 11"
LETTER_EXTRA - Static variable in class jxl.format.PaperSize
  Letter Extra 9.5" × 12"
LETTER_EXTRA_TRANSVERSE - Static variable in class jxl.format.PaperSize
  Letter Extra Transv.
LETTER_PLUS - Static variable in class jxl.format.PaperSize
  Letter Plus 8.5" x 12 11/16"
LETTER_ROTATED - Static variable in class jxl.format.PaperSize
  Letter Rotated 11" × 8.5"
LETTER_SMALL - Static variable in class jxl.format.PaperSize
  Letter small 8.5" × 11"
LETTER_TRANSVERSE - Static variable in class jxl.format.PaperSize
  Letter Transverse 8.5" × 11"
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
LIGHT_TURQUOISE - Static variable in class jxl.format.Colour
LIGHT_TURQUOISE2 - Static variable in class jxl.format.Colour
LIME - Static variable in class jxl.format.Colour

## M

main(String[]) - Static method in class jxl.demo.Demo
  The main method.
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.
MINUS_45 - Static variable in class jxl.format.Orientation
  Cells with this specified orientation will have their data presented with a rotation 45 degrees downwards
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 downwards
MOVE_AND_SIZE_WITH_CELLS - Static variable in class jxl.write.WritableImage
  Image anchor properties which will move and resize an image along with the cells
MOVE_WITH_CELLS - Static variable in class jxl.write.WritableImage
  Image anchor properties which will move an image when cells are inserted or deleted
moveSheet(int, int) - Method in class jxl.write.WritableWorkbook
  Moves the specified sheet within this workbook to another index position.

## N

NO_BOLD - Static variable in class jxl.write.Font
  Deprecated.
NO_BOLD - Static variable in class jxl.write.WritableFont
  Indicates that this font should not be presented as bold
NO_MOVE_OR_SIZE_WITH_CELLS - Static variable in class jxl.write.WritableImage
  Image anchor properties which will leave an image unaffected when other cells are inserted, removed or resized
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
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
NOT_BETWEEN - Static variable in class jxl.write.WritableCellFeatures
NOT_EQUAL - Static variable in class jxl.write.WritableCellFeatures
NOTE - Static variable in class jxl.format.PaperSize
  NOTE 8.5" x 11"
Number - Class in jxl.write
  A cell, created by user applications, which contains a numerical value
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
NUMBER - Static variable in class jxl.CellType
NUMBER_FORMULA - Static variable in class jxl.CellType
NumberCell - Interface in jxl
  A cell which contains a numerical value
NumberFormat - Class in jxl.write
  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
NumberFormat(String, NumberFormatRecord.NonValidatingFormat) - Constructor for class jxl.write.NumberFormat
  Constructor, taking in the non-Java compliant number format.
NumberFormats - Class in jxl.write
  Static class which contains the available list of built in Number formats
NumberFormats() - Constructor for class jxl.write.NumberFormats
NumberFormulaCell - Interface in jxl
  A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers

## O

OCEAN_BLUE - Static variable in class jxl.format.Colour
OLIVE_GREEN - Static variable in class jxl.format.Colour
ORANGE - Static variable in class jxl.format.Colour
Orientation - Class in jxl.format
  Enumeration type which describes the orientation of data within a cell

## P

PageOrder - Class in jxl.format
  Enumeration type which describes the page orientation
PageOrientation - Class in jxl.format
  Enumeration type which describes the page orientation
PALE_BLUE - Static variable in class jxl.format.Colour
PALETTE_BLACK - Static variable in class jxl.format.Colour
PaperSize - Class in jxl.format
  Enumeration type which contains the available excel paper sizes and their codes
Pattern - Class in jxl.format
  Enumeration class which contains the various patterns available within the standard Excel pattern palette
Pattern - Class in jxl.write
  Deprecated.
  Repackaged as jxl.format.Pattern
PATTERN1 - Static variable in class jxl.format.Pattern
PATTERN10 - Static variable in class jxl.format.Pattern
PATTERN11 - Static variable in class jxl.format.Pattern
PATTERN12 - Static variable in class jxl.format.Pattern
PATTERN13 - Static variable in class jxl.format.Pattern
PATTERN14 - Static variable in class jxl.format.Pattern
PATTERN2 - Static variable in class jxl.format.Pattern
PATTERN3 - Static variable in class jxl.format.Pattern
PATTERN4 - Static variable in class jxl.format.Pattern
PATTERN5 - Static variable in class jxl.format.Pattern
PATTERN6 - Static variable in class jxl.format.Pattern
PATTERN7 - Static variable in class jxl.format.Pattern
PATTERN8 - Static variable in class jxl.format.Pattern
PATTERN9 - Static variable in class jxl.format.Pattern
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%"
PERIWINKLE - Static variable in class jxl.format.Colour
PINK - Static variable in class jxl.format.Colour
PINK2 - Static variable in class jxl.format.Colour
PLUM - Static variable in class jxl.format.Colour
PLUM2 - Static variable in class jxl.format.Colour
PLUS_45 - Static variable in class jxl.format.Orientation
  Cells with this specified orientation will have their data presented with a rotation 45 degrees upwards
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
PORTRAIT - Static variable in class jxl.format.PageOrientation
  Portrait orientation

## Q

QUARTO - Static variable in class jxl.format.PaperSize
  Quarto 215mm x 275mm

## R

Range - Interface in jxl
  Represents a 3-D range of cells in a workbook.
readWrite() - Method in class jxl.demo.ReadWrite
  Reads in the inputFile and creates a writable copy of it called outputFile
ReadWrite - Class in jxl.demo
  Demo class which uses the api to read in a spreadsheet and generate a clone of that spreadsheet which contains the same data.
ReadWrite(String, String) - Constructor for class jxl.demo.ReadWrite
  Constructor
RED - Static variable in class jxl.format.Colour
removeColumn(int) - Method in interface jxl.write.WritableSheet
  Removes a column from this spreadsheet.
removeComment() - Method in class jxl.write.WritableCellFeatures
  Removes the cell comment, if present
removeDataValidation() - Method in class jxl.write.WritableCellFeatures
  Removes any data validation, if present
removeHyperlink(WritableHyperlink) - Method in interface jxl.write.WritableSheet
  Removes the specified hyperlink.
removeHyperlink(WritableHyperlink, boolean) - Method in interface jxl.write.WritableSheet
  Removes the specified hyperlink.
removeImage(WritableImage) - Method in interface jxl.write.WritableSheet
  Removes the specified image from the sheet.
removeRangeName(String) - Method in class jxl.write.WritableWorkbook
  Removes the specified named range from the workbook.
removeRow(int) - Method in interface jxl.write.WritableSheet
  Removes a row from this spreadsheet.
removeSharedDataValidation(WritableCell) - Method in interface jxl.write.WritableSheet
  Remove the shared data validation from multiple cells.
removeSheet(int) - Method in class jxl.write.WritableWorkbook
  Removes the sheet at the specified index from this workbook
RGB - Class in jxl.format
  A structure which contains the RGB values for a particular colour
RGB(int, int, int) - Constructor for class jxl.format.RGB
  Constructor
RIGHT - Static variable in class jxl.format.Alignment
  Data in cells with this alignment will be right aligned
RIGHT - Static variable in class jxl.format.Border
RIGHT_THEN_DOWN - Static variable in class jxl.format.PageOrder
  Left to Right then Down.
ROSE - Static variable in class jxl.format.Colour

## S

ScriptStyle - Class in jxl.format
  Enumeration class which contains the various script styles available within the standard Excel ScriptStyle palette
SEA_GREEN - Static variable in class jxl.format.Colour
setAlignment(Alignment) - Method in class jxl.write.WritableCellFormat
  Sets the horizontal alignment for this format
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.
setAutoFilterDisabled(boolean) - Method in class jxl.WorkbookSettings
  Sets the autofilter disabled
setAutomaticFormulaCalculation(boolean) - Method in class jxl.SheetSettings
  Sets the automatic formula calculation flag
setAutosize(boolean) - Method in class jxl.CellView
  Sets the autosize flag.
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
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.write.WritableCellFormat
  Sets the specified border for this format
setBorder(Border, BorderLineStyle, Colour) - Method in class jxl.write.WritableCellFormat
  Sets the specified border for this format
setBottomMargin(double) - Method in class jxl.SheetSettings
  Sets the bottom margin
setCellFeatures(WritableCellFeatures) - Method in interface jxl.write.WritableCell
  Sets the cell features
setCellFormat(CellFormat) - Method in interface jxl.write.WritableCell
  Sets the cell format for this cell
setCellValidationDisabled(boolean) - Method in class jxl.WorkbookSettings
  Sets the ignore cell validation flag
setCharacterSet(int) - Method in class jxl.WorkbookSettings
  Sets the character set.
setColour(Colour) - Method in class jxl.write.WritableFont
  Sets the colour for this font, if the font hasn't been initialized
setColourRGB(Colour, int, int, int) - Method in class jxl.write.WritableWorkbook
  Sets the RGB value for the specified colour for this workbook
setColumn(double) - Method in class jxl.write.WritableImage
  Accessor for the image position
setColumnGroup(int, int, boolean) - Method in interface jxl.write.WritableSheet
  Sets a column grouping
setColumnView(int, int) - Method in interface jxl.write.WritableSheet
  Sets the width of the column on this sheet, in characters.
setColumnView(int, int, CellFormat) - Method in interface jxl.write.WritableSheet
  Deprecated.
  Use the CellView bean instead
setColumnView(int, CellView) - Method in interface jxl.write.WritableSheet
  Sets the view for this column
setComment(String) - Method in class jxl.write.WritableCellFeatures
  Sets the cell comment
setComment(String, double, double) - Method in class jxl.write.WritableCellFeatures
  Sets the cell comment and sets the size of the text box (in cells) in which the comment is displayed
setCopies(int) - Method in class jxl.SheetSettings
  Sets the number of copies
setDataValidationList(Collection) - Method in class jxl.write.WritableCellFeatures
  The list of items to validate for this cell.
setDataValidationRange(int, int, int, int) - Method in class jxl.write.WritableCellFeatures
  The list of items to validate for this cell in the form of a cell range.
setDataValidationRange(String) - Method in class jxl.write.WritableCellFeatures
  Sets the data validation based upon a named range.
setDate(Date) - Method in class jxl.write.DateTime
  Sets the date for this cell
setDate(Date, DateRecord.GMTDate) - Method in class jxl.write.DateTime
  Sets the date for this cell, performing the necessary timezone adjustments
setDefaultColumnWidth(int) - Method in class jxl.SheetSettings
  Sets the default column width
setDefaultRowHeight(int) - Method in class jxl.SheetSettings
  Sets the default row height
setDescription(String) - Method in class jxl.write.WritableHyperlink
  Sets the description to appear in the hyperlink cell
setDimension(int) - Method in class jxl.CellView
  Deprecated.
  use the setSize method instead
setDisplayZeroValues(boolean) - Method in class jxl.SheetSettings
  Sets the displayZeroValues property
setDrawingsDisabled(boolean) - Method in class jxl.WorkbookSettings
  Disables the handling of drawings
setEncoding(String) - Method in class jxl.WorkbookSettings
  Sets the encoding for this workbook
setExcel9File(boolean) - Method in class jxl.WorkbookSettings
setExcelDisplayLanguage(String) - Method in class jxl.WorkbookSettings
  Sets the language in which the generated file will display
setExcelRegionalSettings(String) - Method in class jxl.WorkbookSettings
  Sets the regional settings for the generated excel file
setFile(File) - Method in class jxl.write.WritableHyperlink
  Sets the file activated by this hyperlink
setFitHeight(int) - Method in class jxl.SheetSettings
  Sets the number of pages vertically that this sheet will be printed into
setFitToPages(boolean) - Method in class jxl.SheetSettings
  Accessor for the fit to pages flag
setFitWidth(int) - Method in class jxl.SheetSettings
  Sets the number of pages widthwise which this sheet should be printed into
setFontName(String) - Method in class jxl.HeaderFooter.Contents
  Sets the font of text subsequently appended to this object..
setFontSize(int) - Method in class jxl.HeaderFooter.Contents
  Sets the font size of text subsequently appended to this object.
setFooter(String, String, String) - Method in interface jxl.write.WritableSheet
  Deprecated.
  use the SheetSettings bean
setFooter(HeaderFooter) - Method in class jxl.SheetSettings
  Sets the footer
setFooterMargin(double) - Method in class jxl.SheetSettings
  Sets the margin for any page footer
setFormat(CellFormat) - Method in class jxl.CellView
  Sets the cell format for this group of cells
setFormulaAdjust(boolean) - Method in class jxl.WorkbookSettings
  Setter for the formula adjust disabled property
setGCDisabled(boolean) - Method in class jxl.WorkbookSettings
  Sets the garbage collection disabled
setHeader(String, String, String) - Method in interface jxl.write.WritableSheet
  Deprecated.
  use the SheetSettings bean
setHeader(HeaderFooter) - Method in class jxl.SheetSettings
  Sets the header
setHeaderMargin(double) - Method in class jxl.SheetSettings
  Sets the margin for any page headers
setHeight(double) - Method in class jxl.write.WritableImage
  Accessor for the image dimensions Note that the actual size of the rendered image will depend on the height of the rows it spans
setHidden(boolean) - Method in class jxl.CellView
  Sets the hidden status of this row/column
setHidden(boolean) - Method in class jxl.SheetSettings
  Sets the hidden status of this worksheet
setHidden(boolean) - Method in interface jxl.write.WritableSheet
  Deprecated.
  use the SheetSettings bean instead
setHideobj(int) - Method in class jxl.WorkbookSettings
  The HIDEOBJ record stores options selected in the Options dialog,View tab Possible values are: HIDEOBJ_HIDE_ALL, HIDEOBJ_SHOW_ALL and HIDEOBJ_SHOW_PLACEHOLDERS
setHorizontalCentre(boolean) - Method in class jxl.SheetSettings
  Sets the horizontal centre
setHorizontalFreeze(int) - Method in class jxl.SheetSettings
  Sets the row at which the pane is frozen horizontally
setHorizontalPrintResolution(int) - Method in class jxl.SheetSettings
  Sets the horizontal print resolution
setIgnoreBlanks(boolean) - Method in class jxl.WorkbookSettings
  Sets the ignore blanks flag
setImageAnchor(Drawing.ImageAnchorProperties) - Method in class jxl.write.WritableImage
  Accessor for the anchor properties
setIndentation(int) - Method in class jxl.write.WritableCellFormat
  Sets the indentation of the cell text
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
setLeftMargin(double) - Method in class jxl.SheetSettings
  Sets the left margin
setLocale(Locale) - Method in class jxl.WorkbookSettings
  Sets the locale used by JExcelApi to generate the spreadsheet.
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
setLocked(boolean) - Method in class jxl.write.WritableCellFormat
  Sets whether or not this XF record locks the cell.
setMergedCellChecking(boolean) - Method in class jxl.WorkbookSettings
  Accessor to set the merged cell checking
setName(String) - Method in interface jxl.write.WritableSheet
  Sets the name of this sheet
setNamesDisabled(boolean) - Method in class jxl.WorkbookSettings
  Disables the handling of names
setNormalMagnification(int) - Method in class jxl.SheetSettings
  Accessor for the normal magnificaton factor.
setNumberValidation(double, double, BaseCellFeatures.ValidationCondition) - Method in class jxl.write.WritableCellFeatures
  Sets the numeric range against which to validate the data
setNumberValidation(double, BaseCellFeatures.ValidationCondition) - Method in class jxl.write.WritableCellFeatures
  Sets the numeric value against which to validate
setOrientation(Orientation) - Method in class jxl.write.WritableCellFormat
  Sets the text orientation for this format
setOrientation(PageOrientation) - Method in class jxl.SheetSettings
  Sets the paper orientation for printing this sheet
setOutputFile(File) - Method in class jxl.write.WritableWorkbook
  Sets a new output file.
setPageBreakPreviewMagnification(int) - Method in class jxl.SheetSettings
  Accessor for the page break preview magnificaton factor.
setPageBreakPreviewMode(boolean) - Method in class jxl.SheetSettings
  Sets the pageBreakPreviewMode property
setPageOrder(PageOrder) - Method in class jxl.SheetSettings
  Sets the page order for printing this sheet
setPageSetup(PageOrientation) - Method in interface jxl.write.WritableSheet
  Sets the page setup details
setPageSetup(PageOrientation, double, double) - Method in interface jxl.write.WritableSheet
  Sets the page setup details
setPageSetup(PageOrientation, PaperSize, double, double) - Method in interface jxl.write.WritableSheet
  Sets the page setup details
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
setPassword(String) - Method in class jxl.SheetSettings
  Sets the password for this sheet
setPasswordHash(int) - Method in class jxl.SheetSettings
  Accessor for the password hash - used only when copying sheets
setPointSize(int) - Method in class jxl.write.WritableFont
  Sets the point size for this font, if the font hasn't been initialized
setPrintArea(int, int, int, int) - Method in class jxl.SheetSettings
  Sets the print area for this sheet
setPrintGridLines(boolean) - Method in class jxl.SheetSettings
  Sets the printGridLines property
setPrintHeaders(boolean) - Method in class jxl.SheetSettings
  Sets the printHeaders property
setPrintTitles(int, int, int, int) - Method in class jxl.SheetSettings
  Sets both of the print titles for this sheet
setPrintTitlesCol(int, int) - Method in class jxl.SheetSettings
  Sets the print column titles for this sheet
setPrintTitlesRow(int, int) - Method in class jxl.SheetSettings
  Sets the print row titles for this sheet
setPropertySets(boolean) - Method in class jxl.WorkbookSettings
  Sets whether or not to enable any property sets (such as macros) to be copied along with the workbook Leaving this feature enabled will result in the JXL process using more memory
setProtected(boolean) - Method in class jxl.SheetSettings
  Sets the protected (ie.
setProtected(boolean) - Method in interface jxl.write.WritableSheet
  Deprecated.
  use the SheetSettings bean instead
setProtected(boolean) - Method in class jxl.write.WritableWorkbook
  Indicates whether or not this workbook is protected
setRationalization(boolean) - Method in class jxl.WorkbookSettings
  Sets whether or not to rationalize the cell formats before writing out the sheet.
setRecalculateFormulasBeforeSave(boolean) - Method in class jxl.SheetSettings
  Sets the recalculate formulas when the sheet is saved flag
setRefreshAll(boolean) - Method in class jxl.WorkbookSettings
  When true then Refresh All should be done on all external data ranges and PivotTables when loading the workbook (the default is =0)
setRightMargin(double) - Method in class jxl.SheetSettings
  Sets the right margin
setRow(double) - Method in class jxl.write.WritableImage
  Accessor for the image position
setRowGroup(int, int, boolean) - Method in interface jxl.write.WritableSheet
  Sets a row grouping
setRowView(int, boolean) - Method in interface jxl.write.WritableSheet
  Sets the properties of the specified row
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, boolean) - Method in interface jxl.write.WritableSheet
  Sets the height of the specified row, as well as its collapse status
setRowView(int, CellView) - Method in interface jxl.write.WritableSheet
  Sets the view for this column
setScaleFactor(int) - Method in class jxl.SheetSettings
  Sets the scale factor for this sheet to be used when printing.
setScriptStyle(ScriptStyle) - Method in class jxl.write.WritableFont
  Sets the script style (eg.
setSelected() - Method in class jxl.SheetSettings
  Deprecated.
  use overloaded version which takes a boolean
setSelected(boolean) - Method in class jxl.SheetSettings
  Sets this sheet to be when it is opened in excel
setShowGridLines(boolean) - Method in class jxl.SheetSettings
  Sets the showGridLines property
setShrinkToFit(boolean) - Method in class jxl.write.WritableCellFormat
  Sets the shrink to fit flag
setSize(int) - Method in class jxl.CellView
  Sets the dimension for this view
setString(String) - Method in class jxl.write.Label
  Sets the string contents of this cell
setStruckout(boolean) - Method in class jxl.write.WritableFont
  Sets Accessor for the strike-out flag
setSuppressWarnings(boolean) - Method in class jxl.WorkbookSettings
  Accessor to set the suppress warnings flag.
setTemplate(boolean) - Method in class jxl.WorkbookSettings
  Workbook Is a Template
setTemporaryFileDuringWriteDirectory(File) - Method in class jxl.WorkbookSettings
  Used in conjunction with the UseTemporaryFileDuringWrite setting to set the target directory for the temporary files.
setTopMargin(double) - Method in class jxl.SheetSettings
  Sets the top margin
setUnderlineStyle(UnderlineStyle) - Method in class jxl.write.WritableFont
  Sets the underline style for this font, if the font hasn't been initialized
setURL(URL) - Method in class jxl.write.WritableHyperlink
  Sets the URL of this hyperlink
setUseTemporaryFileDuringWrite(boolean) - Method in class jxl.WorkbookSettings
  Sets whether a temporary file is used during the generation of the workbook.
setValue(boolean) - Method in class jxl.write.Boolean
  Sets the boolean value for this cell
setValue(double) - Method in class jxl.write.Number
  Sets the numerical value for this cell
setVerticalAlignment(VerticalAlignment) - Method in class jxl.write.WritableCellFormat
  Sets the vertical alignment for this format
setVerticalCentre(boolean) - Method in class jxl.SheetSettings
  Sets the vertical centre
setVerticalFreeze(int) - Method in class jxl.SheetSettings
  Sets the row at which the pane is frozen vertically
setVerticalPrintResolution(int) - Method in class jxl.SheetSettings
  Sets the vertical print reslution
setWidth(double) - Method in class jxl.write.WritableImage
  Accessor for the image dimensions Note that the actual size of the rendered image will depend on the width of the columns it spans
setWindowProtected(boolean) - Method in class jxl.WorkbookSettings
setWrap(boolean) - Method in class jxl.write.WritableCellFormat
  Sets the wrap indicator for this format.
setWriteAccess(String) - Method in class jxl.WorkbookSettings
setZoomFactor(int) - Method in class jxl.SheetSettings
  Sets the zoom factor.
Sheet - Interface in jxl
  Represents a sheet within a workbook.
SheetSettings - Class in jxl
  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(Sheet) - Constructor for class jxl.SheetSettings
  Default constructor
SheetSettings(SheetSettings, Sheet) - Constructor for class jxl.SheetSettings
  Copy constructor.
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.
SIZE_10x11 - Static variable in class jxl.format.PaperSize
  10×11 10" × 11"
SIZE_10x14 - Static variable in class jxl.format.PaperSize
  10" x 14"
SIZE_10x17 - Static variable in class jxl.format.PaperSize
  11" x 17"
SIZE_15x11 - Static variable in class jxl.format.PaperSize
  15×11 15" × 11"
SIZE_9x11 - Static variable in class jxl.format.PaperSize
  9×11 9" × 11"
SKY_BLUE - Static variable in class jxl.format.Colour
SLANTED_DASH_DOT - Static variable in class jxl.format.BorderLineStyle
SOLID - Static variable in class jxl.format.Pattern
STACKED - Static variable in class jxl.format.Orientation
  Cells with this specified orientation will have their text stacked downwards, but not rotated
STATEMENT - Static variable in class jxl.format.PaperSize
  Statement 5.5" x 8.5"
STRING_FORMULA - Static variable in class jxl.CellType
StringFormulaCell - Interface in jxl
  A mixin interface for numerical formulas, which combines the interfaces for formulas and for strings
SUBSCRIPT - Static variable in class jxl.format.ScriptStyle
SUBSCRIPT - Static variable in class jxl.write.Font
  Deprecated.
SUPER_A_A4 - Static variable in class jxl.format.PaperSize
  Super A/A4 227mm × 356mm
SUPER_B_A3 - Static variable in class jxl.format.PaperSize
  Super B/A3 305mm × 487mm
SUPERSCRIPT - Static variable in class jxl.format.ScriptStyle
SUPERSCRIPT - Static variable in class jxl.write.Font
  Deprecated.

## T

TABLOID - Static variable in class jxl.format.PaperSize
  Tabloid 11" x 17"
TABLOID_EXTRA - Static variable in class jxl.format.PaperSize
  Tabloid Extra 11 11/16" × 18"
TAHOMA - Static variable in class jxl.write.WritableFont
  Objects created with this font name will be rendered within Excel as TAHOMA fonts
TAN - Static variable in class jxl.format.Colour
TEAL - Static variable in class jxl.format.Colour
TEAL2 - Static variable in class jxl.format.Colour
TEXT - Static variable in class jxl.write.NumberFormats
  Forces numbers to be interpreted as text
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.
TIMES - Static variable in class jxl.write.Font
  Deprecated.
TIMES - Static variable in class jxl.write.WritableFont
  Objects created with this font name will be rendered within Excel as TIMES fonts
toggleBold() - Method in class jxl.HeaderFooter.Contents
  Turns bold printing on or off.
toggleDoubleUnderline() - Method in class jxl.HeaderFooter.Contents
  Turns double-underline printing on or off.
toggleItalics() - Method in class jxl.HeaderFooter.Contents
  Turns italics printing on or off.
toggleOutline() - Method in class jxl.HeaderFooter.Contents
  Turns outline printing on or off (Macintosh only).
toggleShadow() - Method in class jxl.HeaderFooter.Contents
  Turns shadow printing on or off (Macintosh only).
toggleStrikethrough() - Method in class jxl.HeaderFooter.Contents
  Turns strikethrough printing on or off.
toggleSubScript() - Method in class jxl.HeaderFooter.Contents
  Turns subscript printing on or off.
toggleSuperScript() - Method in class jxl.HeaderFooter.Contents
  Turns superscript printing on or off.
toggleUnderline() - Method in class jxl.HeaderFooter.Contents
  Turns underline printing on or off.
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
toString() - Method in class jxl.CellType
  Returns a string description of this cell
toString() - Method in class jxl.HeaderFooter
  Retrieves a `String`ified version of this object
TURQOISE2 - Static variable in class jxl.format.Colour
TURQUOISE - Static variable in class jxl.format.Colour

## U

UNDEFINED - Static variable in class jxl.format.PaperSize
  US Letter 8.5 x 11"
UnderlineStyle - Class in jxl.format
  Enumeration class which contains the various underline styles available within the standard Excel UnderlineStyle palette
UNKNOWN - Static variable in class jxl.format.Colour
unmergeCells(Range) - Method in interface jxl.write.WritableSheet
  Unmerges the specified cells.
unsetColumnGroup(int, int) - Method in interface jxl.write.WritableSheet
  Unsets a column grouping
unsetRowGroup(int, int) - Method in interface jxl.write.WritableSheet
  Unsets a row grouping
US_FANFOLD - Static variable in class jxl.format.PaperSize
  US Standard Fanfold 14 7/8" × 11"

## V

VERTICAL - Static variable in class jxl.format.Orientation
  Cells with this specified orientation have their data presented vertically
VerticalAlignment - Class in jxl.format
  Enumeration type which describes the vertical alignment of data within a cell
VerticalAlignment - Class in jxl.write
  Deprecated.
  Repackaged as jxl.format.VerticalAlignment
VERY_LIGHT_YELLOW - Static variable in class jxl.format.Colour
VIOLET - Static variable in class jxl.format.Colour
VIOLET2 - Static variable in class jxl.format.Colour

## W

WHITE - Static variable in class jxl.format.Colour
Workbook - Class in jxl
  Represents a Workbook.
WorkbookSettings - Class in jxl
  This is a bean which client applications may use to set various advanced workbook properties.
WorkbookSettings() - Constructor for class jxl.WorkbookSettings
  Default constructor
WritableCell - Interface in jxl.write
  The interface for all writable cells
WritableCellFeatures - Class in jxl.write
  Container for any additional cell features
WritableCellFeatures() - Constructor for class jxl.write.WritableCellFeatures
  Constructor
WritableCellFeatures(CellFeatures) - Constructor for class jxl.write.WritableCellFeatures
  Copy constructor
WritableCellFormat - Class in jxl.write
  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(CellFormat) - Constructor for class jxl.write.WritableCellFormat
  A public copy constructor which can be used for copy formats between different sheets
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 in jxl.write
  A class which is instantiated when the user application wishes to specify the font for a particular cell
WritableFont(Font) - Constructor for class jxl.write.WritableFont
  Publicly available copy constructor
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)
WritableFont.FontName - Class in jxl.write
  Static inner class used for classifying the font names
WritableHyperlink - Class in jxl.write
  A writable hyperlink.
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, File, String) - 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, int, int, URL, String) - Constructor for class jxl.write.WritableHyperlink
  Constructs a url hyperlink to a range of cells
WritableHyperlink(int, int, File) - Constructor for class jxl.write.WritableHyperlink
  Constructs a file hyperlink in a single cell
WritableHyperlink(int, int, File, String) - Constructor for class jxl.write.WritableHyperlink
  Constructs a file hyperlink in a single cell
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
WritableHyperlink(Hyperlink, WritableSheet) - Constructor for class jxl.write.WritableHyperlink
  Constructor used internally by the worksheet when making a copy of worksheet
WritableImage - Class in jxl.write
  Allows an image to be created, or an existing image to be manipulated Note that co-ordinates and dimensions are given in cells, so that if for example the width or height of a cell which the image spans is altered, the image will have a correspondign distortion
WritableImage(double, double, double, double, byte[]) - Constructor for class jxl.write.WritableImage
  Constructor
WritableImage(double, double, double, double, File) - Constructor for class jxl.write.WritableImage
  Constructor
WritableImage(DrawingGroupObject, DrawingGroup) - Constructor for class jxl.write.WritableImage
  Constructor, used when copying sheets
WritableSheet - Interface in jxl.write
  Interface for a worksheet that may be modified.
WritableWorkbook - Class in jxl.write
  A writable workbook
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 - Class in jxl.demo
  Demo class which writes a spreadsheet.
Write(String) - Constructor for class jxl.demo.Write
  Constructor
WriteException - Exception Class in jxl.write
  Exception thrown when using the API to generate an Excel file

## X

XML - Class in jxl.demo
  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

## Y

YELLOW - Static variable in class jxl.format.Colour
YELLOW2 - Static variable in class jxl.format.Colour

A B C D E F G H I J L M N O P Q R S T U V W X Y
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form