This adapter generates "simply" structured Excel 97-2003 or Excel 2007 documents. If you have to create more complex Excel documents, have a look at Excel Generator.
Procedure for Using the BigExcel Generator
The generation of Excel documents involves these steps:
- Create an Excel 97-2003 (newXlsWorkbook()) or Excel 2007 (newXlsxWorkbook()) workbook.
- Specify types for the cells of the subsequent rows (setTypes()).
This step is optional. If you do not set types, the Excel default types will be used. - Specifiy formats for the cells of the subsequent rows (setFormats()).
This step is optional. If you do not set formats, the Excel default formats will be used. - Add data to the excel sheet (addRow()).
- Write the Excel document (generateExcel()).
- Release the resources used by the created workbook (dispose())
In order to minimize the data transfer between the JVM and the E2E Runtime, a unique id returned by newXlsWorkbook() / newXlsxWorkbook() is used to reference the workbook in any other operation call.
While the newXlsWorkbook() operations require the whole Excel document data structure to be hold in memory, the newXlsxWorkbook() operations require to hold only a certain number of rows in memory, while the other parts of the Excel document are swapped to a temporary file.
Operations of the BigExcel Generator
newXLSWorkbook Operations
newXlsWorkbook() : String
creates an Excel 97-2003 workbook
Parameter | Direction | Description |
---|---|---|
workbookId | return | Reference to the created workbook. |
newXlsWorkbook( sheetName : String ) : String
creates an Excel 97-2003 workbook containing a single worksheet named sheetName
Parameter | Direction | Description |
---|---|---|
sheetName | in | Name of the worksheet to be contained in this workbook. |
workbookId | return | Reference to the created workbook. |
newXlsWorkbook( sheetNames : String[] ) : String
creates an Excel 97-2003 workbook
Parameter | Direction | Description |
---|---|---|
sheetNames | in | An array with the names of the worksheets to be contained in this workbook. |
workbookId | return | Reference to the created workbook. |
newXlsWorkbook( numberOfSheets : Integer ) : String
creates an Excel 97-2003 workbook containing numberOfSheets worksheets
Parameter | Direction | Description |
---|---|---|
numberOfSheets | in | Number of the worksheets to be contained in this workbook. |
workbookId | return | Reference to the created workbook. |
newXlsxWorkbook( rowWindowSize : Integer, compressTempFile : Boolean ) : String
creates an Excel 2003 workbook
Paramter | Direction | Description |
---|---|---|
rowWindowSize | in | Number of rows to be hold in memory (if -1, all rows will be hold in memory). |
compressTempFile | in | if true, the temporary file will be compressed. |
workbookId | return | Reference to the created workbook. |
newXlsxWorkbook( sheetName : String, rowWindowSize : Integer, compressTempFile : Boolean ) : String
creates an Excel 2003 workbook containing a single worksheet named sheetName
Parameter | Direction | Description |
---|---|---|
sheetName | in | Name of the worksheet to be contained in this workbook. |
rowWindowSize | in | Number of rows to be hold in memory (if -1, all rows will be hold in memory). |
compressTempFile | in | If true, the temporary file will be compressed. |
workbookId | return | Reference to the created workbook. |
newXlsxWorkbook( sheetNames : String[], rowWindowSize : Integer, compressTempFile : Boolean ) : String
creates an Excel 2003 workbook
Parameter | Direction | Description |
---|---|---|
sheetNames | in | An array with the names of the worksheets to be contained in this workbook. |
rowWindowSize | in | Number of rows to be hold in memory (if -1, all rows will be hold in memory). |
compressTempFile | in | If true, the temporary file will be compressed. |
workbookId | return | Reference to the created workbook. |
newXlsxWorkbook( numberOfSheets: Integer, rowWindowSize : Integer, compressTempFile : Boolean ) : String
creates an Excel 2003 workbook containing numberOfSheets worksheets
Parameter | Direction | Description |
---|---|---|
numberOfSheets | in | Number of the worksheets to be contained in this workbook. |
rowWindowSize | in | Number of rows to be hold in memory (if -1, all rows will be hold in memory). |
compressTempFile | in | If true, the temporary file will be compressed. |
workbookId | return | Reference to the created workbook. |
All of the above newXlsxWorkbook() operations have variants without rowWindowSize and compressTempFile parameters. rowWindowSize defaults to 100, compressTempFile defaults to false.
setTypes Operations
setTypes( workbookId : String, sheetName : String, types : String[])
sets the type information for the subsequently added rows
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook. |
sheetName | in | The name of the worksheet. |
types | in | An array of the types of the cells (valid values: "Text", "Boolean", "Number", "IsoDateTime", "TimeTicks" or NULL). |
setTypes( workbookId : String, sheetIndex : String, types : String[])
sets the type information for the subsequently added rows
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook. |
sheetIndex | in | The index of the worksheet. |
types | in | An array of the types of the cells (valid values: "Text", "Boolean", "Number", "IsoDateTime", "TimeTicks" or NULL). |
setFormats Operations
setFormats( workbookId : String, sheetName : String, formats: String[])
sets the format information for the subsequently added rows
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook. |
sheetName | in | The name of the worksheet. |
formats | in | An array of the formats of the cells. |
setFormats( workbookId : String, sheetIndex : String, formats: String[])
sets the format information for the subsequently added rows
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook. |
sheetIndex | in | The index of the worksheet. |
formats | in | An array of the formats of the cells. |
addRow Operations
addRow( workbookId : String, values : String[], types : String[], formats : String[] )
add a new row to the first worksheet of the workbook referenced by workbookId
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook |
values | in | An array holding the values of the cells in that row |
types | in | An array holding the types of the cells in that row; will temporarily override any values set by setTypes() |
formats | in | An array holding the formats of the cells in that row; will temporarily override any values set by setFormats() |
addRow( workbookId : String, sheetName : String, values : String[], types : String[], formats : String[] )
add a new row to worksheet sheetName of the workbook referenced by workbookId
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook |
sheetName | in | The name of the worksheet |
values | in | An array holding the values of the cells in that row |
types | in | An array holding the types of the cells in that row; will temporarily override any values set by setTypes() |
formats | in | An array holding the formats of the cells in that row; will temporarily override any values set by setFormats() |
addRow( workbookId : String, sheetIndex : Integer, values : String[], types : String[], formats : String[] )
add a new row to worksheet sheetIndex of the workbook referenced by workbookId
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook |
sheetIndex | in | The index of the worksheet |
values | in | An array holding the values of the cells in that row |
types | in | An array holding the types of the cells in that row; will temporarily override any values set by setTypes() |
formats | in | An array holding the formats of the cells in that row; will temporarily override any values set by setFormats() |
There are variants of the addRow() operations that do not have types and formats parameters.
generateExcel Operations
generateExcel( workbookId : String, filename : String )
writes the Excel document to file filename
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook |
filename | in | The name of the Excel file to be written |
generateExcel( workbookId : String ) : Blob
writes the Excel document to a blob
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook |
result | return | The blob to be written |
dispose( workbookId : String )
releases the resources bound to this workbook
Parameter | Direction | Description |
---|---|---|
workbookId | in | The id of the workbook |
You can extract the javadoc folder from excelgenerator.jar to get additional information on the Java methods wrapped by this adapter.