spreadsheetSetCellComment

Specifies the comment for an Excel spreadsheet object cell.

spreadsheetSetCellComment(spreadsheetObj, comment, row, column) → returns void

spreadsheetSetCellComment Argument Reference

spreadsheetObj
Required

No Help Available

comment
Required

No Help Available

row
Required

No Help Available

column
Required

No Help Available

Examples sample code invoking the spreadsheetSetCellComment function


Tag 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> 
   comment1=structNew() ; 
     comment1.anchor="0,0,5,8"; 
     comment1.author="John Jones"; 
     comment1.comment="This is a test comment"; 
     comment1.size="10"; 
     //Set the comment. 
 SpreadsheetSetCellComment(s,comment1,3,5); 
     //Get the comment from the Excel spreadsheet object. 
   theComment=SpreadsheetGetCellComment(s,3,5); 
 </cfscript> 
 <cfoutput> 
 Row,Column: #theComment.row#,#theComment.column#<br /> 
 Author: #theComment.author#<br /> 
 Comment: #theComment.comment# 
 </cfoutput> 

Fork me on GitHub