I am facing an issue with read range activity of excel.
- In read range activity i am giving the range value as “A2” because i want the bot to ignore the first row because it contains column headings.
there is a sheet in excel called “Sheet1” containing four rows .the count method of data table works fine in this case. However if i create a replica of “Sheet1” and only copy the first row which contains column headings .the count method return 1 as output which ideally should not happen because we are reading from “A2” cell.
Can someone suggest a reason for the same.
Thanks in advance