> spreadsheet. What happens is everytning is in a new row. I have > played around with the delimiters, but nothing.
This should work. Try using Html table code in your output. ie <cfoutput> <table....> <tr><td></td></tr>.. </table> </cfoutput> Joe Eugene > -----Original Message----- > From: Bruce Sorge [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 16, 2003 11:10 PM > To: CF-Talk > Subject: Exporting to Excel Quandry > > > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
