Reputation: 1879

Reading Excel Cells using C#

What's the way to open a excel workbook and to read excel cells?

Upvotes: 4

Answers (4)

Ryan

Reputation: 8005

There is an open source .NET library called Koogra for reading Excel files, both BIFF (older Excel) and XSLX (newer Excel). Otherwise you can use Excel automation, but I would avoid that if possible.

Upvotes: 1

Jelle

Reputation: 322

You can also use open xml sdk to read (and write) excel files (in open xml format off course). There is an msdn article describing how to use the open xml sdk.

A big advantage is that you don't have to install excel on the server (or client) to read excel files.

Upvotes: 0

malay

Reputation: 1452

In this thread you will get details how to open and handle excel through C#.

Upvotes: 3

RaYell

Reputation: 70404

Use Visual Studio Tools for Office (VSTO) to extend Office products with your code and here's a good tutorial to get you started in Excel programming

Upvotes: 4

Reading Excel Cells using C#

Answers (4)

Related Questions