Using cffile to write out the information table you built up.:
Ie build up the table with <cfsavecontent /> or build up a tab delimited
string. Then use
<cffile action="write" file="#expandpath('.')#\file.xls"
output="#someExcelContent#" />
I recently did this with Flex as the front end and can be seen here:
http://blog.kukiel.net/2009/01/flex-datagrids-and-excel-part-2.html
By simply changing the server side .cfm file to:
<cffile action="write" file="#expandpath('.')#\file.xls"
output="#form.htmltable#" />
I can write files out that excel will read. In this example I have used TAB
delimited strings but HTML output works the same way.
Paul.
-----Original Message-----
From: Imperial, Robert [mailto:[email protected]]
Sent: Thursday, 8 January 2009 8:42 AM
To: cf-newbie
Subject: RE: How would I write and save xls files?
Sorry for the typo, no coffee yet this morning :)
What I meant to type was, I've been creating an excel file using the
following:
Off to the coffee pot:
-----Original Message-----
From: Imperial, Robert [mailto:[email protected]]
Sent: Thursday, January 08, 2009 8:39 AM
To: cf-newbie
Subject: How would I write and save xls files?
Hi folks,
I've been creating an files using the following:
<cfheader name="Content-Disposition"
value="filename=Current_#ThisFile#.xls" />
<cfcontent type="application/msexcel" />
Outputting the contents of this file in a table for downloading. This
works fine and now I need to write or save this file to the server so I
can send it as an email attachment. Does anybody out there know of
simple tutorial or walkthrough on how to accomplish this?
I am on IIS6 + CF 7,0,2,142559
TIA
Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4273
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
