Re: Excel in .NET (C# or VB)

2011-02-21 Thread Nathan Schultz
u were just reading the file then nexcel is my preferred way and it >>> works on asp.net with no hassle. >>> >>> But as you are updating there isn't a simple solution at all. >>> >>> Davy >>> "When all you have is a hammer, every pro

Re: Excel in .NET (C# or VB)

2011-02-21 Thread noonie
gt;> >> -----Original Message- >> From: "etmilis" >> Sender: ozdotnet-boun...@ozdotnet.com >> Date: Mon, 21 Feb 2011 16:02:27 >> To: 'ozDotNet' >> Reply-To: ozDotNet >> Subject: RE: Excel in .NET (C# or VB) >> >> Thank

Re: Excel in .NET (C# or VB)

2011-02-21 Thread Nathan Schultz
ve is a hammer, every problem looks like a nail." I feel > much the same way about xml > > -Original Message- > From: "etmilis" > Sender: ozdotnet-boun...@ozdotnet.com > Date: Mon, 21 Feb 2011 16:02:27 > To: 'ozDotNet' > Reply-To: ozDotNet &g

Re: Excel in .NET (C# or VB)

2011-02-21 Thread Andrew McGrath
"ozDotNet" Subject: Re: Excel in .NET (C# or VB) On 21 February 2011 18:08, Andrew McGrath wrote: > 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 H

Re: Excel in .NET (C# or VB)

2011-02-21 Thread mike smith
On Tue, Feb 22, 2011 at 8:04 AM, Arjang Assadi wrote: > On 21 February 2011 18:08, Andrew McGrath > wrote: > > 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 > > Hi And

Re: Excel in .NET (C# or VB)

2011-02-21 Thread noonie
Arjang, Excel is a wonderful data analysis tool but it is an EVIL data manipulation tool. It takes liberties with any values entered into cells and makes assumptions based on some fairly opaque rules. it's not only Excel itself but users too, who can come in, after the fact and change data types

Re: Excel in .NET (C# or VB)

2011-02-21 Thread Arjang Assadi
On 21 February 2011 18:08, Andrew McGrath wrote: > 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 Hi Andrew, How did you manage the data validation? There is pretty much no way of

RE: Excel in .NET (C# or VB)

2011-02-21 Thread Ben.Robbins
ry 2011 4:04 PM To: djones...@gmail.com; ozDotNet Subject: Re: Excel in .NET (C# or VB) Another option is the OOXML SDK (see openxmldeveloper.org<http://www.openxmldeveloper.org/> and Microsoft's Open XML Developer Center<http://msdn.microsoft.com/en-us/office/bb265236&

Re: Excel in .NET (C# or VB)

2011-02-21 Thread Matt Siebert
ooks like a nail." I feel > much the same way about xml > > -Original Message- > From: "etmilis" > Sender: ozdotnet-boun...@ozdotnet.com > Date: Mon, 21 Feb 2011 16:02:27 > To: 'ozDotNet' > Reply-To: ozDotNet > Subject: RE: Excel in .

Re: Excel in .NET (C# or VB)

2011-02-20 Thread djones147
27; Reply-To: ozDotNet 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

RE: Excel in .NET (C# or VB)

2011-02-20 Thread Peter Maddin
er of options to try. Regards Peter. -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of etmilis Sent: Monday, 21 February 2011 12:11 PM To: 'ozDotNet' Subject: Excel in .NET (C# or VB) Importance: High Hi Everyone, In the c

RE: Excel in .NET (C# or VB)

2011-02-20 Thread Andrew McGrath
frequency is pretty low, a few times in a day during business hours only. Cheers, Etmilis -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Arjang Assadi Sent: Monday, 21 February 2011 3:37 PM To: ozDotNet Subject: Re: Excel in

RE: Excel in .NET (C# or VB)

2011-02-20 Thread etmilis
times in a day during business hours only. Cheers, Etmilis -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] 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

Re: Excel in .NET (C# or VB)

2011-02-20 Thread Arjang Assadi
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 2

Re: Excel in .NET (C# or VB)

2011-02-20 Thread Craig van Nieuwkerk
My preference is not to use Excel at all, especially if you are trying to perform this on a server. Try something like http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx Craig. O

Excel in .NET (C# or VB)

2011-02-20 Thread etmilis
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 assembl