Cheers Matt, Yep, I have tried this but with over 2,500 lines of code it can crash Excel by hanging it. I am thinking I will just save out the table of data to a txt file and then get it to be imported into Excel like Steve uses.
-----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED]] Sent: 04 February 2003 15:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Suggestions export to Excel bung this in the top of your report page <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] -- ** 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]
