How do I fill up the range field for the Read Range activity found under Office 365:
Could it not read the whole sheet. Because the number of rows increases day after day. I was hoping that it could do what the normal Workbook and Excel Modern activities can do, where you give the Sheet name and it would read the whole Excel. Is there any way we can get the last row for an online Excel? Thanks again.
you can give only sheetname as well it would read all data ideally
if its a table then you can give the table name as well
cheers
As per my experience, I won’t advise to read full sheet from online file as it would be too slow and could timeout easily.
For reading data operation only, you can download the file and use native excel activities to read range. This will be more faster and reliable approach.
