Create spreadsheet from given spreadsheet object

spreadsheetCreateSheet(spreadsheetObj, name) → returns void

Argument Reference for the spreadsheetCreateSheet function


Required: Yes
No Help Available


Required: Yes
No Help Available

Examples sample code invoking the spreadsheetCreateSheet function

Tag Example

The following example creates two sheets: CourseData and EvaluationSheet.

// Make a spreadsheet object
spreadsheet = spreadsheetNew("Sheet A");

// add a new sheet
spreadsheetCreateSheet(spreadsheet, "Sheet B");

// set the new sheet to be the active one
SpreadsheetSetActiveSheet(spreadsheet, "Sheet B");

// populate Sheet B
i = 1;
while (i < 10) {
    SpreadsheetSetCellValue(spreadsheet, "col #i#", 1, i);

<cfheader name="Content-Disposition" value="inline; filename=testFile.xls">
<cfcontent type="application/vnd.msexcel" variable="#SpreadSheetReadBinary(spreadsheet)#">

Fork me on GitHub