scampercat

scampercat

  • NA
  • 189
  • 0

C# working with excel

Mar 21 2012 12:23 PM
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?

Answers (3)