I have an excel something like the belwo where the months are dynamic and they get created by the start date. This data isnt structured well & I was not able to read the months and get their range. Is there way on how to get the range of the months that are present in the excel and read the data below the last month in the excel?
Book1.xlsx (11.0 KB)
You can read the range by simply specifying it in the Read Range activity properties like that:
B3:S7
This should only read the wanted range directly to your data table 
Hi @Sri_harsha_Bhasuru, since your months are dynamic, your starting point of the table is same. You could use “B3” as range.
Yeah that was perfect, would I get the last month excel reference like for May-18 it should get S3 and for another year it could be AA3
As long as its linked and a table structure is there, it should be able to
Cheers.
prashant1603765
yedukondaluaregala
V_Roboto_V
sharazkm32
Aki1111
cristian_camilo_gonzalez
mively
ashokkarale
sonaliaggarwal47
postwick