As you know, we're at war. Specifically, the war between non-developers, who see fit to put even vaguely tabular data into Excel spreadsheets regardless of whether or not using a spreadsheet makes sense, and us developers, who use excellent tools such as ExcelDataReader to free essential data from these spreadsheets and continue on our day. The non-developers are thinking up new ways every day to make this task more difficult for us, and thus I would like to request a feature to close one of these loopholes.

OK, joking aside, I have a real spreadsheet that is presenting some issues since it has multiple header rows. I can point EDR to the last header row, but some of the columns have the same name if you only look at that row making it difficult to tell them apart (another weapon the non-developers use is reordering columns in seemingly random order, so I don't want to have to rely on that).

Here is an example to show what I am talking about:

+---------------+---------------+
|    Group 1    |    Group 2    |
+-------+-------+-------+-------+
| Col 1 | Col 2 | Col 1 | Col 2 |
+-------+-------+-------+-------+

There are four columns but there are overlapping names if I just use the second header row. I want to be able to also include the first to differentiate between all columns.

For example if this feature were added, if I check the column name of the first column from my code I might see something like "Group 1 Col 1".