Reading Excel Cells using C#

What's the way 开发者_C百科to open a excel workbook and to read excel cells?

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

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

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.

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.