Finding a dynamic range in Excel

Can someone please tell me how to find the last row in Excel and then use that range in a read range activity? I have a file that always has a row with the value “period total:” in column L. The range I use for a DT will always end on the previous row. I need to use a dynamic range rather than the hardcoded one I currently have.


Hi @rgardner5564,

use Lookup Range activity and pass the header name from where you want to read the file the output u will get a range value then u can pass that range value to read range activity.

Thats it.


Hi Shikhar,

I am not able to find what you’re talking about for an activity. Would you mind putting together a .xaml example and sending it to me?