You can read whole sheet giving range as A1 and then use remove data row to remove all the rows not needed
Else try giving only the frist cell as A5275 and check that should read data till last in read range
If you are getting blank rows at end then use filter datatable
Cheers