C# working with excel

scampercat

I am wondering how to accomplish the folowing goal using C#.net 2010 as a desktop/console application?
Basically I receive a workbook from my company's main customer to extract data from one of the tabs and load the data into sql server. I am told by my company that the way I obtain the data from the customer is going to stay the way it is and I need to work with the data in that format.
Basically the data comes in one of the middle tabs of the workbook. When I get to the tab I need to work with, I manually have to do the following:
1. unhide some columns,
2. remove links to external files
3. and possibly change the column headers.
Most of the time I just copy the data I need to a new worksheet in a new workbook.
Would you tell me or point me to a reference that will show me how to use a C#.net 2010 to accomplish this goal?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Joseph Barnes13y ago
Hi,
Easiest and fastest way to work with Excel files in C# is by some 3rd party component. For example take a look at this Excel Editor.
0
George eric14y ago
You can check this blog: http://blue20200.blog.com/2012/03/16/review-on-spire-xls-for-net-and-silverlight/. It may helps you a lot.
0
Mahesh Chand14y ago
Technically, you can do this in C# using Excel COM component. You can read the middle workbook tab by its index or name and then also read, show/hide columns and so on. Here are some articles you need to read and get yourself familiar with Excel COM Interop.

http://www.c-sharpcorner.com/1/146/

Good luck!
0