[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Excel 2007

Posted on 2009-05-16
8
Medium Priority
?
170 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
Independent Software Vendors: 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Suggested Courses

650 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