OK, I know that this should work, but it is not. I have the following code:
<CFHEADER NAME="content-disposition" VALUE="inline; filename=exportfile#today#.xls">
<cfcontent type="application/ms-excel">
<cfloop list="#qUsers.columnList#" index="i">
<cfoutput>#i##CHR(10)#</cfoutput>
</cfloop><cfoutput>#CHR(32)#</cfoutput>
<cfoutput query="qUsers">
<cfloop list="#qUsers.columnList#" index="i">
<cfset currentColumn = Evaluate("qUsers." &
i)>#currentColumn##CHR(10)#</cfloop>#CHR(32)#
</cfoutput>
When I run the page, and save the file as .xls, then I open Excel, I cannot get the
data for format correctly in the spreadsheet. What happens is everytning is in a new
row. I have played around with the delimiters, but nothing. Anyone can point me to the
right place I would appreciate it.
Thanks,
Bruce
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
