I have a spreadsheet that has a named range that I would like to import and turn into a data table. For example:
Id First Last
1 John Hennesey
2 Chad Huelsman
The named range (“Names”) encompases the first row (Id, First, Last) to the last row (2, Chad, Huelsman).
I am able to get the data using the WorkbookDesigner.Worksheets.GetRangeByName(“Names”) method, but when I try WorkbookDesigner.Worksheets.GetRangeByNames(“Names”).ExportDataTable() it doesn’t recognize the first row is column names.
I don’t see any kind of a parameter to say first row is column names - is there a better way?
p.s. I am using the .net version.