<CFIF isdefined("form.submitit")>
<CFHEADER name="Content-Disposition" value="Filename=Foo#rand()#z.xls">
<CFCONTENT type="application/vnd.ms-excel">
</CFIF>
<FORM name="Test" method="post" action="MyPage.cfm">
<INPUT type="hidden" name="submitit">
<INPUT type="submit" value="Excel ">
</FORM>
where Mypage.cfm is the report page
At 15:27 04/02/2003 +0000, you wrote:
in fact it appears that by saving the HTML, Excel can in fact import the data......cracking, but is this advisable...-----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 04 February 2003 15:26 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] Suggestions OK, I need suggestions.......(on CF45). I have a report which is being generated via a CT which calls the DB and then builds the HTML table - 2.5K rows (and modifies some data results via CFML), I now need to get the table as an end-result (i.e. variables changed depending on values/parameters) into either an Excel or Text file..... I am at a roadblock as far as the next step.. Anyone got the best idea/approach to this before I simply leave and get drunk..... N -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
