I have not tested this chunk, but this is the gist of what I was saying.
<cfsavecontent variable="strExcelData">
<table>
<tr>
<td>HEADER</td>
</tr>
<tr>
<td>ROW DATA</td>
</tr>
</table>
</cfsavecontent>
<!--- Create a temp file. --->
<cfset strTempFile = GetTempFile(
GetTempDirectory(),
"excel_data"
) />
<!--- Get xls file name. --->
<cfset strXlsFile = REReplace(
strTempFile,
"\.[a-z]+$",
".xls",
"ONE"
) />
<!--- Rename the file to be xls. --->
<cffile
action="RENAME"
source="#strTempFile#"
destination="#strXlsFile#"
/>
<!--- Write data to file. --->
<cffile
action="WRITE"
file="#strXlsFile#"
output="#strExcelData#"
/>
<!--- Send email NO SPOOLING. --->
<cfmail
to=""
from=""
subject=""
spoolenable="no">
Blam blam blam
<cfmailparam
file="#strXlsFile#"
/>
</cfmail>
<!--- Delete temp file. --->
<cffile
action="DELETE"
file="#strXlsFile#"
/>
......................
Ben Nadel
Certified Advanced ColdFusion Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
Never chase the paranoid schizophrenics.
-----Original Message-----
From: Gabrielle Mack [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 28, 2006 9:58 AM
To: CF-Talk
Subject: Re: ColdFusion and Microsoft Excel
Yep that helps! Both of these sound great, but i am not exactly sure on
how to go about coding this.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261881
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
