ExcelWorkbook

The ExcelWorkbook is used to read Excel spread sheets.
 Those Excel files may be opened for readonly (Readonly workbook) or read / write (Writable Workbook)

Functions

loadWorkbook(data, encoding)

Loads a read only workbook

• data Can be either a binary (from an attachment for example) or a file path
• encoding. By default, UTF-8. ISO-8859-1 should be used for ISO latin 1 files.

@return: A readonly workbook
@see: loadWritableWorkbook

createWritableWorkbook(strFileName)

Creates a new writable Workbook

• strFileName The workbook name

@return: A writable Workbook

loadWritableWorkbook(data, strOutputFileName, encoding)

Read a workbook and creates a writable workbook.
 The filename is just a name. It may not be used as a path to save the Excel sheet.

• data May be either a binary (for an attachment) or a file path
• filename The output file name
• encoding By default, UTF-8. ISO-8859-1 should be used for ISO latin 1 files.

@return: A writable workbook
example:
var workbook = ExcelWorkbook.loadWritableWorkbook(data.custFile.sysData, "test.xls", "ISO-8859-1");