TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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?
Reply
Answers (
3
)
Loop through for each key in Multi key dictionary
How to Play Youtube Videos on button click?