spreadsheetSetCellFormula

Specifies the formula for an Excel spreadsheet object cell.

spreadsheetSetCellFormula(spreadsheetObj, formula, row, column) → returns void

Argument Reference

spreadsheetObj variableName
Required

No Help Available

formula string
Required

No Help Available

row numeric
Required

No Help Available

column numeric
Required

No Help Available

Examples
Sample code invoking the spreadsheetSetCellFormula function

<cfset q = queryNew("Name,Beers,Vegetables,Fruits,Meats", "cf_sql_varchar,cf_sql_integer,cf_sql_integer,cf_sql_integer,cf_sql_integer")> 
  <cfset queryAddRow(q)> 
  <cfset querySetCell(q, "Name", "John")> 
  <cfset querySetCell(q, "Beers", "1")> 
  <cfset querySetCell(q, "Vegetables", "1")> 
  <cfset querySetCell(q, "Fruits", "1")> 
  <cfset querySetCell(q, "Meats", "1")> 
  <cfset mySheet =   SpreadsheetNew( "Test"  ) /> 
  <!--- Make a spreadsheet object ---> 
  <cfset s = spreadsheetNew()> 
  <!--- Add header row ---> 
  <cfset spreadsheetAddRow(s, "Name,Beers,Vegetables,Fruits,Meats")> 
  <!--- Add query ---> 
   <cfscript> 
 SpreadsheetSetCellValue(theSheet,'SetIT',2,3); 
   theFormula=SpreadsheetGetCellFormula(s,2,3); 
 </cfscript> 
 <cfoutput> 
 Row,Column: #theFormula# 
 </cfoutput> 

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub