Export to excel then Email

[reynoje]

I have an survey application where I want users to be able to click on a link
and a slice of data (the survey results for that survey instance) will be
exported to an Excel file with a unique name. But instead of returning the
file to the user I want it to be e-mailed to a document storage application.

If I use CFContent to create the file it's returned to the user for download.
And CFFile is only good for text files, not Excel. How do I create this excel
file on the server?

[philh]

When you serve Excel-ready content to the browser, it's not really Excel; it's
comma- or tab-delimited information. With CFCONTENT, you just tell the client
to use Excel to open the returned stream. Using CFFILE, If you name the
created text file with a CSV extension, most Excel users have that MIME type
mapped to the Excel application, and should be able to open it without
difficulty. If you're using some other voodoo to actually create a native
Excel document for the CFCONTENT return (hard to tell because you didn't
provide code), then I'm not sure how to proceed.

[uchil]

I use something similar to this, and this forces the user to download
the file as a Excel file (as long as they have the default MIME setting
of Excel for CSV files)

copied this eample from
[url]http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20701038.html[/url]
Hope this helps.

<CFSETTING ENABLECFOUTPUTONLY="yes">

<CFSET TAB=CHR(9)>

<CFQUERY NAME="get_Data" DATASOURCE="Deg">
SELECT username,EMail,
FROM Tbl_Data
</CFQUERY>

<CFHEADER NAME="Content-Disposition" VALUE="inline;
filename=export.xls">
<CFCONTENT TYPE="application/msexcel">

<CFOUTPUT QUERY="get_Data">
#Currentrow##TAB##username##TAB##EMail##chr(13)#
</CFOUTPUT>