I don’t know if you are aware of this issue but I’ve noticed that we have a problem when reading excel files with the AddHeaders option set to true in Read Range activity. When this option is set it is supposed to consider the first row as the header, and it does happen when the excel file has content. But when it doesn’t the header turns into a new row and this makes necessary for us to handle this issue so we don’t get an error saying that some column doesn’t exist, since the DataTable, in this case, will have only one column “Column1”.
Working a little bit more over this issue I realized with my team that the problem is related to the cell borders. In the Sample you will be able to see that when the rows have no borders, it considers the header as a row.
I am facing an issue with Excel Read Range Activity. That is my excel workbook had two worksheets i.e., sheet1 and sheet2 am trying to read both sheets headers and write it to an other workbook. So the bot is considering only first sheet headers but it is not considering the second sheet header. Can you please help me.