RE: query output to Excel file
What's the code look like for pushing an ordinary html table as a file with an .xls extention using cfcontent? Can you give an example for us? Rick -Original Message- From: Chris Stoner [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 4:37 PM To: CF-Talk Subject: Re: query output to Excel file push an ordinary html table as a file with an .xls extention using cfcontent. - Original Message - From: Petr Kysela [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~ | Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 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 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: query output to Excel file
Try something like this. CFQUERY name=Dynamic datasource=#Session.dsn# #PreserveSingleQuotes(MyQueryString)# /CFQUERY CFSAVECONTENT variable=mynewxlsfile CFOUTPUT Table CFLOOP query=Dynamic TR TD#Dynamic.FldName1#/TD TD#Dynamic.FldName2#/TD TD#Dynamic.FldName3#/TD /TR /CFLOOP /TABLE /CFOUTPUT /CFSAVECONTENT CFOUTPUT CFSET FileToWrite = QueryResults_Date#dateformat(Now(),'dd-mm-yyy')#_Time#Timeformat(Now(),'hhm msstt')#.xls CFFILE action=WRITE output=#mynewxlsfile# File=d:\somedir\#FileToWrite# nameconflict=OVERWRITE /CFOUTPUT HTH DavidB -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:05 AM To: CF-Talk Subject: RE: query output to Excel file What's the code look like for pushing an ordinary html table as a file with an .xls extention using cfcontent? Can you give an example for us? Rick -Original Message- From: Chris Stoner [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 4:37 PM To: CF-Talk Subject: Re: query output to Excel file push an ordinary html table as a file with an .xls extention using cfcontent. - Original Message - From: Petr Kysela [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~ | Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 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 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: query output to Excel file
cfcontent type=application/msexcel cfheader name=Content-Disposition value=attachment; filename=#attributes.name##.xls cfoutput table border=1 tr thOrganisation/th thName OCP/th thActivity/th thType/th thGeoscope/th thRegiser date/th /tr cfloop query=qOrg tr valign=top td#qORG.ORG_NAME#/td td#qORG.USR_LASTNAME#, #qOrg.USR_FIRSTNAME#/td td#qORG.ORG_ACTIVITY#/td td#qORG.ORG_TYPE#/td td#qOrg.GEOSCOPE_NAME#/td td#qOrg.ORG_REGISTER_DATE#/td /tr /cfloop /table /cfoutput cfabort -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: donderdag 11 september 2003 16:05 To: CF-Talk Subject: RE: query output to Excel file What's the code look like for pushing an ordinary html table as a file with an .xls extention using cfcontent? Can you give an example for us? Rick ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: query output to Excel file
The cfheader has an error because I deleted some code. It should read cfheader name=Content-Disposition value=attachment; filename=#attributes.name#.xls -Original Message- From: Pascal Peters Sent: donderdag 11 september 2003 16:16 To: CF-Talk Subject: RE: query output to Excel file cfcontent type=application/msexcel cfheader name=Content-Disposition value=attachment; filename=#attributes.name##.xls cfoutput table border=1 tr thOrganisation/th thName OCP/th thActivity/th thType/th thGeoscope/th thRegiser date/th /tr cfloop query=qOrg tr valign=top td#qORG.ORG_NAME#/td td#qORG.USR_LASTNAME#, #qOrg.USR_FIRSTNAME#/td td#qORG.ORG_ACTIVITY#/td td#qORG.ORG_TYPE#/td td#qOrg.GEOSCOPE_NAME#/td td#qOrg.ORG_REGISTER_DATE#/td /tr /cfloop /table /cfoutput cfabort ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: query output to Excel file
Thanks, David... Rick Anything similar to save data/HTML to Word documents in a tab delimited format? -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:06 AM To: CF-Talk Subject: RE: query output to Excel file Try something like this. CFQUERY name=Dynamic datasource=#Session.dsn# #PreserveSingleQuotes(MyQueryString)# /CFQUERY CFSAVECONTENT variable=mynewxlsfile CFOUTPUT Table CFLOOP query=Dynamic TR TD#Dynamic.FldName1#/TD TD#Dynamic.FldName2#/TD TD#Dynamic.FldName3#/TD /TR /CFLOOP /TABLE /CFOUTPUT /CFSAVECONTENT CFOUTPUT CFSET FileToWrite = QueryResults_Date#dateformat(Now(),'dd-mm-yyy')#_Time#Timefo rmat(Now(),'hhm msstt')#.xls CFFILE action=WRITE output=#mynewxlsfile# File=d:\somedir\#FileToWrite# nameconflict=OVERWRITE /CFOUTPUT HTH DavidB -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:05 AM To: CF-Talk Subject: RE: query output to Excel file What's the code look like for pushing an ordinary html table as a file with an .xls extention using cfcontent? Can you give an example for us? Rick -Original Message- From: Chris Stoner [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 4:37 PM To: CF-Talk Subject: Re: query output to Excel file push an ordinary html table as a file with an .xls extention using cfcontent. - Original Message - From: Petr Kysela [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~ | Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 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 ~ | Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: query output to Excel file
Thank, Pascal... Rick -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:16 AM To: CF-Talk Subject: RE: query output to Excel file cfcontent type=application/msexcel cfheader name=Content-Disposition value=attachment; filename=#attributes.name##.xls cfoutput table border=1 tr thOrganisation/th thName OCP/th thActivity/th thType/th thGeoscope/th thRegiser date/th /tr cfloop query=qOrg tr valign=top td#qORG.ORG_NAME#/td td#qORG.USR_LASTNAME#, #qOrg.USR_FIRSTNAME#/td td#qORG.ORG_ACTIVITY#/td td#qORG.ORG_TYPE#/td td#qOrg.GEOSCOPE_NAME#/td td#qOrg.ORG_REGISTER_DATE#/td /tr /cfloop /table /cfoutput cfabort -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: donderdag 11 september 2003 16:05 To: CF-Talk Subject: RE: query output to Excel file What's the code look like for pushing an ordinary html table as a file with an .xls extention using cfcontent? Can you give an example for us? Rick ~ | Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: query output to Excel file
If you do the same for word, it will work with Word 2000+ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: donderdag 11 september 2003 16:59 To: CF-Talk Subject: RE: query output to Excel file Thanks, David... Rick Anything similar to save data/HTML to Word documents in a tab delimited format? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: query output to Excel file
Thanks, Pascal... Rick -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 11:05 AM To: CF-Talk Subject: RE: query output to Excel file If you do the same for word, it will work with Word 2000+ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: donderdag 11 september 2003 16:59 To: CF-Talk Subject: RE: query output to Excel file Thanks, David... Rick Anything similar to save data/HTML to Word documents in a tab delimited format? ~ | Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: query output to Excel file
id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: query output to Excel file
We simply use cfsavecontent as HTML and let Excel convert it. -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:45 To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: query output to Excel file
You can just save it in csv format but with a .xls extension, it works, Excel opens them up np. -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:45 To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: query output to Excel file
neil. what do you put in the cfsavecontent? the query object or some sort of outputted formatted data? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file We simply use cfsavecontent as HTML and let Excel convert it. -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:45 To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: query output to Excel file
Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: query output to Excel file
Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: query output to Excel file
trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: query output to Excel file
Well, for the moment is pretty ugly, but it workswe just output HTML outputted content from a cfloop. Works ok for thousands of records. no complaints so far and no issues with timeout. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:59 To: CF-Talk Subject: RE: query output to Excel file neil. what do you put in the cfsavecontent? the query object or some sort of outputted formatted data? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file We simply use cfsavecontent as HTML and let Excel convert it. -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:45 To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: query output to Excel file
im good on dts, that's cool, just never considered that as an option...too many options too many things to code, cant think of 'em all...thats what I have cftalk :) all these good ideas... tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: query output to Excel file
interesting... may have to try that as an avenue ;) thanks! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:59 AM To: CF-Talk Subject: Re: query output to Excel file Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: query output to Excel file
STORED PROCEDURE -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:13 To: CF-Talk Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: query output to Excel file
The problem you will have about the excel file is that it usually writes to the SQL server local dir. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:09 To: CF-Talk Subject: RE: query output to Excel file interesting... may have to try that as an avenue ;) thanks! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:59 AM To: CF-Talk Subject: Re: query output to Excel file Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: query output to Excel file
You can point to any excel file that the SQL Server can see. I can pump a DTS export to any excel file on our network. Clint Robertson-Ravo, Neil (RX) wrote: The problem you will have about the excel file is that it usually writes to the SQL server local dir. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:09 To: CF-Talk Subject: RE: query output to Excel file interesting... may have to try that as an avenue ;) thanks! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:59 AM To: CF-Talk Subject: Re: query output to Excel file Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: query output to Excel file
Tony, You can do anything you need to do in the cf template, writing it out as you would normal html. Excel can open an html file (formatted like a table) and it will function exactly like excel. The following code will trick the browser into thinking it's dealing with excel: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=sample.xls CFCONTENT TYPE=application/excel If you're going to email the file to someone, I would think that you could use cffile to write the content (using cfsavecontent to build the page). -Deanna - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:13 AM Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: query output to Excel file
'xplainplease. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:40 AM To: CF-Talk Subject: RE: query output to Excel file STORED PROCEDURE -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:13 To: CF-Talk Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: query output to Excel file
you would first create it in the sql server, then you can actually kickstart it using that weird string it creates to reference itself... the one that looks like this... EXECUTE master.dbo.xp_sqlmaint N'-PlanID A173BEC9-1178-4B2D-91A4-5ED8B2DCB2B8 -To Admin EMail -VrfyBackup -BkUpMedia DISK -BkUpLog H:\transactionLogBackup -DelBkUps 3HOURS -BkExt TRN' I think. I know someone talked about it at some point on here...but that's a way to do it, I think. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:33 AM To: CF-Talk Subject: query output to Excel file What is a DTS export? Is it something that can be kicked off by cf, or is it just a manual export? Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: query output to Excel file
but I could in the same light, write the data as comma delimited inside a cfsavecontent? and then from there...dump the data in the cfsavecontent into the cffile, as one file system hit? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:34 AM To: CF-Talk Subject: Re: query output to Excel file Tony, You can do anything you need to do in the cf template, writing it out as you would normal html. Excel can open an html file (formatted like a table) and it will function exactly like excel. The following code will trick the browser into thinking it's dealing with excel: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=sample.xls CFCONTENT TYPE=application/excel If you're going to email the file to someone, I would think that you could use cffile to write the content (using cfsavecontent to build the page). -Deanna - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:13 AM Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: query output to Excel file
Yep, but I've found it's easier to format it in HTML. You can do some funky things - like using Excels native number formats (in other words, getting a number that starts with a zero to show the zero in excel), highlighting various columns, etc. It depends on what you need to do. -d - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:55 AM Subject: RE: query output to Excel file but I could in the same light, write the data as comma delimited inside a cfsavecontent? and then from there...dump the data in the cfsavecontent into the cffile, as one file system hit? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:34 AM To: CF-Talk Subject: Re: query output to Excel file Tony, You can do anything you need to do in the cf template, writing it out as you would normal html. Excel can open an html file (formatted like a table) and it will function exactly like excel. The following code will trick the browser into thinking it's dealing with excel: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=sample.xls CFCONTENT TYPE=application/excel If you're going to email the file to someone, I would think that you could use cffile to write the content (using cfsavecontent to build the page). -Deanna - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:13 AM Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: query output to Excel file
Tony, Alternatively, just append the data to a variable as you are looping through with commas as delimiters etc. and then write the variable to the file when you are done. André -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:55 To: CF-Talk Subject: RE: query output to Excel file but I could in the same light, write the data as comma delimited inside a cfsavecontent? and then from there...dump the data in the cfsavecontent into the cffile, as one file system hit? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:34 AM To: CF-Talk Subject: Re: query output to Excel file Tony, You can do anything you need to do in the cf template, writing it out as you would normal html. Excel can open an html file (formatted like a table) and it will function exactly like excel. The following code will trick the browser into thinking it's dealing with excel: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=sample.xls CFCONTENT TYPE=application/excel If you're going to email the file to someone, I would think that you could use cffile to write the content (using cfsavecontent to build the page). -Deanna - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:13 AM Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: query output to Excel file
Its a procedure which is internal to SQL Server. It can be kicked off from CF. -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:33 To: CF-Talk Subject: query output to Excel file What is a DTS export? Is it something that can be kicked off by cf, or is it just a manual export? Assuming SQL Server, the easiest way would be to do a DTS export directly an excel file. If you are not using SQL Server, then there really isn't an easy way. Clint ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: query output to Excel file
You can also send email and attachments through DTS using CDONTS. And you can manipulate Excel files through DTS using ActiveX Script Task. You can then schedule your package through SQL Server Jobs or you can call it manually through COM (check out cfcomet.com for more details). Mark -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:13 AM To: CF-Talk Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: query output to Excel file
which is what cfsavecontent does, right? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 12:53 PM To: CF-Talk Subject: RE: query output to Excel file Tony, Alternatively, just append the data to a variable as you are looping through with commas as delimiters etc. and then write the variable to the file when you are done. André -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:55 To: CF-Talk Subject: RE: query output to Excel file but I could in the same light, write the data as comma delimited inside a cfsavecontent? and then from there...dump the data in the cfsavecontent into the cffile, as one file system hit? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:34 AM To: CF-Talk Subject: Re: query output to Excel file Tony, You can do anything you need to do in the cf template, writing it out as you would normal html. Excel can open an html file (formatted like a table) and it will function exactly like excel. The following code will trick the browser into thinking it's dealing with excel: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=sample.xls CFCONTENT TYPE=application/excel If you're going to email the file to someone, I would think that you could use cffile to write the content (using cfsavecontent to build the page). -Deanna - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:13 AM Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: query output to Excel file
push an ordinary html table as a file with an .xls extention using cfcontent. - Original Message - From: Petr Kysela [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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