----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Soumitra2105 Message 5 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 ----------------------------------------------------------- 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]
