Working With Spreadsheets In ColdFusion 9

  • February 8, 2017
  • Posted by: user
  • Category: Uncategorized
No Comments

Hi Dear,

The following example uses the cfspreadsheet tag to read and write excel spreadsheets using different formats. It also shows a simple use of ColdFusion 9 Spreadsheet functions to modify a excel sheet.

[code:cf]<!— Read spreadsheet —>
<cfspreadsheet action="read"
src="Department.xls"
name="DObj" />
<!— Set cell value —>
<cfset spreadsheetSetCellValue(DObj,’Coldfusion’,form.row, form.col)>
<!— Write spreadsheet —>
<cfspreadsheet action="write" overwrite="true"
filename="Department.xls"
name="DObj" />
<cfspreadsheet action="read"
src="Department.xls"
query="myQuery">
<cfdump var="#myQuery#">[/code]