Title:
Bug 79293:Writing out a query to a spreadsheet using cfspreadsheet will add the query columns to first row of the spreadsheet as headers
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Matthew Abbott / Matthew Abbott (Matthew Abbott)
Created: 08/05/2009
Components: Document Management, Office Integration
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Minor / Unknown
Locale/System: English / Platforms All
Vote Count: 0
Problem:
Writing out a query to a spreadsheet using cfspreadsheet will add the query columns to first row of the spreadsheet as headers. When you try to write out a query in cfscript using the SpreadSheetNew() and SpreadSheetAddRows(), query columns do not appear.
Method:
<cfspreadsheet action="write" filename="file.xls" query="myquery" overwrite="true" ><cfscript> ss = SpreadSheetNew(); SpreadSheetAddRows(ss,qNames);</cfscript><cfspreadsheet action="write" filename="file.xls" name="ss" overwrite=true>
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3039570
External Customer Info:
External Company:
External Customer Name: Matthew Abbott
External Customer Email: 7A103E3F446A7873992015D5
External Test Config: 08/05/2009Attachments:
Comments: