Actually, you can get very quick (and nice) results using a mime type of
"application/vnd.ms-excel" This lets you output your page as an html
table, formatting things very nicely in Excel.
--
Billy Cravens
[EMAIL PROTECTED]
Dave Watts wrote:
>
> > PROBLEM: Want to dump results from a query into an
> > excel file using the cfcontent tag. This code worked
> > in CF 3.0 but after upgrading to 4.5 it dumps all the
> > data into one cell. What is causing this and how do I
> > get the data to dump into separate cells?
> >
> > I have attached the code. It consists of two pages
> > for simplicity. There is a form page and an action
> > page. Once you submit the form, the action page should
> > open up excel and display the data in excel.
> >
> > Any suggestions are appreciated. Again the problem is
> > that the data is now being dumped into one cell
> > instead of being separated.
>
> One thing that strikes me is that you're including HTML tags in your output
> file, which you're setting as "application/msexcel" using CFCONTENT.
>
> Another thing is that you might use a comma as a delimiter instead of a tab
> - it's more likely to work as desired.
>
> Here are some examples:
>
> http://www.figleaf.com/demo/mimetest/
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
