How to get the range of a sheet dynamically

I have an excel file which can vary in its amount of data, what happens is that I must create a table with the data that the file currently has (but this should work dynamically), according to the Create Table activity, I must specify the range But as I mentioned, I need this to work dynamically, how can I have 10 data, other times I can have 1300. How can I do this?

image

Use Read Range Activity. If Range is null among input parameters, all data is read dynamically.
If you have any further questions about working with Excel, please reply. We will be happy to reply.

1 Like