VBdotnet2005
asked on
Excel 2007
I want to be able to read and get header of each column in Excel 2007?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What do you mean by headers? The default A1, A2, B1, B2... headers? or custom headers?
ASKER
yes
Are you using OLEDB or Office Interop?
ASKER
I am using Office Interop
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?
ASKER
I want to know for example, I want to check to see if "Account", "Customer" exist
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.