Re: Exporting from ColdFuion to a Excel file

2008-11-19 Thread Steven G
I was having this exact same problem and this solved it for me. Thanks very much Robert! I have a different problem falling under the same topic. I'm trying to download a .csv file from ColdFusion to Excel via a browser. My code is: cfheader name=Content-Type value=text/csv cfheader

Re: Exporting from ColdFuion to a Excel file

2007-10-13 Thread Howard Fore
You could also just use the CF XML functions to write the file out in OpenXML format for Office. See http://openxmldeveloper.org/ for docs on the format. Hofo -- Howard Fore, [EMAIL PROTECTED] In any moment of decision, the best thing you can do is the right thing, the next best thing is the

RE: Exporting from ColdFuion to a Excel file

2007-10-12 Thread William Seiter
to: www.winninginthemargins.com Enter passkey: goldengrove -Original Message- From: Steve Sequenzia [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 7:51 PM To: CF-Talk Subject: RE: Exporting from ColdFuion to a Excel file William, Sorry for not being more descriptive. I just need

RE: Exporting from ColdFuion to a Excel file

2007-10-12 Thread Steve Sequenzia
I have tried a few ways to export from CF to Excel. I tried a basic query and used cfcontent to download the file. I tried cfreport. They both seem to work fine but a security warning pops up on the client computer when the file is opened. It seems to only come up on computers running Office 07.

Re: Exporting from ColdFuion to a Excel file

2007-10-12 Thread Robert Mack
I have a different problem falling under the same topic. I'm trying to download a .csv file from ColdFusion to Excel via a browser. My code is: cfheader name=Content-Type value=text/csv cfheader name=Content-Disposition value=attachment; filename=Target_File_Name.csv cfcontent

Re: Exporting from ColdFuion to a Excel file

2007-10-12 Thread Robert Mack
I have a different problem falling under the same topic. I'm trying to download a .csv file from ColdFusion to Excel via a browser. My code is: cfheader name=Content-Type value=text/csv cfheader name=Content-Disposition value=attachment; filename=Target_File_Name.csv cfcontent

RE: Exporting from ColdFuion to a Excel file

2007-10-12 Thread Will Swain
I didn't know that. That's really nice - I can see a lot of uses for this. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 12 October 2007 02:43 To: CF-Talk Subject: RE: Exporting from ColdFuion to a Excel file Or, if the data is query data, use cfreport which can

Re: Exporting from ColdFuion to a Excel file

2007-10-12 Thread Rick Root
On 10/12/07, Steve Sequenzia [EMAIL PROTECTED] wrote: If you hit yes it opens fine. I am just concerned that this will confuse users and they will not open it. In our environment, that's not a problem because if they want the file, they have to open it :) Otherwise, they can't do their jobs!

Re: Exporting from ColdFuion to a Excel file

2007-10-11 Thread Jerry Johnson
cfcontent type=application/vnd.ms-excel cfheader name=Content-Disposition value=filename=#filename#.xls cfoutput#pageContent#/cfoutput I assume this will still work on 8 Jerry On 10/11/07, Steve Sequenzia [EMAIL PROTECTED] wrote: Can someone please give me some insight into exporting data to

RE: Exporting from ColdFuion to a Excel file

2007-10-11 Thread Ben Forta
Or, if the data is query data, use cfreport which can output to Excel. --- Ben -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 9:26 PM To: CF-Talk Subject: Re: Exporting from ColdFuion to a Excel file cfcontent type=application/vnd.ms

RE: Exporting from ColdFuion to a Excel file

2007-10-11 Thread William Seiter
Steve, Like skinning a cat, there are several ways to have a web document end up in Excel. Can you describe your scenario? What are you trying to accomplish? William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey:

RE: Exporting from ColdFuion to a Excel file

2007-10-11 Thread Steve Sequenzia
[mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 9:43 PM To: CF-Talk Subject: RE: Exporting from ColdFuion to a Excel file Or, if the data is query data, use cfreport which can output to Excel. --- Ben -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday

RE: Exporting from ColdFuion to a Excel file

2007-10-11 Thread Steve Sequenzia
407.459.1305 Direct 866.892.3000 Help Desk 407.895.3338 Fax -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Thursday, October 11, 2007 10:29 PM To: CF-Talk Subject: RE: Exporting from ColdFuion to a Excel file Steve, Like skinning a cat, there are several ways to have