Begin with C# Excel- How to control Excel in C#.NET

Question

hi, all.  I am just begining in C#.NET platform and Excel. Right now, i am trying to figure out what is Office.Interop.And wish to know more knowledge about this field.  Like some tutorial for a Beginner,  or skills that usually used.  Can anybody provide some helpful resource?

Answer 1

http://www.codeproject.com/Articles/5123/Opening-and-Navigating-Excel-with-C

http://www.codeproject.com/Articles/18196/Excel-Charts-in-C-Applications

for example ...

Answer 2

Hi, Office.interop.excel is one way to work with workbook, there is other ways to edit Excel workbook, check this summary   http://paradise4csharp.wordpress.com/2012/04/18/three-ways-to-operate-excel-workbook-via-c/

 And there is also some skill always used to control Excel:

Answer 3

Thank you, cathrin. I like the chart articles and its source code.

Regards

Pandvi

Answer 4

Hi Green,

Thanks. What if I wish to use OleBD,  where can i find some best resource, as you and cathrin introduced the same way office.interop.excel.

Regards

Pandvi

Answer 5

Hi Green,

Thanks. What if I wish to use OleBD,  where can i find some best resource, as you and cathrin introduced the same way office.interop.excel.

Regards

Pandvi

http://www.connectionstrings.com/excel

Answer 6

Good link +1,  Refer to  cathrin's link.