Wiki source code of ExcelWorkbook

Last modified by Maurice Gasco on 2018/06/07 16:48

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}}

Quick Links