Reading and parsing Excel files in C#

Question

What is the best way/library to read Excel 2003 and 2007 files using C#? I need to do some heavy parsing.

See this question; stackoverflow.com/questions/15828/reading-excel-files-from-c — Chris McAtackney
– Chris McAtackney, Commented Jun 23, 2010 at 15:45
What do you mean by "heavy parsing"? Can you provide some example? — Fredrik Mörk
– Fredrik Mörk, Commented Jun 23, 2010 at 15:45

Randolpho · Accepted Answer · 2010-06-23 15:49:03Z

2

Do you need to parse the file, or deal with the contents?

For parsing the file, you'd better hope it's in Open Office XML format, because the previous binary version is not documented at all.

If you just need to deal with the contents, use the Office Interop libraries.

answered Jun 23, 2010 at 15:49

Randolpho

56.5k18 gold badges153 silver badges182 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

liya · Accepted Answer · 2010-06-23 23:28:54Z

1

You can try SmartXLS for .Net,it support most features of excel(cell formatting,Charts,formulas,pivot tables etc),and can read/write both the excel97-2003 xls format and the excel2007 openxml format.

answered Jun 23, 2010 at 23:28

liya

7925 silver badges6 bronze badges

Comments

Anthony · Accepted Answer · 2010-06-23 15:56:00Z

1

I would start by trying to use ADO.NET. If that doesn't work, I used xlsio by Syncfusion.

answered Jun 23, 2010 at 15:56

Anthony

1,7191 gold badge20 silver badges33 bronze badges

Comments

Hans Olsson · Accepted Answer · 2010-06-23 16:07:38Z

1

If the data is in some kind of table format I'd suggest to try using OleDbConnection and treating the Excel sheet as another data connection. Otherwise Interop is ok if it's not on a server or anything like that.

answered Jun 23, 2010 at 16:07

Hans Olsson

55.1k16 gold badges99 silver badges118 bronze badges

Comments

Glorfindel · Accepted Answer · 2022-10-17 08:13:20Z

1

You can use the MS Office interop assemblies (see here) to access Excel files from .NET applications.

edited Oct 17, 2022 at 8:13

Glorfindel

22.8k13 gold badges97 silver badges124 bronze badges

answered Jun 23, 2010 at 15:45

TLiebe

8,0261 gold badge25 silver badges29 bronze badges

Comments

Ocelot20 · Accepted Answer · 2010-06-23 15:46:23Z

-1

There are a number of 3rd party tools you can use. I would avoid using the Interop libraries as they can be pretty slow. I have used Aspose.Cells before and it works pretty well. It does cost some money though.

answered Jun 23, 2010 at 15:46

Ocelot20

10.9k11 gold badges57 silver badges98 bronze badges

Collectives™ on Stack Overflow

Reading and parsing Excel files in C#

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related