Last updated on
Feb 25, 2025
Description
Sets the values of a range of cells to a specified value.
Returns
None
History
ColdFusion (2025 release): Added the function.
Syntax
spreadsheetSetCellRangeValue(spreadsheetObject,value,startRow,startColumn,endRow,endColumn)
spreadsheetSetCellRangeValue(spreadsheetObject,value,startRow,startColumn,endRow,endColumn)
spreadsheetSetCellRangeValue(spreadsheetObject,value,startRow,startColumn,endRow,endColumn)
Parameters
Name
|
Required
|
Type
|
Description
|
spreadSheetObject
|
Yes
|
ExcelInfo
|
The Excel spreadsheet object from which to set the cell as active.
|
value
|
Yes
|
Any
|
The value to set on the cell range.
|
startRow
|
Yes
|
Integer
|
The start row number of cell range.
|
startColumn
|
Yes
|
Integer
|
The start column number of cell range.
|
endRow
|
Yes
|
Integer
|
The end row number of cell range.
|
endColumn
|
Yes
|
Integer
|
The end column number of cell range.
|
Example
<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 cell range value 55,1 to 55,8
// with the string "This is a value"
spreadsheetSetCellRangeValue(theSheet,"This is a value",55,1,55,8,"String")
spreadsheetWrite(theSheet,theFile,"yes")
</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 cell range value 55,1 to 55,8
// with the string "This is a value"
spreadsheetSetCellRangeValue(theSheet,"This is a value",55,1,55,8,"String")
spreadsheetWrite(theSheet,theFile,"yes")
</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 cell range value 55,1 to 55,8
// with the string "This is a value"
spreadsheetSetCellRangeValue(theSheet,"This is a value",55,1,55,8,"String")
spreadsheetWrite(theSheet,theFile,"yes")
</cfscript>
