SpreadsheetSetActiveSheetNumber

Description

Sets a specified sheetnumber as active sheet.

Returns

Does not return a value.

Category

Microsoft Office Integration

Function syntax

SpreadsheetSetActiveSheetNumber(spreadsheetobj, sheetnumber)

See also

SpreadsheetSetActiveSheet, SpreadsheetAddColumn, SpreadsheetAddImage, SpreadsheetAddRow, SpreadsheetDeleteRow, SpreadsheetDeleteRows, SpreadsheetFormatRow, SpreadsheetFormatRows, SpreadsheetShiftRows

History

ColdFusion 9: Added the function.

Parameters

Usage

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.

Example

The following example shows how to switch from one sheet to another and perform operations.

<!--- Get the spreadsheet data as a query. ---> 
<cfquery 
       name="courses" datasource="cfdocexamples" 
       cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#"> 
       SELECT CORNUMBER,DEPT_ID,COURSE_ID,CORNAME 
       FROM COURSELIST 
</cfquery> 
<cfset theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & courses.xls"> 
<cfspreadsheet action="read" name=theSheet src="#theFile#" sheet="1"> 
     
<cfscript> 
    SpreadsheetAddRows(theSheet,courses); 
    //Set the sheetnumber 2 as active. 
    SpreadsheetSetActiveSheetNumber (theSheet, 2); 
    //Add a new row to the sheet 2. 
    SpreadsheetAddRows(theSheet,courses); 
</cfscript> 
 
<!--- Write the spreadsheet to a file, replacing any existing file. ---> 
<cfspreadsheet action="write" filename="#theFile#" name="theSheet"  
    sheet=1 sheetname="courses" overwrite=true>