----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Soumitra2105 Message 4 in Discussion Hi TPB, Well this is becoming a popular issue. I was thinking maybe I should make a presnetation or something. Well my experience on the same has been quite interesting. Server Side Well the Excel Object model is pretty good. On the server side you can use the approach very easily Take reference of Excel objects using the PIA Assemblies for Office. Avialable at Microsoft site. Keep a template dir\template1.xls Copy the file to a temp output dir/ or into a temp mem file Write the data from the dataset into the file using the object model. Stream the file back to the client This approach works like clockwork except one big hitch The Excel Object does not get released. I have seen people try almost everything to get this working but till no one has been able to make it work consistently till now. This happens because of the Interop between COM and .Net. Client Side Approach. This genuinely sounds like a great idea. Take the data to the client side and work separate the work out completely. I am not sure how the template is going to be taken to the client but recently we had a informative lecture on 'Isolated Storage' which you might be able to use. It will also get rid of the excel object release issue. Though the only drawback maybe in terms of parsing XML on the client side as I am not sure they will support the dataset operations. Hope this helps Best Regards, Soumitra -----Original Message----- From: BDOTNET [mailto:[EMAIL PROTECTED] Sent: Sunday, February 01, 2004 8:08 PM To: BDOTNET Subject: Sending data from webserver to excel file on client machine New Message on BDOTNET Sending data from webserver to excel file on client machine Reply Recommend Message 1 in Discussion From: Thepelicanbrief2 Hi Group, I have a functionality to implement. I have some data in the dataset which is to be put into a excel file in a pre-defined format. Since the format is predefined, I have a template excel file on the web server. Now the requirement is - 1) First the template excel file should go on the client side. 2) then the data from the dataset should go to the client side and 3) This template excel file at the client side should get filled with the data. Is this a good idea to generate the excel file at client side using javascript or vbscript (basically using CreateObject("Excel.Application")) Now I have some questions. Would it be better if I generate the excel file at the web server. Which one is preferred? Security of data is not an issue. But there are many such excel files getting generated ... around 100 excel files per day with around 500 rows in each file and 10 columns. Please suggest some good design for this problem. I also would like to know whether server side processing is better or client side processing is good - or it depends upon situation to situation. Any links on this? Thanks and regards, TPB View other groups in this category. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
