Basically I have an Excel with column headers that have the filter function enabled so that the Excel can be sorted and viewed more easily.
I’m using the Excel application scope to import the excel into a DataTable with the read range and then trying to get a value from one of the columns. However I can’t seem to get the right header name to use because the program always crashes with (Column “header name” does not belong to DataTable)
Here is the Column for example I’m trying to get in the Excel/Datatable (“Document Date” for example)
and here is what I am using to try and get the value
Dt.Rows(0).Item(“DOCUMENT DATE DD.MM.YYYY Date(10)”).ToString
I can get the values from column headers that do not have the filter function enabled so I’m wondering what can I do to be able to make the filtered column headers work? Any help is appreciated thanks!