Using xlsgen to manage situation very similar to yours. Has worked very well on a variety of projects.
Website is at http://xlsgen.arstdesign.com/ Andrew ---------------------------------------- From: "etmilis" <[email protected]> Sent: Monday, 21 February 2011 3:02 PM To: "ozDotNet" <[email protected]> Subject: RE: Excel in .NET (C# or VB) Thanks Craig and Arjang, Concern noted. We are asked to automate/integrate files (i.e. invoice, inventory, etc.) received from customer (in Excel via email) with internal system and need to update some databases/tables too. We will also need to send back the updated Excel file (original file + added/updated columns) to the customers. It looks like there are 2 ways to do it, using the Excel object model or the OLEDB, though I am leaning more to the object model. So, is it a good design if we create a service or a .net assembly with scheduled job to it? The frequency is pretty low, a few times in a day during business hours only. Cheers, Etmilis -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Arjang Assadi Sent: Monday, 21 February 2011 3:37 PM To: ozDotNet Subject: Re: Excel in .NET (C# or VB) Hi Etmilis, as Craig said ( also from personal experience ), do not try reading and writing excel files on the server, there is no end to problems that need to be solved. What is the original problem that you think it requires reading and writing to Excel Files? Regards Arjang On 21 February 2011 15:10, etmilis <[email protected]> wrote: > Hi Everyone, > > In the current DNA with .NET, is it much easier now to deal with EXCEL? > Is COM still in the game? > > What I am after is reading from and writing to an EXCEL file(s). > Also will it be possible to do it without installing EXCEL at all, for > example just referencing some of the EXCEL assemblies??? > > Thanks and Regards, > Etmilis > >
