Represents an individual Cell within a Sheet.
Container for any additional cell features
Interface for cell formats - used for typing information
Interface for cell formats
Exposes some cell reference helper methods to the public interface.
An enumeration type listing the available content types for a cell
This is a bean which client applications may use to get/set various
properties for a row or column on a spreadsheet
Data in cells with this alignment will be centred
Cells with this specified vertical alignment will have their data
aligned centrally
Clears the contents of the header/footer
Clears the contents of this portion
Closes this workbook, and frees makes any memory allocated available
for garbage collection
Closes this workbook, and makes any memory allocated available
for garbage collection.
Enumeration class which contains the various colours available within
the standard Excel colour palette
Enumeration class which contains the various colours available within
the standard Excel colour palette
Pass in to the constructor to bypass the format validation
The contents - a simple wrapper around a string buffer
This method can be used to create a writable clone of some other
workbook
Copy sheet within the same workbook.
Copies the specified sheet and places it at the index
specified by the parameter
Implementation of the deep copy function
Implementation of the deep copy function
Implementation of the deep copy function
Implementation of the deep copy function
Implementation of the deep copy function
Implementation of the deep copy function
Objects created with this font name will be rendered within Excel as
COURIER fonts
Factory method which creates the specified font name.
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.
Creates a writable workbook with the given file name
Creates a writable workbook with the given filename as a copy of
the workbook passed in.
Creates a writable workbook with the given filename as a copy of
the workbook passed in.
Creates a writable workbook with the given file name
Creates a writable workbook.
Creates a writable workbook as a copy of
the workbook passed in.
Creates a writable workbook as a copy of
the workbook passed in.
Creates a writable workbook.
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
Constant format string for the US Dollar sign
Constant format string for the Euro currency symbol where it precedes
the format
Constant format string for the Euro currency symbol where it precedes
the format
Constant format string for the Japanese Yen sign
Constant format string for the UK pound sign
Goes through each cell in the workbook, and if the cell has any features
associated with, it prints out the cell contents and the features
Data in cells with this alignment will fill the cell
Gets the named range from this workbook.
Gets the named range from this workbook.
Gets the cell whose contents match the string passed in.
Gets the named cell from this workbook.
Gets the named cell from this workbook.
Gets the cell whose contents match the string passed in.
Interface which exposes the user font display information to the user
A class which is instantiated when the user application wishes to specify
the font for a particular cell
Creates a default font, vanilla font of the specified face and with
default point size.
Constructs of font of the specified face and of size given by the
specified point size
Creates a font of the specified face, point size and bold style
Creates a font of the specified face, point size, bold weight and
italicised option.
Creates a font of the specified face, point size, bold weight,
italicisation and underline style
Creates a font of the specified face, point size, bold style,
italicisation, underline style and colour
Creates a font of the specified face, point size, bold style,
italicisation, underline style, colour, and script
style (superscript/subscript)
Static inner class used for classifying the font names
Exposes the cell formatting information
Equivalent to a DecimalFormat "#,##0;(#,##0)"
Equivalent to a date format of "mm:ss"
Equivalent to DecimalFormat "##0.0E0"
Equivalent to a date format of "H:mm:ss"
Equivalent to a date format of "mm:ss.S"
Equivalent to a date format of "d-MMM-yy"
Equivalent to FORMAT1 except deficits are coloured red
Equivalent to a date format of "d-MMM"
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
Equivalent to a date format of "MMM-yy"
Equivalent to FORMAT3 except deficits are coloured red
Equivalent to a date format of "h:mm a"
Equivalent to DecimalFormat "#,##0;(#,##0)"
Equivalent to a date format of "h:mm:ss a"
Equivalent to FORMAT5 except deficits are coloured red
Equivalent to a date format of "H:mm"
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
Equivalent to a date format of "H:mm:ss"
Equivalent to FORMAT7 except deficits are coloured red
Equivalent to a date format of "M/d/yy H:mm"
A cell, created by user applications, which contains a numerical value
Interface for formulas which allow clients to read the Excel formula
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
Constant format string for fractions as halves
Constant format string for fractions as hundredths
Formatting for one digit fractions
Constant format string for fractions as quarter
Constant format string for fractions as sixteenths
Constant format string for fractions as tenths
Constant format string for three digit fractions
Formatting for two digit fractions
Constant format string for fractions as eighths
German Legal Fanfold 8.5" ? 13"
Gets the horizontal cell alignment
Gets the alignment from the value
Gets the alignment from the value
Returns all available colours - used when generating the default palette
Accessor for the array grow size property
Accessor for the autofilter disabled feature
Retrieves the automatic formula calculation flag
Gets the background colour used by this cell
Accessor for the blue component
Gets the bold weight for this font
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
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
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
Accessor for the bottom margin
Gets the cell at the bottom right of this range
Returns the cell specified at this row and at this column.
Returns the cell for the specified location eg.
Returns the cell for the specified location eg.
Gets any special cell features, such as comments (notes) or cell
validation present for this 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.
Overloaded method which prepends $ for absolute reference
Gets the cell reference for the specified column and row
Gets the fully qualified cell reference given the column, row
external sheet reference etc
Gets the fully qualified cell reference given the column, row
external sheet reference etc
Gets the fully qualified cell reference given the column, row
external sheet reference etc
Gets the fully qualified cell reference given the column, row
external sheet reference etc
Gets the fully qualified cell reference given the column, row
external sheet reference etc
Appends the cell reference for the column and row passed in to the string
buffer
Accessor for the ignore cell validation
Accessor for the contents which in the centre of the page
Accessor for the character set.
Gets the colour for this font
Returns the column number of this cell
Returns the column number of this cell
Accessor for the image position
Accessor for the image position
Gets all the cells on the specified column
Gets the columnn number of the string cell reference
Gets the column format for the specified column
Accessor for the page breaks on this sheet
Gets the column letter corresponding to the 0-based column number
Returns the number of columns in this sheet
Gets the column width for the specified column
Gets the column width for the specified column
Accessor for the cell comment
Quick and dirty function to return the contents of this cell as a string.
Accessor for the number of copies to print
Gets the data validation list
Gets the date contained in this cell
Gets the DateFormat used to format the cell.
Gets the default blue content of this colour.
Accessor for the default column width
Gets the default green content of this colour.
Gets the default margin height
Gets the default red content of this colour.
Returns the default RGB of the colour
Accessor for the default row height
Gets the default margin width
Gets the string description of this alignment
Gets the string description of the bold style
Gets the textual description
Gets the string description for display purposes
Gets the textual description
Gets the textual description
Gets the string description for display purposes
Gets the string description for display purposes
Gets the textual description
Gets the width of the column in characters or the height of the
row in 1/20ths
Accessor for the displayZeroValues property
Gets the drawings disabled flag
Accessor for the character encoding
Gets the error code for this cell.
Returns the two character ISO 3166 mnemonic used by excel for user
language displayto display
Returns the two character ISO 3166 mnemonic used by excel for
its regional settings
Returns the local file eferenced by this Hyperlink
Gets the index of the first sheet in the range
Accessor for the fit height
Accessor for the fit width print flag
Accessor for the fit width
Gets the font information used by this format
Accessor for the footer margin
Gets the format used by this format
Accessor for the cell format for this group.
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
Gets the formula as a string
Accessor for the formula adjust disabled
Accessor for the disabling of garbage collection
Accessor for the green component
Accessor for the header margin
Accessor for the image dimensions
Accessor for the image dimensions
Get the height of this image as rendered within Excel
Gets the row at which the pane is frozen horizontally
Accessor for the horizontal print resolution
Gets the horizontal resolution of the image, if that information
is available.
Gets the hyperlinks on this sheet
Accessor for the ignore blanks flag
Accessor for the anchor properties
Accessor for the image data
Accessor for the image data
Accessor for the image file
Accessor for the image file
Gets the height of the image.
Gets the width of the image.
Gets the indentation of the cell text
Accessor for the initial file size property
Gets the internal colour from the value
Returns the column number of the bottom right cell
Returns the row number of the bottom right cell
Gets the index of the last sheet in the range
Accessor for the contents which appear on the left hand side of the page
Accessor for the left margin
Returns the locale used by JExcelAPI to read the spreadsheet
Accessor to retrieve the merged cell checking flag
Gets the cells which have been merged on this sheet
Gets the name of this font
Gets the name of this sheet
Accessor for the disabling of interpretation of named ranges
Accessor for the nomral view magnificaton factor.
Gets the NumberFormat used to format this cell.
Accessor for the number of images on the sheet
Accessor for the number of images on the sheet
Returns the number of sheets in this workbook
Returns the number of sheets in this workbook
Accessor for the orientation
Gets the alignment from the value
Accessor for the page break preview mangificaton factor.
Accessor for the pageBreakPreview mode
Accessor for the page start
Accessor for the paper size
Gets the paper size for a specific value
Accessor for the password
Accessor for the password hash - used only when copying sheets
Gets the pattern used by this cell format
Gets the pattern from the value
Gets the point size for this font, if the font hasn't been initialized
Accessor for the print area
Accessor for the printGridLines property
Accessor for the printHeaders property
Accessor for the print column titles
Accessor for the print row titles
Accessor to retrieve the property sets disabled flag
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
Accessor to retrieve the rationalization flag
Retrieves the recalculate formulas before save flag
Accessor for the red component
Accessor for the contents which appear on the right hand side of the page
Accessor for the right margin
Returns the row number of this cell
Returns the row number of this cell
Accessor for the image position
Accessor for the image position
Gets all the cells on the specified row
Gets the row number of the cell reference
Gets the row height for the specified column
Accessor for the page breaks on this sheet
Returns the number of rows in this sheet
Gets the row height for the specified column
Accessor for the scale factor
Gets the settings used on a particular sheet
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).
Gets the specified sheet within this workbook
Gets the sheet name from the cell reference string
Gets the sheet with the specified name from within this workbook.
Gets the sheet with the specified name from within this workbook
Gets the sheets within this workbook.
Gets the sheets within this workbook.
Accessor for the showGridLines property
Gets the width of the column in characters multiplied by 256, or the
height of the row in 1/20ths of a point
Gets the label for this cell.
Gets the alignment from the value
Gets the ScriptStyle from the value
Gets the UnderlineStyle from the value
Used in conjunction with the UseTemporaryFileDuringWrite setting to
set the target directory for the temporary files.
Gets the cell at the top left of this range
Accessor for the top margin
Returns the content type of this cell
Gets the underline style for this font
Gets the URL referenced by this Hyperlink
Accessor for the temporary file during write.
Gets the value of this alignment.
Gets the value of the bold weight.
Gets the boolean value stored in this cell.
Gets the value for this line style
Gets the value of this colour.
Gets the double contents for this cell.
Accessor for the binary value
Accessor for the internal binary value association with this paper size
Gets the value of this pattern.
Gets the value of this style.
Gets the value of this style.
Accessor for the binary value
Accessor for the software version
Gets the vertical cell alignment
Gets the column at which the pane is frozen vertically
Accessor for the vertical print resolution
Gets the vertical resolution of the image, if that information
is available.
Accessor for the image dimensions
Accessor for the image dimensions
Get the width of this image as rendered within Excel
A factory method which takes in an excel file and reads in the contents.
A factory method which takes in an excel file and reads in the contents.
A factory method which takes in an excel file and reads in the contents.
A factory method which takes in an excel file and reads in the contents.
Gets whether or not the contents of this cell are wrapped
Gets the writable cell from this sheet.
Returns the cell for the specified location eg.
Returns the cell for the specified location eg.
Accessor for the cell features
Gets the writable hyperlinks from this sheet.
Accessor for the zoom factor.
Instance variable for dummy variable overload
Enumeration class which contains the various script styles available
within the standard Excel ScriptStyle palette
Sets the horizontal alignment for this format
Sets the amount of memory by which to increase the amount of
memory allocated to storing the workbook data.
Sets the autofilter disabled
Sets the automatic formula calculation flag
Sets the background colour for this cell format
Sets the background colour and pattern for this cell format
Sets the bold style for this font, if the font hasn't been initialized
Sets the specified border for this format
Sets the specified border for this format
Sets the cell format for this cell
Sets the ignore cell validation flag
Sets the colour for this font, if the font hasn't been
initialized
Sets the RGB value for the specified colour for this workbook
Accessor for the image position
Sets the width of the column on this sheet, in characters.
Sets the width and style of every cell in the specified column.
Sets the view for this column
Sets the cell comment and sets the size of the text box (in cells)
in which the comment is displayed
Sets the number of copies
The list of items to validate for this cell.
The list of items to validate for this cell in the form of a cell range.
Sets the data validation based upon a named range
Sets the date for this cell
Sets the date for this cell, performing the necessary timezone adjustments
Sets the default column width
Sets the default row height
Sets the description to appear in the hyperlink cell
Sets the dimension for this view
Sets the displayZeroValues property
Disables the handling of drawings
Sets the encoding for this workbook
Sets the language in which the generated file will display
Sets the regional settings for the generated excel file
Sets the file activated by this hyperlink
Sets the number of pages vertically that this sheet will be printed into
Accessor for the fit to pages flag
Sets the number of pages widthwise which this sheet should be
printed into
Sets the font of text subsequently appended to this
object..
Sets the font size of text subsequently appended to this
object.
Sets the footer for this page
Sets the margin for any page footer
Sets the cell format for this group of cells
Setter for the formula adjust disabled property
Sets the garbage collection disabled
Sets the header for this page
Sets the margin for any page headers
Accessor for the image dimensions
Note that the actual size of the rendered image will depend on the
height of the rows it spans
Sets the hidden status of this row/column
Sets the hidden status of this worksheet
Indicates whether or not this sheet is hidden
Sets the horizontal centre
Sets the row at which the pane is frozen horizontally
Sets the horizontal print resolution
Sets the ignore blanks flag
Accessor for the anchor properties
Sets the indentation of the cell text
Sets the initial amount of memory allocated to store the workbook data
when reading a worksheet.
Sets the italic indicator for this font, if the font hasn't been
initialized
Sets the locale used by JExcelApi to generate the spreadsheet.
Sets the location of the cells to be linked to within this workbook
Sets whether or not this XF record locks the cell.
Accessor to set the merged cell checking
Sets the name of this sheet
Disables the handling of names
Accessor for the normal magnificaton factor.
Sets the numeric range against which to validate the data
Sets the numeric value against which to validate
Sets the text orientation for this format
Sets the paper orientation for printing this sheet
Accessor for the page break preview magnificaton factor.
Sets the pageBreakPreviewMode property
Sets the page order for printing this sheet
Sets the page setup details
Sets the page setup details
Sets the page setup details
Sets the page number at which to commence printing
Sets the paper size to be used when printing this sheet
Sets the password for this sheet
Accessor for the password hash - used only when copying sheets
Sets the point size for this font, if the font hasn't been initialized
Sets the print area for this sheet
Sets the printGridLines property
Sets the printHeaders property
Sets both of the print titles for this sheet
Sets the print column titles for this sheet
Sets the print row titles for this sheet
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
Indicates whether or not this sheet is protected
Indicates whether or not this workbook is protected
Sets whether or not to rationalize the cell formats before
writing out the sheet.
Sets the recalculate formulas when the sheet is saved flag
Accessor for the image position
Sets the properties of the specified row
Sets the height of the specified row, as well as its collapse status
Sets the height of the specified row, as well as its collapse status
Sets the view for this column
Sets the scale factor for this sheet to be used when printing.
Sets the script style (eg.
Sets this sheet to be when it is opened in excel
Sets this sheet to be when it is opened in excel
Sets the showGridLines property
Sets the shrink to fit flag
Sets the dimension for this view
Sets the string contents of this cell
Sets Accessor for the strike-out flag
Accessor to set the suppress warnings flag.
Used in conjunction with the UseTemporaryFileDuringWrite setting to
set the target directory for the temporary files.
Sets the underline style for this font, if the font hasn't been
initialized
Sets the URL of this hyperlink
Sets whether a temporary file is used during the generation of
the workbook.
Sets the boolean value for this cell
Sets the numerical value for this cell
Sets the vertical alignment for this format
Sets the row at which the pane is frozen vertically
Sets the vertical print reslution
Accessor for the image dimensions
Note that the actual size of the rendered image will depend on the
width of the columns it spans
Sets the wrap indicator for this format.
Represents a sheet within a workbook.
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.
Cells with this specified orientation will have their text stacked
downwards, but not rotated
A mixin interface for numerical formulas, which combines the interfaces
for formulas and for strings