Hi, I’ve an excel with 10 rows but all the 10 rows does not have the data. In between I may have empty rows. When I tried to read this row using “read Column” activity, tool reads only first consecutive rows and not reading the rows after the the empty row. Can someone help me to solve this issue ?
In below example, excel read column reads only 2 and 3.
Example Excel column:
2
3
4
5
6
7
8