spreadsheetSetActiveCell

ColdFusion

Open app

Description

Sets a specified cell as active.

Returns

None

History

ColdFusion (2025 release): Added the function.

Syntax

spreadsheetSetActiveCell(spreadsheetObject,row,column)

spreadsheetSetActiveCell(spreadsheetObject,row,column)

Parameters

Name

Required

Type

Description

spreadSheetObject

Yes

ExcelInfo

The Excel spreadsheet object on which to set a cell as active.

row

Yes

Integer

The row number of the cell.

column

Yes

Integer

The column number of the cell.

Example

SELECT * FROM ART

</cfquery>

theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art.xls";

// create a spreadsheet object

theSheet=spreadsheetNew("SampleData")

// add rows from query

spreadsheetAddRows(theSheet,art)

// set active cell 1,6

spreadsheetSetActiveCell(theSheet,10,6)

spreadsheetWrite(theSheet,theFile,"yes")

infoActiveCell=spreadsheetGetActiveCell(theSheet)

writeDump(infoActiveCell)

</cfscript>

<cfquery name="art" datasource="cfartgallery"> SELECT * FROM ART </cfquery> <cfscript> theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art.xls"; // create a spreadsheet object theSheet=spreadsheetNew("SampleData") // add rows from query spreadsheetAddRows(theSheet,art) // set active cell 1,6 spreadsheetSetActiveCell(theSheet,10,6) spreadsheetWrite(theSheet,theFile,"yes") infoActiveCell=spreadsheetGetActiveCell(theSheet) writeDump(infoActiveCell) </cfscript>

<cfquery name="art" datasource="cfartgallery">
    SELECT * FROM ART
</cfquery>
<cfscript>
    theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art.xls";
    // create a spreadsheet object
    theSheet=spreadsheetNew("SampleData")
    // add rows from query
    spreadsheetAddRows(theSheet,art)
    // set active cell 1,6
    spreadsheetSetActiveCell(theSheet,10,6)
    spreadsheetWrite(theSheet,theFile,"yes")
    infoActiveCell=spreadsheetGetActiveCell(theSheet)
    writeDump(infoActiveCell)
</cfscript>

Get help faster and easier

New user?