Whatever message this page gives is out now! Go check it out!
SpreadsheetGetCellValue
Last update:
May 18, 2026
Note: 
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:
- Log in with your Gmail or Facebook credentials.
- Navigate to the project in the left pane.
- Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
- Give the project a suitable name and click Save.
Description
Gets the Value for an Excel spreadsheet object cell.
Returns
A string containing the cell value.
Category
Microsoft Office Integration
Function syntax
SpreadsheetGetCellValue(spreadsheetObj, row, column) |
See also
History
ColdFusion 9: Added the function.
Parameters
Parameter | Description |
spreadsheetObj | The Excel spreadsheet object from which to get the value. |
row | The row number of the cell from which to get the formula. |
column | The column number of the cell from which to get the formula. |
Example
The following lines create an Excel spreadsheet object, set the value of the cell at row 3, column 5 - 365, gets the value and displays it:
<cfscript>
//Create a new Excel spreadsheet object.
theSheet=SpreadsheetNew();
//Set the value of the cell at row 3 column 5.
SpreadsheetSetCellValue(theSheet,365,3,5);
//Get the value from the Excel spreadsheet object.
theValue=SpreadsheetGetCellValue(theSheet,3,5);
WriteOutput("The value of column 5 row 3 is: " & theValue);
</cfscript>
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Share additional feedback to help us improve.
0/255
|
