Creates a ColdFusion spreadsheet object, which represents a single sheet of an Excel document.
spreadsheetNew([sheetname] [, xmlFormat])
returns any
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
| sheetname | string | No | String value to be used as the sheet name. | |
| xmlFormat | boolean | No | false | Boolean value to indicate the use of Excels xlsx format. |
xlsx files with and with out sheet name
xlsxSheet1 = spreadsheetNew("xlsx sheet",true);
xlsxSheet2 = spreadsheetNew(true);
writeDump(xlsxSheet1);
writeDump(xlsxSheet2);
xls files with and with out sheet name
xlsSheet1 = spreadsheetNew("xls sheet");
xlsSheet2 = spreadsheetNew();
writeDump(xlsSheet1);
writeDump(xlsSheet2);