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.
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
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.
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
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.
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.
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
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 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.
The HIDEOBJ record stores options selected in the Options dialog,View tab
Possible values are:
HIDEOBJ_HIDE_ALL, HIDEOBJ_SHOW_ALL and HIDEOBJ_SHOW_PLACEHOLDERS
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
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).
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
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.
The HIDEOBJ record stores options selected in the Options dialog,View tab
Possible values are:
HIDEOBJ_HIDE_ALL, HIDEOBJ_SHOW_ALL and HIDEOBJ_SHOW_PLACEHOLDERS
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
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.
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
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