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

A

A3 - Static variable in class jxl.format.PaperSize
A3
A4 - Static variable in class jxl.format.PaperSize
A4
A4_SMALL - Static variable in class jxl.format.PaperSize
Small A4
A5 - Static variable in class jxl.format.PaperSize
A5
ACCOUNTING_FLOAT - Static variable in class jxl.write.NumberFormats
Formatting for an integer which is presented in accounting format (ie.
ACCOUNTING_INTEGER - Static variable in class jxl.write.NumberFormats
Formatting for an integer which is presented in accounting format (ie.
ACCOUNTING_RED_FLOAT - Static variable in class jxl.write.NumberFormats
As ACCOUNTING_FLOAT except that deficits appear coloured red
ACCOUNTING_RED_INTEGER - Static variable in class jxl.write.NumberFormats
As ACCOUNTING_INTEGER except that deficits appear coloured red
ALL - Static variable in class jxl.format.Border
 
AQUA - Static variable in class jxl.format.Colour
 
ARIAL - Static variable in class jxl.write.WritableFont
Objects created with this font name will be rendered within Excel as ARIAL fonts
ARIAL_10_PT - Static variable in class jxl.write.WritableWorkbook
The default font for Cell formats
AUTOMATIC - Static variable in class jxl.format.Colour
 
Alignment - class jxl.format.Alignment.
Enumeration class which contains the various alignments for data within a cell
addCell(WritableCell) - Method in interface jxl.write.WritableSheet
Adds a cell to this sheet The RowsExceededException may be caught if client code wishes to explicitly trap the case where too many rows have been written to the current sheet.
addHyperlink(WritableHyperlink) - Method in interface jxl.write.WritableSheet
Adds the specified hyperlink.
addImage(WritableImage) - Method in interface jxl.write.WritableSheet
Adds an image to the sheet
addRowPageBreak(int) - Method in interface jxl.write.WritableSheet
Forces a page break at the specified row
append(String) - Method in class jxl.HeaderFooter.Contents
Appends the text to the string buffer
appendDate() - Method in class jxl.HeaderFooter.Contents
Appends the current date
appendPageNumber() - Method in class jxl.HeaderFooter.Contents
Appends the page number
appendTime() - Method in class jxl.HeaderFooter.Contents
Appends the current time
appendTotalPages() - Method in class jxl.HeaderFooter.Contents
Appends the total number of pages
appendWorkSheetName() - Method in class jxl.HeaderFooter.Contents
Appends the worksheet name
appendWorkbookName() - Method in class jxl.HeaderFooter.Contents
Appends the workbook name

B

BLACK - Static variable in class jxl.format.Colour
 
BLUE - Static variable in class jxl.format.Colour
 
BLUE2 - Static variable in class jxl.format.Colour
 
BLUE_GREY - Static variable in class jxl.format.Colour
 
BOLD - Static variable in class jxl.format.BoldStyle
Emboldened style
BOLD - Static variable in class jxl.write.WritableFont
Indicates that this font should be presented in a BOLD style
BOOLEAN - Static variable in class jxl.CellType
 
BOOLEAN_FORMULA - Static variable in class jxl.CellType
 
BOTTOM - Static variable in class jxl.format.Border
 
BOTTOM - Static variable in class jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned at the bottom
BRIGHT_GREEN - Static variable in class jxl.format.Colour
 
BROWN - Static variable in class jxl.format.Colour
 
Blank - class jxl.write.Blank.
A blank cell.
Blank(int, int) - Constructor for class jxl.write.Blank
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates
Blank(int, int, CellFormat) - Constructor for class jxl.write.Blank
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates in the manner specified by the CellFormat parameter
Blank(Cell) - Constructor for class jxl.write.Blank
Constructor used internally by the application when making a writable copy of a spreadsheet being read in
BoldStyle - class jxl.format.BoldStyle.
Enumeration class containing the various bold styles for data
BoldStyle - class jxl.write.BoldStyle.
Enumeration class containing the various bold styles for data
Boolean - class jxl.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 jxl.write.Boolean
Constructs a boolean value, which, when added to a spreadsheet, will display the specified value at the column/row position indicated.
Boolean(int, int, boolean, CellFormat) - Constructor for class jxl.write.Boolean
Constructs a boolean, which, when added to a spreadsheet, will display the specified value at the column/row position with the specified CellFormat.
Boolean(BooleanCell) - Constructor for class jxl.write.Boolean
Constructor used internally by the application when making a writable copy of a spreadsheet that has been read in
BooleanCell - interface jxl.BooleanCell.
This type represents the Microsoft concept of a Boolean.
BooleanFormulaCell - interface jxl.BooleanFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
Border - class jxl.format.Border.
The location of a border
BorderLineStyle - class jxl.format.BorderLineStyle.
The border line style

C

CENTRE - Static variable in class jxl.format.Alignment
Data in cells with this alignment will be centred
CENTRE - Static variable in class jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned centrally
CORAL - Static variable in class jxl.format.Colour
 
COURIER - Static variable in class jxl.write.WritableFont
Objects created with this font name will be rendered within Excel as COURIER fonts
CSV - class jxl.demo.CSV.
Simple demo class which uses the api to present the contents of an excel 97 spreadsheet as comma separated values, using a workbook and output stream of your choice
CSV(Workbook, OutputStream, String, boolean) - Constructor for class jxl.demo.CSV
Constructor
Cell - interface jxl.Cell.
Represents an individual Cell within a Sheet.
CellFormat - interface jxl.format.CellFormat.
Interface for cell formats
CellReferenceHelper - class jxl.CellReferenceHelper.
Exposes some cell reference helper methods to the public interface.
CellType - class jxl.CellType.
An enumeration type listing the available content types for a cell
CellView - class jxl.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 jxl.CellView
Default constructor
Colour - class jxl.format.Colour.
Enumeration class which contains the various colours available within the standard Excel colour palette
clear() - Method in class jxl.HeaderFooter.Contents
Clears the contents of this portion
clear() - Method in class jxl.HeaderFooter
Clears the contents of the header/footer
close() - Method in class jxl.Workbook
Closes this workbook, and frees makes any memory allocated available for garbage collection
close() - Method in class jxl.write.WritableWorkbook
Closes this workbook, and makes any memory allocated available for garbage collection.
copySheet(int, String, int) - Method in class jxl.write.WritableWorkbook
Copies the specified sheet and places it at the index specified by the parameter
copySheet(String, String, int) - Method in class jxl.write.WritableWorkbook
Copies the specified sheet and places it at the index specified by the parameter
copyTo(int, int) - Method in class jxl.write.Blank
Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.Boolean
Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.DateTime
Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.Formula
Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.Label
Implementation of the deep copy function
copyTo(int, int) - Method in class jxl.write.Number
Implementation of the deep copy function
copyTo(int, int) - Method in interface jxl.write.WritableCell
A deep copy.
createFont(String) - Static method in class jxl.write.WritableFont
Factory method which creates the specified font name.
createSheet(String, int) - Method in class jxl.write.WritableWorkbook
Creates, and returns a worksheet at the specified position with the specified name If the index specified is less than or equal to zero, the new sheet is created at the beginning of the workbook.
createWorkbook(File) - Static method in class jxl.Workbook
Creates a writable workbook with the given file name
createWorkbook(File, WorkbookSettings) - Static method in class jxl.Workbook
Creates a writable workbook with the given file name
createWorkbook(File, Workbook) - Static method in class jxl.Workbook
Creates a writable workbook with the given filename as a copy of the workbook passed in.
createWorkbook(File, Workbook, WorkbookSettings) - Static method in class jxl.Workbook
Creates a writable workbook with the given filename as a copy of the workbook passed in.
createWorkbook(OutputStream, Workbook) - Static method in class jxl.Workbook
Creates a writable workbook as a copy of the workbook passed in.
createWorkbook(OutputStream, Workbook, WorkbookSettings) - Static method in class jxl.Workbook
Creates a writable workbook as a copy of the workbook passed in.
createWorkbook(OutputStream) - Static method in class jxl.Workbook
Creates a writable workbook.
createWorkbook(OutputStream, WorkbookSettings) - Static method in class jxl.Workbook
Creates a writable workbook.

D

DARK_BLUE - Static variable in class jxl.format.Colour
 
DARK_BLUE2 - Static variable in class jxl.format.Colour
 
DARK_GREEN - Static variable in class jxl.format.Colour
 
DARK_PURPLE - Static variable in class jxl.format.Colour
 
DARK_RED - Static variable in class jxl.format.Colour
 
DARK_RED2 - Static variable in class jxl.format.Colour
 
DARK_TEAL - Static variable in class jxl.format.Colour
 
DARK_YELLOW - Static variable in class jxl.format.Colour
 
DASHED - Static variable in class jxl.format.BorderLineStyle
 
DASH_DOT - Static variable in class jxl.format.BorderLineStyle
 
DASH_DOT_DOT - Static variable in class jxl.format.BorderLineStyle
 
DATE - Static variable in class jxl.CellType
 
DATE_FORMULA - Static variable in class jxl.CellType
 
DEFAULT - Static variable in class jxl.write.DateFormats
The default format.
DEFAULT - Static variable in class jxl.write.NumberFormats
The default format.
DEFAULT_BACKGROUND - Static variable in class jxl.format.Colour
 
DEFAULT_BACKGROUND1 - Static variable in class jxl.format.Colour
 
DEFAULT_DEFAULT_ROW_HEIGHT - Static variable in class jxl.SheetSettings
The default value for the default row height
DEFAULT_POINT_SIZE - Static variable in class jxl.write.WritableFont
The default point size for all Fonts
DOTTED - Static variable in class jxl.format.BorderLineStyle
 
DOUBLE - Static variable in class jxl.format.BorderLineStyle
 
DOUBLE - Static variable in class jxl.format.UnderlineStyle
 
DOUBLE_ACCOUNTING - Static variable in class jxl.format.UnderlineStyle
 
DateCell - interface jxl.DateCell.
A date cell
DateFormat - class jxl.write.DateFormat.
A custom user defined number format which may be instantiated within user applications in order to present date and time values in the appropriate format.
DateFormat(String) - Constructor for class jxl.write.DateFormat
Constructor.
DateFormats - class jxl.write.DateFormats.
Static class which contains Excels predefined Date formats
DateFormats() - Constructor for class jxl.write.DateFormats
 
DateFormulaCell - interface jxl.DateFormulaCell.
A mixin interface for date formulas, which combines the interfaces for formulas and for dates
DateTime - class jxl.write.DateTime.
A Date which may be created on the fly by a user application and added to a spreadsheet NOTE: By default, all dates will have local timezone information added to their UTC value.
DateTime(int, int, Date) - Constructor for class jxl.write.DateTime
Constructor
DateTime(int, int, Date, DateRecord.GMTDate) - Constructor for class jxl.write.DateTime
Constructor, which adjusts the specified date to take timezone considerations into account
DateTime(int, int, Date, CellFormat) - Constructor for class jxl.write.DateTime
Constructor which takes the format for this cell
DateTime(int, int, Date, CellFormat, DateRecord.GMTDate) - Constructor for class jxl.write.DateTime
Constructor, which adjusts the specified date to take timezone considerations into account
DateTime(int, int, Date, CellFormat, boolean) - Constructor for class jxl.write.DateTime
Constructor which takes the format for the cell and an indicator as to whether this cell is a full date time or purely just a time eg.
DateTime(DateCell) - Constructor for class jxl.write.DateTime
A constructor called by the worksheet when creating a writable version of a spreadsheet that has been read in
Demo - class jxl.demo.Demo.
The main demo class which interprets the command line switches in order to determine how to call the demo programs The demo program uses stdout as its default output stream
Demo() - Constructor for class jxl.demo.Demo
 
depUsed() - Method in class jxl.CellView
Accessor for the depUsed attribute

E

EMPTY - Static variable in class jxl.CellType
 
ERROR - Static variable in class jxl.CellType
 
EXPONENTIAL - Static variable in class jxl.write.NumberFormats
Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00"
ErrorCell - interface jxl.ErrorCell.
This type represents a cell which contains an error.
ErrorFormulaCell - interface jxl.ErrorFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
empty() - Method in class jxl.HeaderFooter.Contents
Queries if the contents are empty

F

FILL - Static variable in class jxl.format.Alignment
Data in cells with this alignment will fill the cell
FLOAT - Static variable in class jxl.write.NumberFormats
Formatting for a float.
FORMAT1 - Static variable in class jxl.write.DateFormats
The default format.
FORMAT1 - Static variable in class jxl.write.NumberFormats
Equivalent to a DecimalFormat "#,##0;(#,##0)"
FORMAT10 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "mm:ss"
FORMAT10 - Static variable in class jxl.write.NumberFormats
Equivalent to DecimalFormat "##0.0E0"
FORMAT11 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "H:mm:ss"
FORMAT12 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "mm:ss.S"
FORMAT2 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "d-MMM-yy"
FORMAT2 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT1 except deficits are coloured red
FORMAT3 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "d-MMM"
FORMAT3 - Static variable in class jxl.write.NumberFormats
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
FORMAT4 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "MMM-yy"
FORMAT4 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT3 except deficits are coloured red
FORMAT5 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "h:mm a"
FORMAT5 - Static variable in class jxl.write.NumberFormats
Equivalent to DecimalFormat "#,##0;(#,##0)"
FORMAT6 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "h:mm:ss a"
FORMAT6 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT5 except deficits are coloured red
FORMAT7 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "H:mm"
FORMAT7 - Static variable in class jxl.write.NumberFormats
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
FORMAT8 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "H:mm:ss"
FORMAT8 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT7 except deficits are coloured red
FORMAT9 - Static variable in class jxl.write.DateFormats
Equivalent to a date format of "M/d/yy H:mm"
FORMAT9 - Static variable in class jxl.write.NumberFormats
Equivalent to FORMAT7
FORMULA_ERROR - Static variable in class jxl.CellType
 
Font - interface jxl.format.Font.
Interface which exposes the user font display information to the user
Format - interface jxl.format.Format.
Exposes the cell formatting information
Formula - class jxl.write.Formula.
A cell, created by user applications, which contains a numerical value
Formula(int, int, String) - Constructor for class jxl.write.Formula
Constructs the formula
Formula(int, int, String, CellFormat) - Constructor for class jxl.write.Formula
Constructs a formula
FormulaCell - interface jxl.FormulaCell.
Interface for formulas which allow clients to read the Excel formula
Formulas - class jxl.demo.Formulas.
Goes through each cell in the workbook, and if the contents of that cell is a formula, it prints out the last calculated value and the formula string
Formulas(Workbook, OutputStream, String) - Constructor for class jxl.demo.Formulas
Constructor
findByName(String) - Method in class jxl.Workbook
Gets the named range from this workbook.
findByName(String) - Method in class jxl.write.WritableWorkbook
Gets the named range from this workbook.
findCell(String) - Method in interface jxl.Sheet
Gets the cell whose contents match the string passed in.
findCellByName(String) - Method in class jxl.Workbook
Gets the named cell from this workbook.
findCellByName(String) - Method in class jxl.write.WritableWorkbook
Gets the named cell from this workbook.
findLabelCell(String) - Method in interface jxl.Sheet
Gets the cell whose contents match the string passed in.

G

GENERAL - Static variable in class jxl.format.Alignment
The standard alignment
GMT - Static variable in class jxl.write.DateTime
Instance variable for dummy variable overload
GOLD - Static variable in class jxl.format.Colour
 
GRAY_25 - Static variable in class jxl.format.Colour
 
GRAY_25 - Static variable in class jxl.format.Pattern
 
GRAY_50 - Static variable in class jxl.format.Colour
 
GRAY_50 - Static variable in class jxl.format.Pattern
 
GRAY_75 - Static variable in class jxl.format.Pattern
 
GRAY_80 - Static variable in class jxl.format.Colour
 
GREEN - Static variable in class jxl.format.Colour
 
GREY_25_PERCENT - Static variable in class jxl.format.Colour
 
GREY_40_PERCENT - Static variable in class jxl.format.Colour
 
GREY_50_PERCENT - Static variable in class jxl.format.Colour
 
GREY_80_PERCENT - Static variable in class jxl.format.Colour
 
getAlignment(int) - Static method in class jxl.format.Alignment
Gets the alignment from the value
getAlignment() - Method in interface jxl.format.CellFormat
Gets the horizontal cell alignment
getAlignment(int) - Static method in class jxl.format.VerticalAlignment
Gets the alignment from the value
getAllColours() - Static method in class jxl.format.Colour
Returns all available colours - used when generating the default palette
getArrayGrowSize() - Method in class jxl.WorkbookSettings
Accessor for the array grow size property
getBackgroundColour() - Method in interface jxl.format.CellFormat
Gets the background colour used by this cell
getBoldWeight() - Method in interface jxl.format.Font
Gets the bold weight for this font
getBorder(Border) - Method in interface jxl.format.CellFormat
Gets the line style for the given cell border If a border type of ALL or NONE is specified, then a line style of NONE is returned
getBorderColour(Border) - Method in interface jxl.format.CellFormat
Gets the colour for the given cell border If a border type of ALL or NONE is specified, then a line style of NONE is returned If the specified cell does not have an associated line style, then the colour the line would be is still returned
getBorderLine(Border) - Method in interface jxl.format.CellFormat
Gets the line style for the given cell border If a border type of ALL or NONE is specified, then a line style of NONE is returned
getBottomMargin() - Method in class jxl.SheetSettings
Accessor for the bottom margin
getBottomRight() - Method in interface jxl.Range
Gets the cell at the bottom right of this range
getCell(int, int) - Method in interface jxl.Sheet
Returns the cell specified at this row and at this column.
getCellFormat() - Method in interface jxl.Cell
Gets the cell format which applies to this cell Note that for cell with a cell type of EMPTY, which has no formatting information, this method will return null.
getCellReference(int, int, StringBuffer) - Static method in class jxl.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 jxl.CellReferenceHelper
Overloaded method which prepends $ for absolute reference
getCellReference(int, int) - Static method in class jxl.CellReferenceHelper
Gets the cell reference for the specified column and row
getCellReference(int, int, int, Workbook, StringBuffer) - Static method in class jxl.CellReferenceHelper
Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, int, WritableWorkbook, StringBuffer) - Static method in class jxl.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 jxl.CellReferenceHelper
Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, int, Workbook) - Static method in class jxl.CellReferenceHelper
Gets the fully qualified cell reference given the column, row external sheet reference etc
getCellReference(int, int, int, WritableWorkbook) - Static method in class jxl.CellReferenceHelper
Gets the fully qualified cell reference given the column, row external sheet reference etc
getCentre() - Method in class jxl.HeaderFooter
Accessor for the contents which in the centre of the page
getCharacterSet() - Method in class jxl.WorkbookSettings
Accessor for the character set.
getColour() - Method in interface jxl.format.Font
Gets the colour for this font
getColumn() - Method in interface jxl.Cell
Returns the column number of this cell
getColumn(String) - Static method in class jxl.CellReferenceHelper
Gets the columnn number of the string cell reference
getColumn() - Method in interface jxl.Hyperlink
Returns the column number of this cell
getColumn(int) - Method in interface jxl.Sheet
Gets all the cells on the specified column
getColumn() - Method in class jxl.write.WritableImage
Accessor for the image position
getColumnReference(int) - Static method in class jxl.CellReferenceHelper
Gets the column letter corresponding to the 0-based column number
getColumnView(int) - Method in interface jxl.Sheet
Gets the column width for the specified column
getColumns() - Method in interface jxl.Sheet
Returns the number of columns in this sheet
getContents() - Method in interface jxl.Cell
Quick and dirty function to return the contents of this cell as a string.
getCopies() - Method in class jxl.SheetSettings
Accessor for the number of copies to print
getDate() - Method in interface jxl.DateCell
Gets the date contained in this cell
getDateFormat() - Method in interface jxl.DateCell
Gets the DateFormat used to format the cell.
getDefaultBlue() - Method in class jxl.format.Colour
Gets the default blue content of this colour.
getDefaultColumnWidth() - Method in class jxl.SheetSettings
Accessor for the default column width
getDefaultGreen() - Method in class jxl.format.Colour
Gets the default green content of this colour.
getDefaultHeightMargin() - Method in class jxl.SheetSettings
Gets the default margin height
getDefaultRed() - Method in class jxl.format.Colour
Gets the default red content of this colour.
getDefaultRowHeight() - Method in class jxl.SheetSettings
Accessor for the default row height
getDefaultWidthMargin() - Method in class jxl.SheetSettings
Gets the default margin width
getDescription() - Method in class jxl.format.Alignment
Gets the string description of this alignment
getDescription() - Method in class jxl.format.BoldStyle
Gets the string description of the bold style
getDescription() - Method in class jxl.format.Border
Gets the description
getDescription() - Method in class jxl.format.BorderLineStyle
Gets the textual description
getDescription() - Method in class jxl.format.Colour
Gets the string description for display purposes
getDescription() - Method in class jxl.format.Orientation
Gets the textual description
getDescription() - Method in class jxl.format.Pattern
Gets the textual description
getDescription() - Method in class jxl.format.ScriptStyle
Gets the string description for display purposes
getDescription() - Method in class jxl.format.UnderlineStyle
Gets the string description for display purposes
getDescription() - Method in class jxl.format.VerticalAlignment
Gets the textual description
getDisplayZeroValues() - Method in class jxl.SheetSettings
Accessor for the displayZeroValues property
getDrawingsDisabled() - Method in class jxl.WorkbookSettings
Gets the drawings disabled flag
getEncoding() - Method in class jxl.WorkbookSettings
Accessor for the character encoding
getErrorCode() - Method in interface jxl.ErrorCell
Gets the error code for this cell.
getFile() - Method in interface jxl.Hyperlink
Returns the local file eferenced by this Hyperlink
getFirstSheetIndex() - Method in interface jxl.Range
Gets the index of the first sheet in the range
getFitHeight() - Method in class jxl.SheetSettings
Accessor for the fit height
getFitToPages() - Method in class jxl.SheetSettings
Accessor for the fit width print flag
getFitWidth() - Method in class jxl.SheetSettings
Accessor for the fit width
getFont() - Method in interface jxl.format.CellFormat
Gets the font information used by this format
getFooter() - Method in class jxl.SheetSettings
Accessor for the footer
getFooterMargin() - Method in class jxl.SheetSettings
Accessor for the footer margin
getFormat() - Method in class jxl.CellView
Accessor for the cell format for this group.
getFormat() - Method in interface jxl.format.CellFormat
Gets the format used by this format
getFormatString() - Method in interface jxl.format.Format
Accesses the excel format string which is applied to the cell Note that this is the string that excel uses, and not the java equivalent
getFormula() - Method in interface jxl.FormulaCell
Gets the formula as a string
getFormulaAdjust() - Method in class jxl.WorkbookSettings
Accessor for the formula adjust disabled
getFunctionNames() - Method in class jxl.WorkbookSettings
Gets the function names.
getGCDisabled() - Method in class jxl.WorkbookSettings
Accessor for the disabling of garbage collection
getHeader() - Method in class jxl.SheetSettings
Accessor for the header
getHeaderMargin() - Method in class jxl.SheetSettings
Accessor for the header margin
getHeight() - Method in class jxl.write.WritableImage
Accessor for the image dimensions
getHorizontalFreeze() - Method in class jxl.SheetSettings
Gets the row at which the pane is frozen horizontally
getHorizontalPrintResolution() - Method in class jxl.SheetSettings
Accessor for the horizontal print resolution
getHyperlinks() - Method in interface jxl.Sheet
Gets the hyperlinks on this sheet
getImage(int) - Method in interface jxl.write.WritableSheet
Accessor for the image
getImageData() - Method in class jxl.write.WritableImage
Accessor for the image data
getImageFile() - Method in class jxl.write.WritableImage
Accessor for the image file
getInitialFileSize() - Method in class jxl.WorkbookSettings
Accessor for the initial file size property
getInternalColour(int) - Static method in class jxl.format.Colour
Gets the internal colour from the value
getLastColumn() - Method in interface jxl.Hyperlink
Returns the column number of the bottom right cell
getLastRow() - Method in interface jxl.Hyperlink
Returns the row number of the bottom right cell
getLastSheetIndex() - Method in interface jxl.Range
Gets the index of the last sheet in the range
getLeft() - Method in class jxl.HeaderFooter
Accessor for the contents which appear on the left hand side of the page
getLeftMargin() - Method in class jxl.SheetSettings
Accessor for the left margin
getLocale() - Method in class jxl.WorkbookSettings
Returns the locale used for the spreadsheet
getMergedCells() - Method in interface jxl.Sheet
Gets the cells which have been merged on this sheet
getName() - Method in interface jxl.Sheet
Gets the name of this sheet
getName() - Method in interface jxl.format.Font
Gets the name of this font
getNamesDisabled() - Method in class jxl.WorkbookSettings
Accessor for the disabling of interpretation of named ranges
getNumberFormat() - Method in interface jxl.NumberCell
Gets the NumberFormat used to format this cell.
getNumberOfImages() - Method in interface jxl.write.WritableSheet
Accessor for the number of images on the sheet
getNumberOfSheets() - Method in class jxl.Workbook
Returns the number of sheets in this workbook
getNumberOfSheets() - Method in class jxl.write.WritableWorkbook
Returns the number of sheets in this workbook
getOrientation() - Method in class jxl.SheetSettings
Accessor for the orientation
getOrientation() - Method in interface jxl.format.CellFormat
Gets the orientation
getOrientation(int) - Static method in class jxl.format.Orientation
Gets the alignment from the value
getPageStart() - Method in class jxl.SheetSettings
Accessor for the page start
getPaperSize() - Method in class jxl.SheetSettings
Accessor for the paper size
getPaperSize(int) - Static method in class jxl.format.PaperSize
Gets the paper size for a specific value
getPassword() - Method in class jxl.SheetSettings
Accessor for the password
getPasswordHash() - Method in class jxl.SheetSettings
Accessor for the password hash - used only when copying sheets
getPattern() - Method in interface jxl.format.CellFormat
Gets the pattern used by this cell format
getPattern(int) - Static method in class jxl.format.Pattern
Gets the pattern from the value
getPointSize() - Method in interface jxl.format.Font
Gets the point size for this font, if the font hasn't been initialized
getPrintGridLines() - Method in class jxl.SheetSettings
Accessor for the printGridLines property
getPrintHeaders() - Method in class jxl.SheetSettings
Accessor for the printHeaders property
getPropertySetsDisabled() - Method in class jxl.WorkbookSettings
Accessor to retrieve the property sets disabled flag
getRange() - Method in interface jxl.Hyperlink
Gets the range of cells which activate this hyperlink The get sheet index methods will all return -1, because the cells will all be present on the same sheet
getRangeNames() - Method in class jxl.Workbook
Gets the named ranges
getRangeNames() - Method in class jxl.write.WritableWorkbook
Gets the named ranges
getRationalizationDisabled() - Method in class jxl.WorkbookSettings
Accessor to retrieve the rationalization flag
getRight() - Method in class jxl.HeaderFooter
Accessor for the contents which appear on the right hand side of the page
getRightMargin() - Method in class jxl.SheetSettings
Accessor for the right margin
getRow() - Method in interface jxl.Cell
Returns the row number of this cell
getRow(String) - Static method in class jxl.CellReferenceHelper
Gets the row number of the cell reference
getRow() - Method in interface jxl.Hyperlink
Returns the row number of this cell
getRow(int) - Method in interface jxl.Sheet
Gets all the cells on the specified row
getRow() - Method in class jxl.write.WritableImage
Accessor for the image position
getRowView(int) - Method in interface jxl.Sheet
Gets the column width for the specified column
getRows() - Method in interface jxl.Sheet
Returns the number of rows in this sheet
getScaleFactor() - Method in class jxl.SheetSettings
Accessor for the scale factor
getScriptStyle() - Method in interface jxl.format.Font
Gets the script style
getSettings() - Method in interface jxl.Sheet
Gets the settings used on a particular sheet
getSheet(int) - Method in class jxl.Workbook
Gets the specified sheet within this workbook As described in the accompanying technical notes, each call to getSheet forces a reread of the sheet (for memory reasons).
getSheet(String) - Method in class jxl.Workbook
Gets the sheet with the specified name from within this workbook.
getSheet(int) - Method in class jxl.write.WritableWorkbook
Gets the specified sheet within this workbook
getSheet(String) - Method in class jxl.write.WritableWorkbook
Gets the sheet with the specified name from within this workbook
getSheetNames() - Method in class jxl.Workbook
Gets the sheet names
getSheetNames() - Method in class jxl.write.WritableWorkbook
Gets the sheet names
getSheets() - Method in class jxl.Workbook
Gets the sheets within this workbook.
getSheets() - Method in class jxl.write.WritableWorkbook
Gets the sheets within this workbook.
getShowGridLines() - Method in class jxl.SheetSettings
Accessor for the showGridLines property
getSize() - Method in class jxl.CellView
Gets the width of the column in characters multiplied by 256, or the height of the row in 1/20ths of a point
getString() - Method in interface jxl.LabelCell
Gets the label for this cell.
getStyle(int) - Static method in class jxl.format.BorderLineStyle
Gets the alignment from the value
getStyle(int) - Static method in class jxl.format.ScriptStyle
Gets the ScriptStyle from the value
getStyle(int) - Static method in class jxl.format.UnderlineStyle
Gets the UnderlineStyle from the value
getTopLeft() - Method in interface jxl.Range
Gets the cell at the top left of this range
getTopMargin() - Method in class jxl.SheetSettings
Accessor for the top margin
getType() - Method in interface jxl.Cell
Returns the content type of this cell
getURL() - Method in interface jxl.Hyperlink
Gets the URL referenced by this Hyperlink
getUnderlineStyle() - Method in interface jxl.format.Font
Gets the underline style for this font
getValue() - Method in interface jxl.BooleanCell
Gets the boolean value stored in this cell.
getValue() - Method in interface jxl.NumberCell
Gets the double contents for this cell.
getValue() - Method in class jxl.format.Alignment
Gets the value of this alignment.
getValue() - Method in class jxl.format.BoldStyle
Gets the value of the bold weight.
getValue() - Method in class jxl.format.BorderLineStyle
Gets the value for this line style
getValue() - Method in class jxl.format.Colour
Gets the value of this colour.
getValue() - Method in class jxl.format.Orientation
Accessor for the binary value
getValue() - Method in class jxl.format.PaperSize
Accessor for the internal binary value association with this paper size
getValue() - Method in class jxl.format.Pattern
Gets the value of this pattern.
getValue() - Method in class jxl.format.ScriptStyle
Gets the value of this style.
getValue() - Method in class jxl.format.UnderlineStyle
Gets the value of this style.
getValue() - Method in class jxl.format.VerticalAlignment
Accessor for the binary value
getVersion() - Static method in class jxl.Workbook
Accessor for the software version
getVerticalAlignment() - Method in interface jxl.format.CellFormat
Gets the vertical cell alignment
getVerticalFreeze() - Method in class jxl.SheetSettings
Gets the column at which the pane is frozen vertically
getVerticalPrintResolution() - Method in class jxl.SheetSettings
Accessor for the vertical print resolution
getWidth() - Method in class jxl.write.WritableImage
Accessor for the image dimensions
getWorkbook(File) - Static method in class jxl.Workbook
A factory method which takes in an excel file and reads in the contents.
getWorkbook(File, WorkbookSettings) - Static method in class jxl.Workbook
A factory method which takes in an excel file and reads in the contents.
getWorkbook(InputStream) - Static method in class jxl.Workbook
A factory method which takes in an excel file and reads in the contents.
getWorkbook(InputStream, WorkbookSettings) - Static method in class jxl.Workbook
A factory method which takes in an excel file and reads in the contents.
getWrap() - Method in interface jxl.format.CellFormat
Gets whether or not the contents of this cell are wrapped
getWritableCell(int, int) - Method in interface jxl.write.WritableSheet
Gets the writable cell from this sheet.
getWritableHyperlinks() - Method in interface jxl.write.WritableSheet
Gets the writable hyperlinks from this sheet.
getZoomFactor() - Method in class jxl.SheetSettings
Accessor for the zoom factor.

H

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

I

ICE_BLUE - Static variable in class jxl.format.Colour
 
INDIGO - Static variable in class jxl.format.Colour
 
INTEGER - Static variable in class jxl.write.NumberFormats
Formatting for an integer number.
IVORY - Static variable in class jxl.format.Colour
 
insertColumn(int) - Method in interface jxl.write.WritableSheet
Inserts a blank column into this spreadsheet.
insertRow(int) - Method in interface jxl.write.WritableSheet
Inserts a blank row into this spreadsheet.
isColumnRelative(String) - Static method in class jxl.CellReferenceHelper
Sees if the column component is relative or not
isFile() - Method in interface jxl.Hyperlink
Determines whether this is a hyperlink to a file
isHidden() - Method in interface jxl.Cell
Indicates whether or not this cell is hidden, by virtue of either the entire row or column being collapsed
isHidden() - Method in class jxl.CellView
Accessor for the hidden nature of this row/column
isHidden() - Method in class jxl.SheetSettings
Accessor for the hidden nature of this sheet
isItalic() - Method in interface jxl.format.Font
Returns the italic flag
isLocation() - Method in interface jxl.Hyperlink
Determines whether this is a hyperlink to a location in this workbook
isLocked() - Method in interface jxl.format.CellFormat
Accessor for whether a particular cell is locked
isProtected() - Method in class jxl.SheetSettings
Queries whether this sheet is protected (ie.
isProtected() - Method in class jxl.Workbook
Determines whether the sheet is protected
isRowRelative(String) - Static method in class jxl.CellReferenceHelper
Sees if the row component is relative or not
isSelected() - Method in class jxl.SheetSettings
Accessor for the selected nature of the sheet
isShrinkToFit() - Method in interface jxl.format.CellFormat
Gets the shrink to fit flag
isTime() - Method in interface jxl.DateCell
Indicates whether the date value contained in this cell refers to a date, or merely a time
isURL() - Method in interface jxl.Hyperlink
Determines whether this is a hyperlink to a web resource

J

JUSTIFY - Static variable in class jxl.format.Alignment
Data in cells with this alignment will be justified
JUSTIFY - Static variable in class jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data justified
JXLException - exception jxl.JXLException.
Base exception class for JExcelAPI exceptions
jxl - package jxl
 
jxl.demo - package jxl.demo
 
jxl.format - package jxl.format
 
jxl.write - package jxl.write
 

L

LABEL - Static variable in class jxl.CellType
 
LANDSCAPE - Static variable in class jxl.format.PageOrientation
Landscape orientation
LAVENDER - Static variable in class jxl.format.Colour
 
LEFT - Static variable in class jxl.format.Alignment
Data cells with this alignment will appear at the left hand edge of the cell
LEFT - Static variable in class jxl.format.Border
 
LEGAL - Static variable in class jxl.format.PaperSize
US Legal
LETTER - Static variable in class jxl.format.PaperSize
US Letter
LIGHT_BLUE - Static variable in class jxl.format.Colour
 
LIGHT_GREEN - Static variable in class jxl.format.Colour
 
LIGHT_ORANGE - Static variable in class jxl.format.Colour
 
LIGHT_TURQUOISE - Static variable in class jxl.format.Colour
 
LIGHT_TURQUOISE2 - Static variable in class jxl.format.Colour
 
LIME - Static variable in class jxl.format.Colour
 
Label - class jxl.write.Label.
A cell containing text which may be created by user applications
Label(int, int, String) - Constructor for class jxl.write.Label
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates and will contain the specified text
Label(int, int, String, CellFormat) - Constructor for class jxl.write.Label
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates and will present the specified text in the manner specified by the CellFormat parameter
Label(LabelCell) - Constructor for class jxl.write.Label
Constructor used internally by the application when making a writable copy of a spreadsheet being read in
LabelCell - interface jxl.LabelCell.
A label cell

M

MEDIUM - Static variable in class jxl.format.BorderLineStyle
 
MEDIUM_DASHED - Static variable in class jxl.format.BorderLineStyle
 
MEDIUM_DASH_DOT - Static variable in class jxl.format.BorderLineStyle
 
MEDIUM_DASH_DOT_DOT - Static variable in class jxl.format.BorderLineStyle
 
MINUS_90 - Static variable in class jxl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation of 90 degrees downwardswards
main(String[]) - Static method in class jxl.demo.Demo
The main method.
mergeCells(int, int, int, int) - Method in interface jxl.write.WritableSheet
Merges the specified cells.
moveSheet(int, int) - Method in class jxl.write.WritableWorkbook
Moves the specified sheet within this workbook to another index position.

N

NONE - Static variable in class jxl.format.Border
 
NONE - Static variable in class jxl.format.BorderLineStyle
 
NONE - Static variable in class jxl.format.Pattern
 
NORMAL - Static variable in class jxl.format.BoldStyle
Normal style
NORMAL_SCRIPT - Static variable in class jxl.format.ScriptStyle
 
NORMAL_STYLE - Static variable in class jxl.write.WritableWorkbook
The default style for cells
NO_BOLD - Static variable in class jxl.write.WritableFont
Indicates that this font should not be presented as bold
NO_UNDERLINE - Static variable in class jxl.format.UnderlineStyle
 
NUMBER - Static variable in class jxl.CellType
 
NUMBER_FORMULA - Static variable in class jxl.CellType
 
Number - class jxl.write.Number.
A cell, created by user applications, which contains a numerical value
Number(int, int, double) - Constructor for class jxl.write.Number
Constructs a number, which, when added to a spreadsheet, will display the specified value at the column/row position indicated.
Number(int, int, double, CellFormat) - Constructor for class jxl.write.Number
Constructs a number, which, when added to a spreadsheet, will display the specified value at the column/row position with the specified CellFormat.
Number(NumberCell) - Constructor for class jxl.write.Number
Constructor used internally by the application when making a writable copy of a spreadsheet that has been read in
NumberCell - interface jxl.NumberCell.
A cell which contains a numerical value
NumberFormat - class jxl.write.NumberFormat.
A custom user defined number format, which may be instantiated within user applications in order to present numerical values to the appropriate level of accuracy.
NumberFormat(String) - Constructor for class jxl.write.NumberFormat
Constructor, taking in the Java compliant number format
NumberFormats - class jxl.write.NumberFormats.
Static class which contains the available list of built in Number formats
NumberFormats() - Constructor for class jxl.write.NumberFormats
 
NumberFormulaCell - interface jxl.NumberFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers

O

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

P

PALETTE_BLACK - Static variable in class jxl.format.Colour
 
PALE_BLUE - Static variable in class jxl.format.Colour
 
PERCENT_FLOAT - Static variable in class jxl.write.NumberFormats
Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"
PERCENT_INTEGER - Static variable in class jxl.write.NumberFormats
Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"
PERIWINKLE - Static variable in class jxl.format.Colour
 
PINK - Static variable in class jxl.format.Colour
 
PINK2 - Static variable in class jxl.format.Colour
 
PLUM - Static variable in class jxl.format.Colour
 
PLUM2 - Static variable in class jxl.format.Colour
 
PLUS_90 - Static variable in class jxl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation of 90 degrees upwards
PORTRAIT - Static variable in class jxl.format.PageOrientation
Portrait orientation
PageOrientation - class jxl.format.PageOrientation.
Enumeration type which describes the page orientation
PaperSize - class jxl.format.PaperSize.
Enumeration type which contains the available excel paper sizes and their codes
Pattern - class jxl.format.Pattern.
Enumeration class which contains the various patterns available within the standard Excel pattern palette

R

RED - Static variable in class jxl.format.Colour
 
RIGHT - Static variable in class jxl.format.Alignment
Data in cells with this alignment will be right aligned
RIGHT - Static variable in class jxl.format.Border
 
ROSE - Static variable in class jxl.format.Colour
 
Range - interface jxl.Range.
Represents a 3-D range of cells in a workbook.
ReadWrite - class jxl.demo.ReadWrite.
Demo class which uses the api to read in a spreadsheet and generate a clone of that spreadsheet which contains the same data.
ReadWrite(String, String) - Constructor for class jxl.demo.ReadWrite
Constructor
readWrite() - Method in class jxl.demo.ReadWrite
Reads in the inputFile and creates a writable copy of it called outputFile
removeColumn(int) - Method in interface jxl.write.WritableSheet
Removes a column from this spreadsheet.
removeHyperlink(WritableHyperlink) - Method in interface jxl.write.WritableSheet
Removes the specified hyperlink.
removeHyperlink(WritableHyperlink, boolean) - Method in interface jxl.write.WritableSheet
Removes the specified hyperlink.
removeImage(WritableImage) - Method in interface jxl.write.WritableSheet
Removes the specified image from the sheet.
removeRow(int) - Method in interface jxl.write.WritableSheet
Removes a row from this spreadsheet.
removeSheet(int) - Method in class jxl.write.WritableWorkbook
Removes the sheet at the specified index from this workbook

S

SEA_GREEN - Static variable in class jxl.format.Colour
 
SINGLE - Static variable in class jxl.format.UnderlineStyle
 
SINGLE_ACCOUNTING - Static variable in class jxl.format.UnderlineStyle
 
SKY_BLUE - Static variable in class jxl.format.Colour
 
SLANTED_DASH_DOT - Static variable in class jxl.format.BorderLineStyle
 
SOLID - Static variable in class jxl.format.Pattern
 
STRING_FORMULA - Static variable in class jxl.CellType
 
SUBSCRIPT - Static variable in class jxl.format.ScriptStyle
 
SUPERSCRIPT - Static variable in class jxl.format.ScriptStyle
 
ScriptStyle - class jxl.format.ScriptStyle.
Enumeration class which contains the various script styles available within the standard Excel ScriptStyle palette
Sheet - interface jxl.Sheet.
Represents a sheet within a workbook.
SheetSettings - class jxl.SheetSettings.
This is a bean which client applications may use to get/set various properties which are associated with a particular worksheet, such as headers and footers, page orientation etc.
SheetSettings() - Constructor for class jxl.SheetSettings
Default constructor
SheetSettings(SheetSettings) - Constructor for class jxl.SheetSettings
Copy constructor.
StringFormulaCell - interface jxl.StringFormulaCell.
A mixin interface for numerical formulas, which combines the interfaces for formulas and for strings
setAlignment(Alignment) - Method in class jxl.write.WritableCellFormat
Sets the horizontal alignment for this format
setArrayGrowSize(int) - Method in class jxl.WorkbookSettings
Sets the amount of memory by which to increase the amount of memory allocated to storing the workbook data.
setBackground(Colour) - Method in class jxl.write.WritableCellFormat
Sets the background colour for this cell format
setBackground(Colour, Pattern) - Method in class jxl.write.WritableCellFormat
Sets the background colour and pattern for this cell format
setBoldStyle(WritableFont.BoldStyle) - Method in class jxl.write.WritableFont
Sets the bold style for this font, if the font hasn't been initialized
setBorder(Border, BorderLineStyle) - Method in class jxl.write.WritableCellFormat
Sets the specified border for this format
setBorder(Border, BorderLineStyle, Colour) - Method in class jxl.write.WritableCellFormat
Sets the specified border for this format
setBottomMargin(double) - Method in class jxl.SheetSettings
Sets the bottom margin
setCellFormat(CellFormat) - Method in interface jxl.write.WritableCell
Sets the cell format for this cell
setCharacterSet(int) - Method in class jxl.WorkbookSettings
Sets the character set.
setColour(Colour) - Method in class jxl.write.WritableFont
Sets the colour for this font, if the font hasn't been initialized
setColourRGB(Colour, int, int, int) - Method in class jxl.write.WritableWorkbook
Sets the RGB value for the specified colour for this workbook
setColumn(double) - Method in class jxl.write.WritableImage
Accessor for the image position
setColumnView(int, int) - Method in interface jxl.write.WritableSheet
Sets the width of the column on this sheet, in characters.
setColumnView(int, CellView) - Method in interface jxl.write.WritableSheet
Sets the view for this column
setCopies(int) - Method in class jxl.SheetSettings
Sets the number of copies
setDate(Date) - Method in class jxl.write.DateTime
Sets the date for this cell
setDate(Date, DateRecord.GMTDate) - Method in class jxl.write.DateTime
Sets the date for this cell, performing the necessary timezone adjustments
setDefaultColumnWidth(int) - Method in class jxl.SheetSettings
Sets the default column width
setDefaultRowHeight(int) - Method in class jxl.SheetSettings
Sets the default row height
setDisplayZeroValues(boolean) - Method in class jxl.SheetSettings
Sets the displayZeroValues property
setDrawingsDisabled(boolean) - Method in class jxl.WorkbookSettings
Disables the handling of drawings
setEncoding(String) - Method in class jxl.WorkbookSettings
Sets the encoding for this workbook
setFile(File) - Method in class jxl.write.WritableHyperlink
Sets the file activated by this hyperlink
setFitHeight(int) - Method in class jxl.SheetSettings
Sets the number of pages vertically that this sheet will be printed into
setFitToPages(boolean) - Method in class jxl.SheetSettings
Accessor for the fit to pages flag
setFitWidth(int) - Method in class jxl.SheetSettings
Sets the number of pages widthwise which this sheet should be printed into
setFontName(String) - Method in class jxl.HeaderFooter.Contents
Sets the font of text subsequently appended to this object..
setFontSize(int) - Method in class jxl.HeaderFooter.Contents
Sets the font size of text subsequently appended to this object.
setFooter(HeaderFooter) - Method in class jxl.SheetSettings
Sets the footer
setFooterMargin(double) - Method in class jxl.SheetSettings
Sets the margin for any page footer
setFormat(CellFormat) - Method in class jxl.CellView
Sets the cell format for this group of cells
setFormulaAdjust(boolean) - Method in class jxl.WorkbookSettings
Setter for the formula adjust disabled property
setGCDisabled(boolean) - Method in class jxl.WorkbookSettings
Sets the garbage collection disabled
setHeader(HeaderFooter) - Method in class jxl.SheetSettings
Sets the header
setHeaderMargin(double) - Method in class jxl.SheetSettings
Sets the margin for any page headers
setHeight(double) - Method in class jxl.write.WritableImage
Accessor for the image dimensions Note that the actual size of the rendered image will depend on the height of the rows it spans
setHidden(boolean) - Method in class jxl.CellView
Sets the hidden status of this row/column
setHidden(boolean) - Method in class jxl.SheetSettings
Sets the hidden status of this worksheet
setHorizontalFreeze(int) - Method in class jxl.SheetSettings
Sets the row at which the pane is frozen horizontally
setHorizontalPrintResolution(int) - Method in class jxl.SheetSettings
Sets the horizontal print resolution
setInitialFileSize(int) - Method in class jxl.WorkbookSettings
Sets the initial amount of memory allocated to store the workbook data when reading a worksheet.
setItalic(boolean) - Method in class jxl.write.WritableFont
Sets the italic indicator for this font, if the font hasn't been initialized
setLeftMargin(double) - Method in class jxl.SheetSettings
Sets the left margin
setLocale(Locale) - Method in class jxl.WorkbookSettings
Sets the locale for this spreadsheet
setLocation(String, WritableSheet, int, int, int, int) - Method in class jxl.write.WritableHyperlink
Sets the location of the cells to be linked to within this workbook
setLocked(boolean) - Method in class jxl.write.WritableCellFormat
Sets whether or not this XF record locks the cell.
setName(String) - Method in interface jxl.write.WritableSheet
Sets the name of this sheet
setNamesDisabled(boolean) - Method in class jxl.WorkbookSettings
Disables the handling of names
setOrientation(PageOrientation) - Method in class jxl.SheetSettings
Sets the paper orientation for printing this sheet
setOrientation(Orientation) - Method in class jxl.write.WritableCellFormat
Sets the text orientation for this format
setPageSetup(PageOrientation) - Method in interface jxl.write.WritableSheet
Sets the page setup details
setPageSetup(PageOrientation, double, double) - Method in interface jxl.write.WritableSheet
Sets the page setup details
setPageSetup(PageOrientation, PaperSize, double, double) - Method in interface jxl.write.WritableSheet
Sets the page setup details
setPageStart(int) - Method in class jxl.SheetSettings
Sets the page number at which to commence printing
setPaperSize(PaperSize) - Method in class jxl.SheetSettings
Sets the paper size to be used when printing this sheet
setPassword(String) - Method in class jxl.SheetSettings
Sets the password for this sheet
setPasswordHash(int) - Method in class jxl.SheetSettings
Accessor for the password hash - used only when copying sheets
setPointSize(int) - Method in class jxl.write.WritableFont
Sets the point size for this font, if the font hasn't been initialized
setPrintGridLines(boolean) - Method in class jxl.SheetSettings
Sets the printGridLines property
setPrintHeaders(boolean) - Method in class jxl.SheetSettings
Sets the printHeaders property
setPropertySets(boolean) - Method in class jxl.WorkbookSettings
Sets whether or not to enable any property sets (such as macros) to be copied along with the workbook Leaving this feature enabled will result in the JXL process using more memory
setProtected(boolean) - Method in class jxl.SheetSettings
Sets the protected (ie.
setProtected(boolean) - Method in class jxl.write.WritableWorkbook
Indicates whether or not this workbook is protected
setRationalization(boolean) - Method in class jxl.WorkbookSettings
Sets whether or not to rationalize the cell formats before writing out the sheet.
setRightMargin(double) - Method in class jxl.SheetSettings
Sets the right margin
setRow(double) - Method in class jxl.write.WritableImage
Accessor for the image position
setRowView(int, int) - Method in interface jxl.write.WritableSheet
Sets the height of the specified row, as well as its collapse status
setRowView(int, boolean) - Method in interface jxl.write.WritableSheet
Sets the properties of the specified row
setRowView(int, int, boolean) - Method in interface jxl.write.WritableSheet
Sets the height of the specified row, as well as its collapse status
setScaleFactor(int) - Method in class jxl.SheetSettings
Sets the scale factor for this sheet to be used when printing.
setScriptStyle(ScriptStyle) - Method in class jxl.write.WritableFont
Sets the script style (eg.
setSelected() - Method in class jxl.SheetSettings
Sets this sheet to be when it is opened in excel
setShowGridLines(boolean) - Method in class jxl.SheetSettings
Sets the showGridLines property
setShrinkToFit(boolean) - Method in class jxl.write.WritableCellFormat
Sets the shrink to fit flag
setSize(int) - Method in class jxl.CellView
Sets the dimension for this view
setString(String) - Method in class jxl.write.Label
Sets the string contents of this cell
setSuppressWarnings(boolean) - Method in class jxl.WorkbookSettings
Accessor to set the suppress warnings flag.
setTopMargin(double) - Method in class jxl.SheetSettings
Sets the top margin
setURL(URL) - Method in class jxl.write.WritableHyperlink
Sets the URL of this hyperlink
setUnderlineStyle(UnderlineStyle) - Method in class jxl.write.WritableFont
Sets the underline style for this font, if the font hasn't been initialized
setValue(boolean) - Method in class jxl.write.Boolean
Sets the boolean value for this cell
setValue(double) - Method in class jxl.write.Number
Sets the numerical value for this cell
setVerticalAlignment(VerticalAlignment) - Method in class jxl.write.WritableCellFormat
Sets the vertical alignment for this format
setVerticalFreeze(int) - Method in class jxl.SheetSettings
Sets the row at which the pane is frozen vertically
setVerticalPrintResolution(int) - Method in class jxl.SheetSettings
Sets the vertical print reslution
setWidth(double) - Method in class jxl.write.WritableImage
Accessor for the image dimensions Note that the actual size of the rendered image will depend on the width of the columns it spans
setWrap(boolean) - Method in class jxl.write.WritableCellFormat
Sets the wrap indicator for this format.
setZoomFactor(int) - Method in class jxl.SheetSettings
Sets the zoom factor.

T

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

U

UNKNOWN - Static variable in class jxl.format.Colour
 
UnderlineStyle - class jxl.format.UnderlineStyle.
Enumeration class which contains the various underline styles available within the standard Excel UnderlineStyle palette
unmergeCells(Range) - Method in interface jxl.write.WritableSheet
Unmerges the specified cells.

V

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

W

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

X

XML - class jxl.demo.XML.
Simple demo class which uses the api to present the contents of an excel 97 spreadsheet as an XML document, using a workbook and output stream of your choice
XML(Workbook, OutputStream, String, boolean) - Constructor for class jxl.demo.XML
Constructor

Y

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

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