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

A

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

B

B4 - Static variable in class xl.format.PaperSize
B4 (JIS) 257mm x 364mm
B4_ISO - Static variable in class xl.format.PaperSize
B4 (ISO) 250mm x 353mm
B4_ISO_2 - Static variable in class xl.format.PaperSize
B4 (ISO) 250mm x 353mm
B4_ROTATED - Static variable in class xl.format.PaperSize
B4 (JIS) Rotated 364mm x 257mm
B5 - Static variable in class xl.format.PaperSize
B5 (JIS) 182mm x 257mm
B5_EXTRA - Static variable in class xl.format.PaperSize
B5 (ISO) Extra 201mm x 276mm
B5_ISO - Static variable in class xl.format.PaperSize
B5 (ISO) 176mm x 250mm
B5_ROTATED - Static variable in class xl.format.PaperSize
B5 (JIS) Rotated 257mm x 182mm
B5_TRANSVERSE - Static variable in class xl.format.PaperSize
B5 (JIS) Transverse 182mm x 257mm
B6 - Static variable in class xl.format.PaperSize
B6 (JIS) 128mm x 182mm
B6_ISO - Static variable in class xl.format.PaperSize
B6 (ISO) 125mm x 176mm
B6_ROTATED - Static variable in class xl.format.PaperSize
B6 (JIS) Rotated 182mm x128mm
BETWEEN - Static variable in class xl.write.WritableCellFeatures
BLACK - Static variable in class xl.format.Color
BLUE - Static variable in class xl.format.Color
BLUE2 - Static variable in class xl.format.Color
BLUE_GREY - Static variable in class xl.format.Color
BOLD - Static variable in class xl.format.BoldStyle
Emboldened style
BOLD - Static variable in class xl.write.Font
Deprecated.  
BOLD - Static variable in class xl.write.WritableFont
Indicates that this font should be presented in a BOLD style
BOOLEAN - Static variable in class xl.CellType
BOOLEAN_FORMULA - Static variable in class xl.CellType
BOTTOM - Static variable in class xl.format.Border
BOTTOM - Static variable in class xl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned at the bottom
BRIGHT_GREEN - Static variable in class xl.format.Color
BROWN - Static variable in class xl.format.Color
Blank - class xl.write.Blank.
A blank cell.
Blank(int, int) - Constructor for class xl.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 xl.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 xl.write.Blank
Constructor used internally by the application when making a writable copy of a spreadsheet being read in
BoldStyle - class xl.format.BoldStyle.
Enumeration class containing the various bold styles for data
BoldStyle - class xl.write.BoldStyle.
Enumeration class containing the various bold styles for data
Boolean - class xl.write.Boolean.
A cell, created by user applications, which contains a boolean (or in some cases an error) value
Boolean(int, int, boolean) - Constructor for class xl.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 xl.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 xl.write.Boolean
Constructor used internally by the application when making a writable copy of a spreadsheet that has been read in
BooleanCell - interface xl.BooleanCell.
This type represents the Microsoft concept of a Boolean.
BooleanFormulaCell - interface xl.BooleanFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
Border - class xl.format.Border.
The location of a border
Border - class xl.write.Border.
Deprecated. repackaged as xl.format.Border
BorderLineStyle - class xl.format.BorderLineStyle.
The border line style
BorderLineStyle - class xl.write.BorderLineStyle.
Deprecated. Repackaged as xl.format.BorderLineStyle

C

C - Static variable in class xl.format.PaperSize
C 17" x 22"
CENTER - Static variable in class xl.format.Alignment
Data in cells with this alignment will be centered
CENTER - Static variable in class xl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned centrally
COMPLEX_FORMAT - Static variable in class xl.write.NumberFormat
Pass in to the constructor to bypass the format validation
CORAL - Static variable in class xl.format.Color
COURIER - Static variable in class xl.write.WritableFont
Objects created with this font name will be rendered within Excel as COURIER fonts
CSV - class xl.util.CSV.
Simple util class which uses the api to present the contents of an Excel Worksheet as comma separated values, using a workbook and output stream of your choice
CSV(Workbook, OutputStream, String, boolean) - Constructor for class xl.util.CSV
Constructor
CURRENCY_DOLLAR - Static variable in class xl.write.NumberFormat
Constant format string for the US Dollar sign
CURRENCY_EURO_PREFIX - Static variable in class xl.write.NumberFormat
Constant format string for the Euro currency symbol where it precedes the format
CURRENCY_EURO_SUFFIX - Static variable in class xl.write.NumberFormat
Constant format string for the Euro currency symbol where it precedes the format
CURRENCY_JAPANESE_YEN - Static variable in class xl.write.NumberFormat
Constant format string for the Japanese Yen sign
CURRENCY_POUND - Static variable in class xl.write.NumberFormat
Constant format string for the UK pound sign
Cell - interface xl.Cell.
Represents an individual Cell within a Sheet.
CellFeatures - class xl.CellFeatures.
Container for any additional cell features
CellFeatures() - Constructor for class xl.CellFeatures
Constructor
CellFormat - interface xl.CellFormat.
Deprecated. Repackaged as xl.format.CellFormat
CellFormat - interface xl.format.CellFormat.
Interface for cell formats
CellReferenceHelper - class xl.CellReferenceHelper.
Exposes some cell reference helper methods to the public interface.
CellType - class xl.CellType.
An enumeration type listing the available content types for a cell
CellView - class xl.CellView.
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 xl.CellView
Default constructor
CellView(CellView) - Constructor for class xl.CellView
Copy constructor
Color - class xl.format.Color.
Enumeration class which contains the various colors available within the standard Excel color palette
Color - class xl.write.Color.
Deprecated. This has been repackaged as xl.format.Color
clear() - Method in class xl.HeaderFooter.Contents
Clears the contents of this portion
clear() - Method in class xl.HeaderFooter
Clears the contents of the header/footer
close() - Method in class xl.Workbook
Closes this workbook, and frees makes any memory allocated available for garbage collection
close() - Method in class xl.write.WritableWorkbook
Closes this workbook, and makes any memory allocated available for garbage collection.
copy(Workbook) - Method in class xl.write.WritableWorkbook
Deprecated. Copying now occurs implicitly as part of the overloaded factory method Workbook.createWorkbood
copySheet(int, String, int) - Method in class xl.write.WritableWorkbook
Copy sheet within the same workbook.
copySheet(String, String, int) - Method in class xl.write.WritableWorkbook
Copies the specified sheet and places it at the index specified by the parameter
copyTo(int, int) - Method in class xl.write.Blank
Implementation of the deep copy function
copyTo(int, int) - Method in class xl.write.Boolean
Implementation of the deep copy function
copyTo(int, int) - Method in class xl.write.DateTime
Implementation of the deep copy function
copyTo(int, int) - Method in class xl.write.Formula
Implementation of the deep copy function
copyTo(int, int) - Method in class xl.write.Label
Implementation of the deep copy function
copyTo(int, int) - Method in class xl.write.Number
Implementation of the deep copy function
copyTo(int, int) - Method in interface xl.write.WritableCell
A deep copy.
createFont(String) - Static method in class xl.write.WritableFont
Factory method which creates the specified font name.
createSheet(String, int) - Method in class xl.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 xl.Workbook
Creates a writable workbook with the given file name
createWorkbook(File, WorkbookSettings) - Static method in class xl.Workbook
Creates a writable workbook with the given file name
createWorkbook(File, Workbook) - Static method in class xl.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 xl.Workbook
Creates a writable workbook with the given filename as a copy of the workbook passed in.
createWorkbook(OutputStream, Workbook) - Static method in class xl.Workbook
Creates a writable workbook as a copy of the workbook passed in.
createWorkbook(OutputStream, Workbook, WorkbookSettings) - Static method in class xl.Workbook
Creates a writable workbook as a copy of the workbook passed in.
createWorkbook(OutputStream) - Static method in class xl.Workbook
Creates a writable workbook.
createWorkbook(OutputStream, WorkbookSettings) - Static method in class xl.Workbook
Creates a writable workbook.

D

D - Static variable in class xl.format.PaperSize
D 22" x 34"
DARK_BLUE - Static variable in class xl.format.Color
DARK_BLUE2 - Static variable in class xl.format.Color
DARK_GREEN - Static variable in class xl.format.Color
DARK_PURPLE - Static variable in class xl.format.Color
DARK_RED - Static variable in class xl.format.Color
DARK_RED2 - Static variable in class xl.format.Color
DARK_TEAL - Static variable in class xl.format.Color
DARK_YELLOW - Static variable in class xl.format.Color
DASHED - Static variable in class xl.format.BorderLineStyle
DASH_DOT - Static variable in class xl.format.BorderLineStyle
DASH_DOT_DOT - Static variable in class xl.format.BorderLineStyle
DATE - Static variable in class xl.CellType
DATE_FORMULA - Static variable in class xl.CellType
DEFAULT - Static variable in class xl.write.DateFormats
The default format.
DEFAULT - Static variable in class xl.write.NumberFormats
The default format.
DEFAULT_BACKGROUND - Static variable in class xl.format.Color
DEFAULT_BACKGROUND1 - Static variable in class xl.format.Color
DEFAULT_DEFAULT_ROW_HEIGHT - Static variable in class xl.SheetSettings
The default value for the default row height
DEFAULT_POINT_SIZE - Static variable in class xl.write.WritableFont
The default point size for all Fonts
DOTTED - Static variable in class xl.format.BorderLineStyle
DOUBLE - Static variable in class xl.format.BorderLineStyle
DOUBLE - Static variable in class xl.format.UnderlineStyle
DOUBLE - Static variable in class xl.write.Font
Deprecated.  
DOUBLE_ACCOUNTING - Static variable in class xl.format.UnderlineStyle
DOUBLE_ACCOUNTING - Static variable in class xl.write.Font
Deprecated.  
DOUBLE_JAPANESE_POSTCARD - Static variable in class xl.format.PaperSize
Dbl.
DOUBLE_JAPANESE_POSTCARD_ROTATED - Static variable in class xl.format.PaperSize
Dbl.
DateCell - interface xl.DateCell.
A date cell
DateFormat - class xl.write.DateFormat.
A custom user defined number format which may be instantiated within user applications in order to present date and time values in the appropriate format.
DateFormat(String) - Constructor for class xl.write.DateFormat
Constructor.
DateFormats - class xl.write.DateFormats.
Static class which contains Excels predefined Date formats
DateFormats() - Constructor for class xl.write.DateFormats
DateFormulaCell - interface xl.DateFormulaCell.
A mixin interface for date formulas, which combines the interfaces for formulas and for dates
DateTime - class xl.write.DateTime.
A Date which may be created on the fly by a user application and added to a spreadsheet NOTE: By default, all dates will have local timezone information added to their UTC value.
DateTime(int, int, Date) - Constructor for class xl.write.DateTime
Constructor
DateTime(int, int, Date, DateRecord.GMTDate) - Constructor for class xl.write.DateTime
Constructor, which adjusts the specified date to take timezone considerations into account
DateTime(int, int, Date, CellFormat) - Constructor for class xl.write.DateTime
Constructor which takes the format for this cell
DateTime(int, int, Date, CellFormat, DateRecord.GMTDate) - Constructor for class xl.write.DateTime
Constructor, which adjusts the specified date to take timezone considerations into account
DateTime(int, int, Date, CellFormat, boolean) - Constructor for class xl.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(DateCell) - Constructor for class xl.write.DateTime
A constructor called by the worksheet when creating a writable version of a spreadsheet that has been read in
depUsed() - Method in class xl.CellView
Accessor for the depUsed attribute

E

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

F

FILL - Static variable in class xl.format.Alignment
Data in cells with this alignment will fill the cell
FLOAT - Static variable in class xl.write.NumberFormats
Formatting for a float.
FOLIO - Static variable in class xl.format.PaperSize
Folio 8.5" x 13"
FORMAT1 - Static variable in class xl.write.DateFormats
The default format.
FORMAT1 - Static variable in class xl.write.NumberFormats
Equivalent to a DecimalFormat "#,##0;(#,##0)"
FORMAT10 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "mm:ss"
FORMAT10 - Static variable in class xl.write.NumberFormats
Equivalent to DecimalFormat "##0.0E0"
FORMAT11 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "H:mm:ss"
FORMAT12 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "mm:ss.S"
FORMAT2 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "d-MMM-yy"
FORMAT2 - Static variable in class xl.write.NumberFormats
Equivalent to FORMAT1 except deficits are colored red
FORMAT3 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "d-MMM"
FORMAT3 - Static variable in class xl.write.NumberFormats
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
FORMAT4 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "MMM-yy"
FORMAT4 - Static variable in class xl.write.NumberFormats
Equivalent to FORMAT3 except deficits are colored red
FORMAT5 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "h:mm a"
FORMAT5 - Static variable in class xl.write.NumberFormats
Equivalent to DecimalFormat "#,##0;(#,##0)"
FORMAT6 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "h:mm:ss a"
FORMAT6 - Static variable in class xl.write.NumberFormats
Equivalent to FORMAT5 except deficits are colored red
FORMAT7 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "H:mm"
FORMAT7 - Static variable in class xl.write.NumberFormats
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
FORMAT8 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "H:mm:ss"
FORMAT8 - Static variable in class xl.write.NumberFormats
Equivalent to FORMAT7 except deficits are colored red
FORMAT9 - Static variable in class xl.write.DateFormats
Equivalent to a date format of "M/d/yy H:mm"
FORMAT9 - Static variable in class xl.write.NumberFormats
Equivalent to FORMAT7
FORMULA_ERROR - Static variable in class xl.CellType
FRACTIONS_EIGHTHS - Static variable in class xl.write.NumberFormat
Constant format string for fractions as eighths
FRACTION_HALVES - Static variable in class xl.write.NumberFormat
Constant format string for fractions as halves
FRACTION_HUNDREDTHS - Static variable in class xl.write.NumberFormat
Constant format string for fractions as hundredths
FRACTION_ONE_DIGIT - Static variable in class xl.write.NumberFormats
Formatting for one digit fractions
FRACTION_QUARTERS - Static variable in class xl.write.NumberFormat
Constant format string for fractions as quarter
FRACTION_SIXTEENTHS - Static variable in class xl.write.NumberFormat
Constant format string for fractions as sixteenths
FRACTION_TENTHS - Static variable in class xl.write.NumberFormat
Constant format string for fractions as tenths
FRACTION_THREE_DIGITS - Static variable in class xl.write.NumberFormat
Constant format string for three digit fractions
FRACTION_TWO_DIGITS - Static variable in class xl.write.NumberFormats
Formatting for two digit fractions
Font - interface xl.format.Font.
Interface which exposes the user font display information to the user
Font - class xl.write.Font.
Deprecated. Renamed to writable font
Font(WritableFont.FontName) - Constructor for class xl.write.Font
Deprecated. Use xl.write.WritableFont
Font(WritableFont.FontName, int) - Constructor for class xl.write.Font
Deprecated. use xl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle) - Constructor for class xl.write.Font
Deprecated. use xl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean) - Constructor for class xl.write.Font
Deprecated. use xl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle) - Constructor for class xl.write.Font
Deprecated. use xl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Color) - Constructor for class xl.write.Font
Deprecated. use xl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Color, ScriptStyle) - Constructor for class xl.write.Font
Deprecated. use xl.write.WritableFont
Format - interface xl.format.Format.
Exposes the cell formatting information
Formula - class xl.write.Formula.
A cell, created by user applications, which contains a numerical value
Formula(int, int, String) - Constructor for class xl.write.Formula
Constructs the formula
Formula(int, int, String, CellFormat) - Constructor for class xl.write.Formula
Constructs a formula
FormulaCell - interface xl.FormulaCell.
Interface for formulas which allow clients to read the Excel formula
findByName(String) - Method in class xl.Workbook
Gets the named range from this workbook.
findByName(String) - Method in class xl.write.WritableWorkbook
Gets the named range from this workbook.
findCell(String) - Method in interface xl.Sheet
Gets the cell whose contents match the string passed in.
findCellByName(String) - Method in class xl.Workbook
Gets the named cell from this workbook.
findCellByName(String) - Method in class xl.write.WritableWorkbook
Gets the named cell from this workbook.
findLabelCell(String) - Method in interface xl.Sheet
Gets the cell whose contents match the string passed in.

G

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

H

HAIR - Static variable in class xl.format.BorderLineStyle
HIDDEN_STYLE - Static variable in class xl.write.WritableWorkbook
A cell format used to hide the cell contents
HORIZONTAL - Static variable in class xl.format.Orientation
Cells with this specified orientation will be horizontal
HYPERLINK_FONT - Static variable in class xl.write.WritableWorkbook
The font used for hyperlinks
HYPERLINK_STYLE - Static variable in class xl.write.WritableWorkbook
The style used for hyperlinks
HeaderFooter - class xl.HeaderFooter.
Class which represents an Excel header or footer.
HeaderFooter() - Constructor for class xl.HeaderFooter
Default constructor.
HeaderFooter(HeaderFooter) - Constructor for class xl.HeaderFooter
Copy constructor
HeaderFooter(String) - Constructor for class xl.HeaderFooter
Constructor used when reading workbooks to separate the left, right a central part of the strings into their constituent parts
HeaderFooter.Contents - class xl.HeaderFooter.Contents.
The contents - a simple wrapper around a string buffer
Hyperlink - interface xl.Hyperlink.
Hyperlink information.
hasBorders() - Method in interface xl.format.CellFormat
Determines if this cell format has any borders at all.

I

ICE_BLUE - Static variable in class xl.format.Color
INDIGO - Static variable in class xl.format.Color
INTEGER - Static variable in class xl.write.NumberFormats
Formatting for an integer number.
IVORY - Static variable in class xl.format.Color
Image - interface xl.Image.
Accessor functions for an image
importSheet(String, int, Sheet) - Method in class xl.write.WritableWorkbook
Imports a sheet from a different workbook.
insertColumn(int) - Method in interface xl.write.WritableSheet
Inserts a blank column into this spreadsheet.
insertRow(int) - Method in interface xl.write.WritableSheet
Inserts a blank row into this spreadsheet.
isAutosize() - Method in class xl.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 xl.CellReferenceHelper
Sees if the column component is relative or not
isFile() - Method in interface xl.Hyperlink
Determines whether this is a hyperlink to a file
isHidden() - Method in interface xl.Cell
Indicates whether or not this cell is hidden, by virtue of either the entire row or column being collapsed
isHidden() - Method in class xl.CellView
Accessor for the hidden nature of this row/column
isHidden() - Method in interface xl.Sheet
Deprecated. in favor of the getSettings() method
isHidden() - Method in class xl.SheetSettings
Accessor for the hidden nature of this sheet
isHorizontalCenter() - Method in class xl.SheetSettings
Accessor for the horizontal center
isItalic() - Method in interface xl.format.Font
Returns the italic flag
isLocation() - Method in interface xl.Hyperlink
Determines whether this is a hyperlink to a location in this workbook
isLocked() - Method in interface xl.format.CellFormat
Accessor for whether a particular cell is locked
isProtected() - Method in interface xl.Sheet
Deprecated. in favor of the getSettings() method
isProtected() - Method in class xl.SheetSettings
Queries whether this sheet is protected (ie.
isProtected() - Method in class xl.Workbook
Determines whether the sheet is protected
isRowRelative(String) - Static method in class xl.CellReferenceHelper
Sees if the row component is relative or not
isSelected() - Method in class xl.SheetSettings
Accessor for the selected nature of the sheet
isShrinkToFit() - Method in interface xl.format.CellFormat
Gets the shrink to fit flag
isStruckout() - Method in interface xl.format.Font
Returns the strike-out flag
isStruckout() - Method in class xl.write.WritableFont
Accessor for the strike-out flag
isTime() - Method in interface xl.DateCell
Indicates whether the date value contained in this cell refers to a date, or merely a time
isURL() - Method in interface xl.Hyperlink
Determines whether this is a hyperlink to a web resource
isVerticalCenter() - Method in class xl.SheetSettings
Accessor for the vertical center

J

JAPANESE_POSTCARD - Static variable in class xl.format.PaperSize
Japanese Postcard 100mm � 148mm
JAPANESE_POSTCARD_ROTATED - Static variable in class xl.format.PaperSize
Japanese Postcard Rot.
JUSTIFY - Static variable in class xl.format.Alignment
Data in cells with this alignment will be justified
JUSTIFY - Static variable in class xl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data justified
JXLException - exception xl.JXLException.
Base exception class for Excel API exceptions
xl - namespace xl
 
xl.util - namespace xl.util
 
xl.format - namespace xl.format
 
xl.write - namespace xl.write
 

L

LABEL - Static variable in class xl.CellType
LANDSCAPE - Static variable in class xl.format.PageOrientation
Landscape orientation
LAVENDER - Static variable in class xl.format.Color
LEDGER - Static variable in class xl.format.PaperSize
Leger 17" x 11"
LEFT - Static variable in class xl.format.Alignment
Data cells with this alignment will appear at the left hand edge of the cell
LEFT - Static variable in class xl.format.Border
LEGAL - Static variable in class xl.format.PaperSize
US Legal 8.5" x 14"
LEGAL_EXTRA - Static variable in class xl.format.PaperSize
Legal Extra 9.5" x 15"
LESS_EQUAL - Static variable in class xl.write.WritableCellFeatures
LESS_THAN - Static variable in class xl.write.WritableCellFeatures
LETTER - Static variable in class xl.format.PaperSize
US Letter 8.5 x 11"
LETTER_EXTRA - Static variable in class xl.format.PaperSize
Letter Extra 9.5" x 12"
LETTER_EXTRA_TRANSVERSE - Static variable in class xl.format.PaperSize
Letter Extra Transv.
LETTER_PLUS - Static variable in class xl.format.PaperSize
Letter Plus 8.5" x 12 11/16"
LETTER_ROTATED - Static variable in class xl.format.PaperSize
Letter Rotated 11" x 8.5"
LETTER_SMALL - Static variable in class xl.format.PaperSize
Letter small 8.5" x 11"
LETTER_TRANSVERSE - Static variable in class xl.format.PaperSize
Letter Transverse 8.5" x 11"
LIGHT_BLUE - Static variable in class xl.format.Color
LIGHT_GREEN - Static variable in class xl.format.Color
LIGHT_ORANGE - Static variable in class xl.format.Color
LIGHT_TURQUOISE - Static variable in class xl.format.Color
LIGHT_TURQUOISE2 - Static variable in class xl.format.Color
LIME - Static variable in class xl.format.Color
Label - class xl.write.Label.
A cell containing text which may be created by user applications
Label(int, int, String) - Constructor for class xl.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 xl.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 xl.write.Label
Constructor used internally by the application when making a writable copy of a spreadsheet being read in
LabelCell - interface xl.LabelCell.
A label cell

M

MEDIUM - Static variable in class xl.format.BorderLineStyle
MEDIUM_DASHED - Static variable in class xl.format.BorderLineStyle
MEDIUM_DASH_DOT - Static variable in class xl.format.BorderLineStyle
MEDIUM_DASH_DOT_DOT - Static variable in class xl.format.BorderLineStyle
MINUS_45 - Static variable in class xl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation 45 degrees downwards
MINUS_90 - Static variable in class xl.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 xl.write.WritableImage
Image anchor properties which will move and resize an image along with the cells
MOVE_WITH_CELLS - Static variable in class xl.write.WritableImage
Image anchor properties which will move an image when cells are inserted or deleted
mergeCells(int, int, int, int) - Method in interface xl.write.WritableSheet
Merges the specified cells.
moveSheet(int, int) - Method in class xl.write.WritableWorkbook
Moves the specified sheet within this workbook to another index position.

N

NONE - Static variable in class xl.format.Border
NONE - Static variable in class xl.format.BorderLineStyle
NONE - Static variable in class xl.format.Pattern
NORMAL - Static variable in class xl.format.BoldStyle
Normal style
NORMAL_SCRIPT - Static variable in class xl.format.ScriptStyle
NORMAL_SCRIPT - Static variable in class xl.write.Font
Deprecated.  
NORMAL_STYLE - Static variable in class xl.write.WritableWorkbook
The default style for cells
NOTE - Static variable in class xl.format.PaperSize
NOTE 8.5" x 11"
NOT_BETWEEN - Static variable in class xl.write.WritableCellFeatures
NOT_EQUAL - Static variable in class xl.write.WritableCellFeatures
NO_BOLD - Static variable in class xl.write.Font
Deprecated.  
NO_BOLD - Static variable in class xl.write.WritableFont
Indicates that this font should not be presented as bold
NO_MOVE_OR_SIZE_WITH_CELLS - Static variable in class xl.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 xl.format.UnderlineStyle
NO_UNDERLINE - Static variable in class xl.write.Font
Deprecated.  
NUMBER - Static variable in class xl.CellType
NUMBER_FORMULA - Static variable in class xl.CellType
Number - class xl.write.Number.
A cell, created by user applications, which contains a numerical value
Number(int, int, double) - Constructor for class xl.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 xl.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 xl.write.Number
Constructor used internally by the application when making a writable copy of a spreadsheet that has been read in
NumberCell - interface xl.NumberCell.
A cell which contains a numerical value
NumberFormat - class xl.write.NumberFormat.
A custom user defined number format, which may be instantiated within user applications in order to present numerical values to the appropriate level of accuracy.
NumberFormat(String) - Constructor for class xl.write.NumberFormat
Constructor, taking in the C# compliant number format
NumberFormat(String, NumberFormatRecord.NonValidatingFormat) - Constructor for class xl.write.NumberFormat
Constructor, taking in the non-C# compliant number format.
NumberFormats - class xl.write.NumberFormats.
Static class which contains the available list of built in Number formats
NumberFormats() - Constructor for class xl.write.NumberFormats
NumberFormulaCell - interface xl.NumberFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers

O

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

P

PALETTE_BLACK - Static variable in class xl.format.Color
PALE_BLUE - Static variable in class xl.format.Color
PATTERN1 - Static variable in class xl.format.Pattern
PATTERN10 - Static variable in class xl.format.Pattern
PATTERN11 - Static variable in class xl.format.Pattern
PATTERN12 - Static variable in class xl.format.Pattern
PATTERN13 - Static variable in class xl.format.Pattern
PATTERN14 - Static variable in class xl.format.Pattern
PATTERN2 - Static variable in class xl.format.Pattern
PATTERN3 - Static variable in class xl.format.Pattern
PATTERN4 - Static variable in class xl.format.Pattern
PATTERN5 - Static variable in class xl.format.Pattern
PATTERN6 - Static variable in class xl.format.Pattern
PATTERN7 - Static variable in class xl.format.Pattern
PATTERN8 - Static variable in class xl.format.Pattern
PATTERN9 - Static variable in class xl.format.Pattern
PERCENT_FLOAT - Static variable in class xl.write.NumberFormats
Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"
PERCENT_INTEGER - Static variable in class xl.write.NumberFormats
Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"
PERIWINKLE - Static variable in class xl.format.Color
PINK - Static variable in class xl.format.Color
PINK2 - Static variable in class xl.format.Color
PLUM - Static variable in class xl.format.Color
PLUM2 - Static variable in class xl.format.Color
PLUS_45 - Static variable in class xl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation 45 degrees upwards
PLUS_90 - Static variable in class xl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation of 90 degrees upwards
PORTRAIT - Static variable in class xl.format.PageOrientation
Portrait orientation
PageOrientation - class xl.format.PageOrientation.
Enumeration type which describes the page orientation
PaperSize - class xl.format.PaperSize.
Enumeration type which contains the available excel paper sizes and their codes
Pattern - class xl.format.Pattern.
Enumeration class which contains the various patterns available within the standard Excel pattern palette
Pattern - class xl.write.Pattern.
Deprecated. Repackaged as xl.format.Pattern

Q

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

R

RED - Static variable in class xl.format.Color
RGB - class xl.format.RGB.
A structure which contains the RGB values for a particular color
RGB(int, int, int) - Constructor for class xl.format.RGB
Constructor
RIGHT - Static variable in class xl.format.Alignment
Data in cells with this alignment will be right aligned
RIGHT - Static variable in class xl.format.Border
ROSE - Static variable in class xl.format.Color
Range - interface xl.Range.
Represents a 3-D range of cells in a workbook.
removeColumn(int) - Method in interface xl.write.WritableSheet
Removes a column from this spreadsheet.
removeComment() - Method in class xl.write.WritableCellFeatures
Removes the cell comment, if present
removeHyperlink(WritableHyperlink) - Method in interface xl.write.WritableSheet
Removes the specified hyperlink.
removeHyperlink(WritableHyperlink, boolean) - Method in interface xl.write.WritableSheet
Removes the specified hyperlink.
removeImage(WritableImage) - Method in interface xl.write.WritableSheet
Removes the specified image from the sheet.
removeRangeName(String) - Method in class xl.write.WritableWorkbook
Removes the specified named range from the workbook.
removeRow(int) - Method in interface xl.write.WritableSheet
Removes a row from this spreadsheet.
removeSheet(int) - Method in class xl.write.WritableWorkbook
Removes the sheet at the specified index from this workbook

S

SEA_GREEN - Static variable in class xl.format.Color
SINGLE - Static variable in class xl.format.UnderlineStyle
SINGLE - Static variable in class xl.write.Font
Deprecated.  
SINGLE_ACCOUNTING - Static variable in class xl.format.UnderlineStyle
SINGLE_ACCOUNTING - Static variable in class xl.write.Font
Deprecated.  
SIZE_10x11 - Static variable in class xl.format.PaperSize
10�11 10" x 11"
SIZE_10x14 - Static variable in class xl.format.PaperSize
10" x 14"
SIZE_10x17 - Static variable in class xl.format.PaperSize
11" x 17"
SIZE_15x11 - Static variable in class xl.format.PaperSize
15�11 15" x 11"
SIZE_9x11 - Static variable in class xl.format.PaperSize
9x11 9" x 11"
SKY_BLUE - Static variable in class xl.format.Color
SLANTED_DASH_DOT - Static variable in class xl.format.BorderLineStyle
SOLID - Static variable in class xl.format.Pattern
STACKED - Static variable in class xl.format.Orientation
Cells with this specified orientation will have their text stacked downwards, but not rotated
STATEMENT - Static variable in class xl.format.PaperSize
Statement 5.5" x 8.5"
STRING_FORMULA - Static variable in class xl.CellType
SUBSCRIPT - Static variable in class xl.format.ScriptStyle
SUBSCRIPT - Static variable in class xl.write.Font
Deprecated.  
SUPERSCRIPT - Static variable in class xl.format.ScriptStyle
SUPERSCRIPT - Static variable in class xl.write.Font
Deprecated.  
SUPER_A_A4 - Static variable in class xl.format.PaperSize
Super A/A4 227mm x 356mm
SUPER_B_A3 - Static variable in class xl.format.PaperSize
Super B/A3 305mm x 487mm
ScriptStyle - class xl.format.ScriptStyle.
Enumeration class which contains the various script styles available within the standard Excel ScriptStyle palette
Sheet - interface xl.Sheet.
Represents a sheet within a workbook.
SheetSettings - class xl.SheetSettings.
This is a bean which client applications may use to get/set various properties which are associated with a particular worksheet, such as headers and footers, page orientation etc.
SheetSettings(Sheet) - Constructor for class xl.SheetSettings
Default constructor
SheetSettings(SheetSettings, Sheet) - Constructor for class xl.SheetSettings
Copy constructor.
StringFormulaCell - interface xl.StringFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for strings
setAlignment(Alignment) - Method in class xl.write.WritableCellFormat
Sets the horizontal alignment for this format
setArrayGrowSize(int) - Method in class xl.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 xl.WorkbookSettings
Sets the autofilter disabled
setAutomaticFormulaCalculation(boolean) - Method in class xl.SheetSettings
Sets the automatic formula calculation flag
setAutosize(boolean) - Method in class xl.CellView
Sets the autosize flag.
setBackground(Color) - Method in class xl.write.WritableCellFormat
Sets the background color for this cell format
setBackground(Color, Pattern) - Method in class xl.write.WritableCellFormat
Sets the background color and pattern for this cell format
setBoldStyle(WritableFont.BoldStyle) - Method in class xl.write.WritableFont
Sets the bold style for this font, if the font hasn't been initialized
setBorder(Border, BorderLineStyle) - Method in class xl.write.WritableCellFormat
Sets the specified border for this format
setBorder(Border, BorderLineStyle, Color) - Method in class xl.write.WritableCellFormat
Sets the specified border for this format
setBottomMargin(double) - Method in class xl.SheetSettings
Sets the bottom margin
setCellFeatures(WritableCellFeatures) - Method in interface xl.write.WritableCell
Sets the cell features
setCellFormat(CellFormat) - Method in interface xl.write.WritableCell
Sets the cell format for this cell
setCellValidationDisabled(boolean) - Method in class xl.WorkbookSettings
Sets the ignore cell validation flag
setCharacterSet(int) - Method in class xl.WorkbookSettings
Sets the character set.
setColor(Color) - Method in class xl.write.WritableFont
Sets the color for this font, if the font hasn't been initialized
setColorRGB(Color, int, int, int) - Method in class xl.write.WritableWorkbook
Sets the RGB value for the specified color for this workbook
setColumn(double) - Method in class xl.write.WritableImage
Accessor for the image position
setColumnGroup(int, int, boolean) - Method in interface xl.write.WritableSheet
Sets a column grouping
setColumnView(int, int) - Method in interface xl.write.WritableSheet
Sets the width of the column on this sheet, in characters.
setColumnView(int, int, CellFormat) - Method in interface xl.write.WritableSheet
Deprecated. Use the CellView bean instead
setColumnView(int, CellView) - Method in interface xl.write.WritableSheet
Sets the view for this column
setComment(String) - Method in class xl.write.WritableCellFeatures
Sets the cell comment
setComment(String, double, double) - Method in class xl.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 xl.SheetSettings
Sets the number of copies
setDataValidationList(Collection) - Method in class xl.write.WritableCellFeatures
The list of items to validate for this cell.
setDataValidationRange(int, int, int, int) - Method in class xl.write.WritableCellFeatures
The list of items to validate for this cell in the form of a cell range.
setDataValidationRange(String) - Method in class xl.write.WritableCellFeatures
Sets the data validation based upon a named range
setDate(Date) - Method in class xl.write.DateTime
Sets the date for this cell
setDate(Date, DateRecord.GMTDate) - Method in class xl.write.DateTime
Sets the date for this cell, performing the necessary timezone adjustments
setDefaultColumnWidth(int) - Method in class xl.SheetSettings
Sets the default column width
setDefaultRowHeight(int) - Method in class xl.SheetSettings
Sets the default row height
setDescription(String) - Method in class xl.write.WritableHyperlink
Sets the description to appear in the hyperlink cell
setDimension(int) - Method in class xl.CellView
Deprecated. use the setSize method instead
setDisplayZeroValues(boolean) - Method in class xl.SheetSettings
Sets the displayZeroValues property
setDrawingsDisabled(boolean) - Method in class xl.WorkbookSettings
Disables the handling of drawings
setEncoding(String) - Method in class xl.WorkbookSettings
Sets the encoding for this workbook
setExcelDisplayLanguage(String) - Method in class xl.WorkbookSettings
Sets the language in which the generated file will display
setExcelRegionalSettings(String) - Method in class xl.WorkbookSettings
Sets the regional settings for the generated excel file
setFile(File) - Method in class xl.write.WritableHyperlink
Sets the file activated by this hyperlink
setFitHeight(int) - Method in class xl.SheetSettings
Sets the number of pages vertically that this sheet will be printed into
setFitToPages(boolean) - Method in class xl.SheetSettings
Accessor for the fit to pages flag
setFitWidth(int) - Method in class xl.SheetSettings
Sets the number of pages widthwise which this sheet should be printed into
setFontName(String) - Method in class xl.HeaderFooter.Contents
Sets the font of text subsequently appended to this object..
setFontSize(int) - Method in class xl.HeaderFooter.Contents
Sets the font size of text subsequently appended to this object.
setFooter(HeaderFooter) - Method in class xl.SheetSettings
Sets the footer
setFooter(String, String, String) - Method in interface xl.write.WritableSheet
Deprecated. use the SheetSettings bean
setFooterMargin(double) - Method in class xl.SheetSettings
Sets the margin for any page footer
setFormat(CellFormat) - Method in class xl.CellView
Sets the cell format for this group of cells
setFormulaAdjust(boolean) - Method in class xl.WorkbookSettings
Setter for the formula adjust disabled property
setGCDisabled(boolean) - Method in class xl.WorkbookSettings
Sets the garbage collection disabled
setHeader(HeaderFooter) - Method in class xl.SheetSettings
Sets the header
setHeader(String, String, String) - Method in interface xl.write.WritableSheet
Deprecated. use the SheetSettings bean
setHeaderMargin(double) - Method in class xl.SheetSettings
Sets the margin for any page headers
setHeight(double) - Method in class xl.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 xl.CellView
Sets the hidden status of this row/column
setHidden(boolean) - Method in class xl.SheetSettings
Sets the hidden status of this worksheet
setHidden(boolean) - Method in interface xl.write.WritableSheet
Deprecated. use the SheetSettings bean instead
setHorizontalCenter(boolean) - Method in class xl.SheetSettings
Sets the horizontal center
setHorizontalFreeze(int) - Method in class xl.SheetSettings
Sets the row at which the pane is frozen horizontally
setHorizontalPrintResolution(int) - Method in class xl.SheetSettings
Sets the horizontal print resolution
setIgnoreBlanks(boolean) - Method in class xl.WorkbookSettings
Sets the ignore blanks flag
setImageAnchor(Drawing.ImageAnchorProperties) - Method in class xl.write.WritableImage
Accessor for the anchor properties
setIndentation(int) - Method in class xl.write.WritableCellFormat
Sets the indentation of the cell text
setInitialFileSize(int) - Method in class xl.WorkbookSettings
Sets the initial amount of memory allocated to store the workbook data when reading a worksheet.
setItalic(boolean) - Method in class xl.write.WritableFont
Sets the italic indicator for this font, if the font hasn't been initialized
setLeftMargin(double) - Method in class xl.SheetSettings
Sets the left margin
setLocale(Locale) - Method in class xl.WorkbookSettings
Sets the locale used by Excel API to generate the spreadsheet.
setLocation(String, WritableSheet, int, int, int, int) - Method in class xl.write.WritableHyperlink
Sets the location of the cells to be linked to within this workbook
setLocked(boolean) - Method in class xl.write.WritableCellFormat
Sets whether or not this XF record locks the cell.
setMergedCellChecking(boolean) - Method in class xl.WorkbookSettings
Accessor to set the merged cell checking
setName(String) - Method in interface xl.write.WritableSheet
Sets the name of this sheet
setNamesDisabled(boolean) - Method in class xl.WorkbookSettings
Disables the handling of names
setNormalMagnification(int) - Method in class xl.SheetSettings
Accessor for the normal magnificaton factor.
setNumberValidation(double, BaseCellFeatures.ValidationCondition) - Method in class xl.write.WritableCellFeatures
Sets the numeric value against which to validate
setNumberValidation(double, double, BaseCellFeatures.ValidationCondition) - Method in class xl.write.WritableCellFeatures
Sets the numeric range against which to validate the data
setOrientation(PageOrientation) - Method in class xl.SheetSettings
Sets the paper orientation for printing this sheet
setOrientation(Orientation) - Method in class xl.write.WritableCellFormat
Sets the text orientation for this format
setOutputFile(File) - Method in class xl.write.WritableWorkbook
Sets a new output file.
setPageBreakPreviewMagnification(int) - Method in class xl.SheetSettings
Accessor for the page break preview magnificaton factor.
setPageBreakPreviewMode(boolean) - Method in class xl.SheetSettings
Sets the pageBreakPreviewMode property
setPageSetup(PageOrientation) - Method in interface xl.write.WritableSheet
Sets the page setup details
setPageSetup(PageOrientation, double, double) - Method in interface xl.write.WritableSheet
Sets the page setup details
setPageSetup(PageOrientation, PaperSize, double, double) - Method in interface xl.write.WritableSheet
Sets the page setup details
setPageStart(int) - Method in class xl.SheetSettings
Sets the page number at which to commence printing
setPaperSize(PaperSize) - Method in class xl.SheetSettings
Sets the paper size to be used when printing this sheet
setPassword(String) - Method in class xl.SheetSettings
Sets the password for this sheet
setPasswordHash(int) - Method in class xl.SheetSettings
Accessor for the password hash - used only when copying sheets
setPointSize(int) - Method in class xl.write.WritableFont
Sets the point size for this font, if the font hasn't been initialized
setPrintArea(int, int, int, int) - Method in class xl.SheetSettings
Sets the print area for this sheet
setPrintGridLines(boolean) - Method in class xl.SheetSettings
Sets the printGridLines property
setPrintHeaders(boolean) - Method in class xl.SheetSettings
Sets the printHeaders property
setPrintTitles(int, int, int, int) - Method in class xl.SheetSettings
Sets both of the print titles for this sheet
setPrintTitlesCol(int, int) - Method in class xl.SheetSettings
Sets the print column titles for this sheet
setPrintTitlesRow(int, int) - Method in class xl.SheetSettings
Sets the print row titles for this sheet
setPropertySets(boolean) - Method in class xl.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 XL process using more memory
setProtected(boolean) - Method in class xl.SheetSettings
Sets the protected (ie.
setProtected(boolean) - Method in interface xl.write.WritableSheet
Deprecated. use the SheetSettings bean instead
setProtected(boolean) - Method in class xl.write.WritableWorkbook
Indicates whether or not this workbook is protected
setRationalization(boolean) - Method in class xl.WorkbookSettings
Sets whether or not to rationalize the cell formats before writing out the sheet.
setRecalculateFormulasBeforeSave(boolean) - Method in class xl.SheetSettings
Sets the recalculate formulas when the sheet is saved flag
setRightMargin(double) - Method in class xl.SheetSettings
Sets the right margin
setRow(double) - Method in class xl.write.WritableImage
Accessor for the image position
setRowGroup(int, int, boolean) - Method in interface xl.write.WritableSheet
Sets a row grouping
setRowView(int, int) - Method in interface xl.write.WritableSheet
Sets the height of the specified row, as well as its collapse status
setRowView(int, boolean) - Method in interface xl.write.WritableSheet
Sets the properties of the specified row
setRowView(int, int, boolean) - Method in interface xl.write.WritableSheet
Sets the height of the specified row, as well as its collapse status
setRowView(int, CellView) - Method in interface xl.write.WritableSheet
Sets the view for this column
setScaleFactor(int) - Method in class xl.SheetSettings
Sets the scale factor for this sheet to be used when printing.
setScriptStyle(ScriptStyle) - Method in class xl.write.WritableFont
Sets the script style (eg.
setSelected() - Method in class xl.SheetSettings
Deprecated. use overloaded version which takes a boolean
setSelected(boolean) - Method in class xl.SheetSettings
Sets this sheet to be when it is opened in excel
setShowGridLines(boolean) - Method in class xl.SheetSettings
Sets the showGridLines property
setShrinkToFit(boolean) - Method in class xl.write.WritableCellFormat
Sets the shrink to fit flag
setSize(int) - Method in class xl.CellView
Sets the dimension for this view
setString(String) - Method in class xl.write.Label
Sets the string contents of this cell
setStruckout(boolean) - Method in class xl.write.WritableFont
Sets Accessor for the strike-out flag
setSuppressWarnings(boolean) - Method in class xl.WorkbookSettings
Accessor to set the suppress warnings flag.
setTemporaryFileDuringWriteDirectory(File) - Method in class xl.WorkbookSettings
Used in conjunction with the UseTemporaryFileDuringWrite setting to set the target directory for the temporary files.
setTopMargin(double) - Method in class xl.SheetSettings
Sets the top margin
setURL(URL) - Method in class xl.write.WritableHyperlink
Sets the URL of this hyperlink
setUnderlineStyle(UnderlineStyle) - Method in class xl.write.WritableFont
Sets the underline style for this font, if the font hasn't been initialized
setUseTemporaryFileDuringWrite(boolean) - Method in class xl.WorkbookSettings
Sets whether a temporary file is used during the generation of the workbook.
setValue(boolean) - Method in class xl.write.Boolean
Sets the boolean value for this cell
setValue(double) - Method in class xl.write.Number
Sets the numerical value for this cell
setVerticalAlignment(VerticalAlignment) - Method in class xl.write.WritableCellFormat
Sets the vertical alignment for this format
setVerticalCenter(boolean) - Method in class xl.SheetSettings
Sets the vertical center
setVerticalFreeze(int) - Method in class xl.SheetSettings
Sets the row at which the pane is frozen vertically
setVerticalPrintResolution(int) - Method in class xl.SheetSettings
Sets the vertical print reslution
setWidth(double) - Method in class xl.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
setWrap(boolean) - Method in class xl.write.WritableCellFormat
Sets the wrap indicator for this format.
setZoomFactor(int) - Method in class xl.SheetSettings
Sets the zoom factor.

T

TABLOID - Static variable in class xl.format.PaperSize
Tabloid 11" x 17"
TABLOID_EXTRA - Static variable in class xl.format.PaperSize
Tabloid Extra 11 11/16" x 18"
TAHOMA - Static variable in class xl.write.WritableFont
Objects created with this font name will be rendered within Excel as TAHOMA fonts
TAN - Static variable in class xl.format.Color
TEAL - Static variable in class xl.format.Color
TEAL2 - Static variable in class xl.format.Color
TEXT - Static variable in class xl.write.NumberFormats
Forces numbers to be interpreted as text
THICK - Static variable in class xl.format.BorderLineStyle
THIN - Static variable in class xl.format.BorderLineStyle
THOUSANDS_FLOAT - Static variable in class xl.write.NumberFormats
Formatting for a float that has a thousands separator.
THOUSANDS_INTEGER - Static variable in class xl.write.NumberFormats
Formatting for an integer that has a thousands separator.
TIMES - Static variable in class xl.write.Font
Deprecated.  
TIMES - Static variable in class xl.write.WritableFont
Objects created with this font name will be rendered within Excel as TIMES fonts
TOP - Static variable in class xl.format.Border
TOP - Static variable in class xl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned at the top
TURQOISE2 - Static variable in class xl.format.Color
TURQUOISE - Static variable in class xl.format.Color
toString() - Method in class xl.CellType
Returns a string description of this cell
toString() - Method in class xl.HeaderFooter
Retrieves a Stringified version of this object
toggleBold() - Method in class xl.HeaderFooter.Contents
Turns bold printing on or off.
toggleDoubleUnderline() - Method in class xl.HeaderFooter.Contents
Turns double-underline printing on or off.
toggleItalics() - Method in class xl.HeaderFooter.Contents
Turns italics printing on or off.
toggleOutline() - Method in class xl.HeaderFooter.Contents
Turns outline printing on or off (Macintosh only).
toggleShadow() - Method in class xl.HeaderFooter.Contents
Turns shadow printing on or off (Macintosh only).
toggleStrikethrough() - Method in class xl.HeaderFooter.Contents
Turns strikethrough printing on or off.
toggleSubScript() - Method in class xl.HeaderFooter.Contents
Turns subscript printing on or off.
toggleSuperScript() - Method in class xl.HeaderFooter.Contents
Turns superscript printing on or off.
toggleUnderline() - Method in class xl.HeaderFooter.Contents
Turns underline printing on or off.

U

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

V

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

W

WHITE - Static variable in class xl.format.Color
Workbook - class xl.Workbook.
Represents a Workbook.
WorkbookSettings - class xl.WorkbookSettings.
This is a bean which client applications may use to set various advanced workbook properties.
WorkbookSettings() - Constructor for class xl.WorkbookSettings
Default constructor
WritableCell - interface xl.write.WritableCell.
The interface for all writable cells
WritableCellFeatures - class xl.write.WritableCellFeatures.
Container for any additional cell features
WritableCellFeatures() - Constructor for class xl.write.WritableCellFeatures
Constructor
WritableCellFeatures(CellFeatures) - Constructor for class xl.write.WritableCellFeatures
Copy constructor
WritableCellFormat - class xl.write.WritableCellFormat.
A user specified cell format, which may be reused across many cells.
WritableCellFormat() - Constructor for class xl.write.WritableCellFormat
A default constructor, which uses the default font and format.
WritableCellFormat(WritableFont) - Constructor for class xl.write.WritableCellFormat
A CellFormat which specifies the font for cells with this format
WritableCellFormat(DisplayFormat) - Constructor for class xl.write.WritableCellFormat
A constructor which specifies a date/number format for Cells which use this format object
WritableCellFormat(WritableFont, DisplayFormat) - Constructor for class xl.write.WritableCellFormat
A constructor which specifies the font and date/number format for cells which wish to use this format
WritableCellFormat(CellFormat) - Constructor for class xl.write.WritableCellFormat
A public copy constructor which can be used for copy formats between different sheets
WritableFont - class xl.write.WritableFont.
A class which is instantiated when the user application wishes to specify the font for a particular cell
WritableFont(WritableFont.FontName) - Constructor for class xl.write.WritableFont
Creates a default font, vanilla font of the specified face and with default point size.
WritableFont(Font) - Constructor for class xl.write.WritableFont
Publicly available copy constructor
WritableFont(WritableFont.FontName, int) - Constructor for class xl.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 xl.write.WritableFont
Creates a font of the specified face, point size and bold style
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean) - Constructor for class xl.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 xl.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, Color) - Constructor for class xl.write.WritableFont
Creates a font of the specified face, point size, bold style, italicisation, underline style and color
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Color, ScriptStyle) - Constructor for class xl.write.WritableFont
Creates a font of the specified face, point size, bold style, italicisation, underline style, color, and script style (superscript/subscript)
WritableFont.FontName - class xl.write.WritableFont.FontName.
Static inner class used for classifying the font names
WritableHyperlink - class xl.write.WritableHyperlink.
A writable hyperlink.
WritableHyperlink(Hyperlink, WritableSheet) - Constructor for class xl.write.WritableHyperlink
Constructor used internally by the worksheet when making a copy of worksheet
WritableHyperlink(int, int, URL) - Constructor for class xl.write.WritableHyperlink
Constructs a URL hyperlink in a single cell
WritableHyperlink(int, int, int, int, URL) - Constructor for class xl.write.WritableHyperlink
Constructs a url hyperlink to a range of cells
WritableHyperlink(int, int, int, int, URL, String) - Constructor for class xl.write.WritableHyperlink
Constructs a url hyperlink to a range of cells
WritableHyperlink(int, int, File) - Constructor for class xl.write.WritableHyperlink
Constructs a file hyperlink in a single cell
WritableHyperlink(int, int, File, String) - Constructor for class xl.write.WritableHyperlink
Constructs a file hyperlink in a single cell
WritableHyperlink(int, int, int, int, File) - Constructor for class xl.write.WritableHyperlink
Constructs a File hyperlink to a range of cells
WritableHyperlink(int, int, int, int, File, String) - Constructor for class xl.write.WritableHyperlink
Constructs a File hyperlink to a range of cells
WritableHyperlink(int, int, String, WritableSheet, int, int) - Constructor for class xl.write.WritableHyperlink
Constructs a hyperlink to some cells within this workbook
WritableHyperlink(int, int, int, int, String, WritableSheet, int, int, int, int) - Constructor for class xl.write.WritableHyperlink
Constructs a hyperlink to some cells within this workbook
WritableImage - class xl.write.WritableImage.
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, File) - Constructor for class xl.write.WritableImage
Constructor
WritableImage(double, double, double, double, byte[]) - Constructor for class xl.write.WritableImage
Constructor
WritableImage(DrawingGroupObject, DrawingGroup) - Constructor for class xl.write.WritableImage
Constructor, used when copying sheets
WritableSheet - interface xl.write.WritableSheet.
Interface for a worksheet that may be modified.
WritableWorkbook - class xl.write.WritableWorkbook.
A writable workbook
WriteException - exception xl.write.WriteException.
Exception thrown when using the API to generate an Excel file
write() - Method in class xl.write.WritableWorkbook
Writes out the data held in this workbook in Excel format

X

XML - class xl.util.XML.
Util class which uses the api to present the contents of an Excel Worksheet as an XML document, using a workbook and output stream of your choice
XML(Workbook, OutputStream, String, boolean) - Constructor for class xl.util.XML
Constructor

Y

YELLOW - Static variable in class xl.format.Color
YELLOW2 - Static variable in class xl.format.Color

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