Hi everyone
I’m trying to get a full table from excel but I don’t know where it starts.
It can start in the A column, but also the B column, and also in the second or third row…
I tried the “read range” inside an “Excel Application Scope” but it gave me the first row that doesn’t have any data in it
Example:
it is like this (“”)
and it takes the first rows and columns as well.
I tried once with the actual range (I inserted the starting cell in this example: “B3”) and it took the Exact table!! (can’t put in the range for permanent use because I don’t know if it will stay always the same)
Well if you can’t know where the table starts, the better you can do is retrieve the entire table (with the first row header option unchecked) and after it, put an filter datatable activity for remove all the “empty” rows.
For the automation purpose, it’s a must to have the same data structure for each file, but if you can’t, you have to handle it manually. The read range activity is not magic and can’t decide if this row is usefull for you, it just retrieve the data you asked to retrieve