?
Solved

Excel 2007

Posted on 2009-05-16
8
Medium Priority
?
168 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 9

Accepted Solution

by:
cdaly33 earned 500 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

762 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