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.
Cheers,
Shikhar
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?
Anil_G
Yoichi
ashokkarale
sven.wullum1
Jon_Smith
bart.wille
indra
sallavudeen_ashwin
gustavo.cervelin
Sanjay_Bhat