You can find the CFFiddle demo of this function and other spreadsheet functions as part of a project that is shared with you.
Click the button below to launch CFFiddle.
To copy the project in your workspace in CFFiddle, follow the steps below:
Sets a specified sheetnumber as active sheet.
Does not return a value.
Microsoft Office Integration
ColdFusion 9: Added the function.
The Excel spreadsheet object to which to add the split pane.
The spreadsheet number that must be set as active.
You can set only one sheet as active at a time. Therefore, any sheet operation is limited to a particular sheet. For operations in any other sheet, you must set that sheet as active.
The following example shows how to switch from one sheet to another and perform operations.
|<!--- Get the spreadsheet data as a query. --->
cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">
<cfset theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & courses.xls">
<cfspreadsheet action="read" name=theSheet src="#theFile#" sheet="1">
//Set the sheetnumber 2 as active.
SpreadsheetSetActiveSheetNumber (theSheet, 2);
//Add a new row to the sheet 2.
<!--- Write the spreadsheet to a file, replacing any existing file. --->
<cfspreadsheet action="write" filename="#theFile#" name="theSheet"
sheet=1 sheetname="courses" overwrite=true>