I am using VB.net 2008 express edition
I have figured out how to use some of the code snippets for the open xml sdk to create a drop down list of all the sheets in an excel file.
I can also use the code snippet to get the value of an individual column header.
What I want is a drop down list of all column headers.
I could create an array containing the alphabet and loop through each column based on the alphabet letter in the array. I would then just exit the loop on the first column with no value returned for column header...but there must be an easy way to return all headers in one query of the xml.
any examples or suggestions would be apreciated.