4

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

Improve this question

4 Answers 4

Reset to default
4

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

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

Comments

3

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

Improve this answer

2 Comments

Maybe you could tell us which part of that thread? We don't really like link only answers here and prefer your post to be able to stand on its own and where you provide the link for reference. Thanks.
Link is dead - another reason this type of answer is not useful.
1

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.

Improve this answer

Comments

0

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.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.