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
Simple util class which uses the api to present the contents of an Excel
Worksheet as comma separated values, using a workbook and output stream of your
choice
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.
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.
Gets the color for the given cell border If a border type of ALL or NONE is
specified, then a line style of NONE is returned If the specified cell does not
have an associated line style, then the color the line would be is still
returned
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.
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.
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.
Sets whether or not to enable any property sets (such as macros) to be copied
along with the workbook Leaving this feature enabled will result in the XL
process using more memory
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