CODEWITHSUNDEEP
c#excel
sikas
sikas

Reputation: 5523

Managing Excel via C#

Ok, here is what I'm looking for. I'm developing an application that will be dealing with Excel files ONLY (.xls mainly but might be upgraded to .xlsx) ... For now, I'm looking to deal with 2003.

In my application, I have an "Open" btn that the user clicks and locates the file. I have done this.

But know, I don't know how to deal with the file after I located it. I want to delete some rows/columns as a beginning, then I want to do some sorts and calculations. If anyone can just put me on the road, I believe I can run through it then :)

Thanks in advance :)

Upvotes: 0

Views: 317

Answers (4)

user287107
user287107

Reputation: 9417

if you are just using office 2007, you can use http://epplus.codeplex.com

Upvotes: 0

Antonio Bakula
Antonio Bakula

Reputation: 20693

For excel 2003 and earlier versions (xls) you can use NPOI, it's open soruce and works well, here are some examples to get you started :

http://www.leniel.net/2009/07/creating-excel-spreadsheets-xls-xlsx-c.html

Upvotes: 1

user1096188
user1096188

Reputation: 1839

You can use Microsoft.Jet.OLEDB.4.0 driver to work with xls files. See this question, for example.

Upvotes: 0

iamkrillin
iamkrillin

Reputation: 6876

When dealing with excel, there are bascially two options

1) The office interop assemblies Here is an article on MSDN
2) A fully manged library of some sort. (Search on codeplex/google or similar)

Here is a similar question on SO read write excel file on server

Upvotes: 1

Related Questions