Hey @bk ,
The below logic might help :
- Get the overall row count of the excel sheet :
https://learn.microsoft.com/en-us/answers/questions/35029/how-to-get-row-counts-from-files-stored-in-azure-s.html
2) Then via Range parameter in excel dataset :
rownbr-1
That should help you to skip the last row and the column range would still be dynamic