spreadsheetNew

Creates a ColdFusion spreadsheet object, which represents a single sheet of an Excel document.

spreadsheetNew([sheetname] [, xmlFormat]) → returns any

Argument Reference

String value to be used as the sheet name.

Boolean value to indicate the use of Excels xlsx format.

Values:

Examples

Sample code invoking the spreadsheetNew function

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);

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Argument Reference