cfdocs

spreadsheetSetCellFormula

Specifies the formula for an Excel spreadsheet object cell.

spreadsheetSetCellFormula(spreadsheetObj, formula, row, column)

returns void

Argument Reference

Name	Type	Required	Default	Description
spreadsheetObj	variableName	Yes		No Help Available
formula	string	Yes		No Help Available
row	numeric	Yes		No Help Available
column	numeric	Yes		No Help Available

Script Example

<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>

This site is open source. Improve this page.