Excel 2007

I want to be able to read and get header of each column in Excel 2007?
VBdotnet2005Asked:
Who is Participating?
 
CodeCruiserCommented:
What do you mean by headers? The default A1, A2, B1, B2... headers? or custom headers?
0
 
VBdotnet2005Author Commented:
yes
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
CodeCruiserCommented:
Are you using OLEDB or Office Interop?
0
 
VBdotnet2005Author Commented:
I am using Office Interop
0
 
CodeCruiserCommented:
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
 
VBdotnet2005Author Commented:
I want to know for example, I want to check to see if "Account", "Customer" exist
0
 
CodeCruiserCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.