ColdFusion 9.0 Resources |
SpreadsheetGetCellCommentDescriptionGets the comment for an Excel spreadsheet object cell as a structure with formatting information, or all comments for the object. ReturnsIf the parameters include the row and column: a structure containing the comment information for the specified cell. If the function has only a spreadsheetObj parameter, an array containing a structure for each comment. Each structure has the following information:
See alsoSpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetGetCellValue, SpreadsheetMergeCells, SpreadsheetSetCellComment, SpreadsheetSetCellFormula, SpreadsheetSetCellValue Parameters
ExampleThe following example sets and gets a comment for the cell at row 3column 5. <cfscript> ///We need an absolute path, so get the current directory path. theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "comment.xls"; //Create an Excel spreadsheet object. theSheet = SpreadsheetNew(); // Define a cell comment. comment1.anchor="1,1,15,20"; comment1.author="Adobe Systems"; comment1.bold="true"; comment1.color="lavender"; comment1.comment="This is the cell in row three, column 5 (E)."; comment1.fillcolor="yellow"; comment1.font="Courier"; comment1.horizontalalignment="left"; comment1.linestyle="dashsys"; comment1.size="10"; comment1.verticalalignment="top"; //Set the comment. SpreadsheetSetCellComment(theSheet,comment1,3,5); //Get the comment from the Excel spreadsheet object. theComment=SpreadsheetGetCellComment(theSheet,3,5); </cfscript> <cfoutput> Row,Column: #theComment.row#,#theComment.column#<br /> Author: #theComment.author#<br /> Comment: #theComment.comment# </cfoutput> <!--- Write the spreadsheet to a file, replacing any existing file. ---> <cfspreadsheet action="write" filename="#theFile#" name="theSheet" sheet=1 sheetname="courses" overwrite=true> |