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
A helper to transform between excel cell references and
sheet:column:row notation
Because this function will be called when generating a string
representation of a formula, the cell reference will merely
be appened to the string buffer instead of returning a full
blooded string, for performance reasons
Flag to indicate whether the chart feature is enabled or not
Charts deactivated using -Dnocharts=true on the JVM command line
Activated by default or by using -Dnocharts=false on the JVM command line
Writes out a compound file
Header block is -1
Excel data is e..n (where is the head extension blocks, normally 0 and
n is at least 8)
Summary information (8 blocks)
Document summary (8 blocks)
BBD is block p..q (where p=e+n+16 and q-p+1 is the number of BBD blocks)
Property storage block is q+b...r (normally 1 block) (where b is the number
of BBD blocks)
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 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 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 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
Flag to indicate whether the name feature is enabled or not
Names deactivated using -Dnonames=true on the JVM command line
Activated by default or by using -Dnonames=false on the JVM command line
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.
Called when the cell is added to the worksheet in order to indicate
that this object is already added to the worksheet
This method also verifies that the associated formats and formats
have been initialized correctly
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.
A container for the list of fonts used in this workbook The writable
subclass instantiates the predetermined list of fonts available to
users of the writable API
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