I am receiving an xlsx-File from another application. It contains a header line with filters set starting in row 3, followed by the actual data from row 4 onwards, like this:
When reading it with workbook read range, it is not able to correctly read the headers, neither with option ‘addHeaders’ set nor without. It does not matter from which row on I read the data, the resulting datatable always looks like this, with generic header names like column1, column2 …:
If I let him start to read from row 2 on it looks even weirder, he adds the header row twice:
Only when I manually remove the filters from the excel file and copy data+header to a new blank workbook, read range is able to correctly read it to a datatable.
Excel read range does it correctly out of the box, but excel is not installed on the system the robot is designated to run. To me it looks like a bug. Any idea on how to solve this, i.e. read the correct values from row 3 instead of generic header names?