Hello guys, i have found a strange bug in Read Range activity.
I have an Excel with the same data in two sheets, but the position of data is difference. “Sheet1” start at “F11”, “Sheet2” start at “B2”.
data row 1: |a|b|c|
data row 2: |d|e|f|
When I use Read Range activity to extract data from “Sheet1” and the start range is “F11”, it returns a datatable with only one header, and no Row data:
I do the same with “Sheet2”
But I move the data to another position and start range is “B2” and it works fine, full data in that sheet are extracted.
The problem is that, whenever I move the data to far from “A1”, “F11” for ex, it cant read all the data.
Is there any solutions for this.