Yes, that is a great idea. I used a similar idea for RTF files a while back - save a Word RTF file as a template with place-holder strings. When I need to fill in real data, I open the RTF as a plain text file, and search for the place holder strings and replace them with real data, and delivery this RTF file to user's browser.
The Excel idea from Henry is not so straight forward as the RTF one... The limitation for both RTF and Excel/HTML is, one can handle 10 reports in this way, not 100 reports...that's why we are using Actuate e-Report now... Jeff -----Original Message----- From: Dtsig [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 11:34 AM To: JDJList Subject: [jdjlist] Re: Excel File Download Hello Henry, I have to say .. that was a brilliant suggestion. No matter what our area we do seem to miss the easy solutions like the on you proposed. <g> Great job Thursday, May 30, 2002, 12:42:56 PM, you wrote: HM> If you have a recent version of Excel (2000 or later), create a HM> spreadsheet in the format you desire. Save it as a web page. HM> Open it as text, and you'll see that you have an html page template. HM> Recreate the document with your data in the table, and send that to the HM> customer. HM> (Make sure you set the content-type to "application/msexcel") HM> Henry Martin HM> On Thursday, May 30, 2002, at 11:23 AM, Nahid, Nazneen (CORP, HM> Consultant) wrote: >> Hi Everybody, >> >> >> Problem - Client wants to export the data from a web in an excel file. >> When he downloads the excel file, he wants the cells of the excel file >> to >> have the format not as "General ", but to have the >> format as "Currency", "number" etc. >> >> I know how to download the excel file as "CSV", but give each column of >> the >> cell a format as "Number" ? >> >> We also have the solution that download the exel and let the user run a >> macro? >> But this is not favoured by the client ? >> >> Any ideas/Solution? >> >> Thanks >> Nazneen >> >> >> >> >> To change your membership options, refer to: >> http://www.sys-con.com/java/list.cfm HM> To change your membership options, refer to: HM> http://www.sys-con.com/java/list.cfm -- Best regards, Dtsig mailto:[EMAIL PROTECTED] To change your membership options, refer to: http://www.sys-con.com/java/list.cfm To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
