Solved

Excel 2007

Posted on 2009-05-16
8
161 Views
Last Modified: 2012-05-07
I want to be able to read and get header of each column in Excel 2007?
0
Comment
Question by:VBdotnet2005
  • 4
  • 3
8 Comments
 
LVL 9

Accepted Solution

by:
cdaly33 earned 125 total points
ID: 24407601
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24409641
What do you mean by headers? The default A1, A2, B1, B2... headers? or custom headers?
0
 

Author Comment

by:VBdotnet2005
ID: 24418424
yes
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24419280
Are you using OLEDB or Office Interop?
0
 

Author Comment

by:VBdotnet2005
ID: 24454933
I am using Office Interop
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24455009
Why do you need the headers then? I mean to read excel cells, you refer to them using the row and column headers dont you?
0
 

Author Comment

by:VBdotnet2005
ID: 24500050
I want to know for example, I want to check to see if "Account", "Customer" exist
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24501308
Would these headers be in fixed positions or variable? If variable, you can run a loop to check the value of each cell and match it to these words. I am assume you are currently able to get a value out of a cell.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question