Specifies the comment for an Excel spreadsheet object cell.
spreadsheetSetCellComment(spreadsheetObj, comment, row, column)
→ returns void
<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>
Signup for cfbreak
to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.