Show last authors
1 The ExcelWorkbook is used to read Excel spread sheets.
2 Those Excel files may be opened for readonly (Readonly workbook) or read / write (Writable Workbook)
3
4 == Functions ==
5 === loadWorkbook(data, encoding) ===
6 Loads a read only workbook
7 * data Can be either a binary (from an attachment for example) or a file path
8 * encoding. By default, UTF-8. ISO-8859-1 should be used for ISO latin 1 files.
9
10 @return: A readonly workbook
11 @see: loadWritableWorkbook
12 === createWritableWorkbook(strFileName) ===
13 Creates a new writable Workbook
14 * strFileName The workbook name
15
16 @return: A writable Workbook
17 === loadWritableWorkbook(data, strOutputFileName, encoding) ===
18 Read a workbook and creates a writable workbook.
19 The filename is just a name. It may not be used as a path to save the Excel sheet.
20 * data May be either a binary (for an attachment) or a file path
21 * filename The output file name
22 * encoding By default, UTF-8. ISO-8859-1 should be used for ISO latin 1 files.
23
24 @return: A writable workbook
25 example:
26 {{code language="javascript"}}
27 var workbook = ExcelWorkbook.loadWritableWorkbook(data.custFile.sysData, "test.xls", "ISO-8859-1");
28 {{/code}}
This wiki is licensed under a Creative Commons 2.0 license
XWiki Enterprise 9.11.5 - Documentation