C# working with excel

Question

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?

Joseph Barnes · Answer

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 .

George eric · Answer

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.

Mahesh Chand · Answer

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/ G ood luck!