Whatever message this page gives is out now! Go check it out!
SpreadsheetGetCellFormula
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 formula for an Excel spreadsheet object cell, or all formulas for the object.
Returns
If the parameters include the row and column: a string containing the formula. If the function has the spreadsheetObj parameter, an array containing structures for each formula.
Category
Microsoft Office Integration
Function syntax
SpreadsheetGetCellFormula(spreadsheetObj[, row, column]) |
See also
History
ColdFusion 9: Added the function.
Parameters
Parameter | Description |
spreadsheetObj | The Excel spreadsheet object from which to get the formula. |
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. |
Usage
If you specify only the spreadsheetObj parameter, the function returns an array of the structures with the following contents. The array has one entry for each cell that contains a formula.
Field | Valid values |
formula | The formula for the cell. |
row | The row number of the cell. |
column | The column number of the cell. |
Example
The following example sets a cell formula, and gets the cell formula and value.
<cfscript>
//Create a new Excel spreadsheet object.
theSheet=SpreadsheetNew();
//Set the values of column 3 rows 1-10 to the row number.
for (i=1; i<= 10; i=i+1)
SpreadsheetSetCellValue(theSheet,i,i,3);
//Set the formula for the cell in row 11 column 3 to be the sum of
//Columns 1-10.
SpreadsheetSetCellFormula(theSheet,"SUM(C1:C10)",11,3);
//Get the formula from the Excel spreadsheet object.
theValue=SpreadsheetGetCellFormula(theSheet,11,3);
//Get the value of row 11 column 5 from the Excel spreadsheet object.
theValue=SpreadsheetGetCellValue(theSheet,11,3);
</cfscript>
<cfoutput>
Row 11, Column 3 value: #SpreadsheetGetCellValue(theSheet,11,3)#<br />
Row 11, Column 3 formula: #SpreadsheetGetCellFormula(theSheet,11,3)#<br />
</cfoutput>
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
|
