spreadsheetNew

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

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

  1. CFDocs
  2. Functions
  3. ColdFusion 9 New Functions and Tags
  4. spreadsheetNew
  5. CF9+
  6. BD
  7. 0 Issue
  8. Edit
See Also:   spreadsheetAddRow   spreadsheetRead   spreadsheetformatCell   spreadsheetWrite

Argument Reference

sheetname string

String value to be used as the sheet name.

xmlFormat boolean
Default: false

Boolean value to indicate the use of Excels xlsx format.
Values:
  • true
  • false

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.

Fork me on GitHub