That did it Joe.Thanks ----- Original Message ----- From: "Joe Eugene" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 10:36 PM Subject: RE: Exporting to Excel Quandry
> > 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 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