I have a huge excel file(s) with different sheets. Since the next sheets and next files can look slightly different from each other there is a common header in each file to find the correct column. So I only get the information in which row the common header is (e.g. row 50 in the example below).
So the task is to look for the Value NPP and get the column index. Once I have the column index I can get the row index for a string that starts with “D.” (see below). But I dont know how to get the column index.
Obviously the value NPP or the other values like MPP can be in different columns.
Can anyone please help ? I’ve read a lot of topics but can’t get it done.