I have a little problem and I hope you can help me out. I have an excel file which has no headers so the data I need begin at row 7, row 1 is empty in most of the columns. With the Read Range activity you have the option to tick the checkbox “AddHeaders”. Now I want to know what header there is if I add one with the checkbox. How can I address the column in that way?
Alternatively: Use ReadRange activity with Range = “A7” (assuming your data start from column A, row 7)
If AddHeaders = true the first row in the range will be treated a header row and columns will be named according first row content
If AddHeaders = false columns will be named Column1, Column2…