Import Excel - Import all ranges

1

Hi,
I need to import all ranges from an Excel Files. Is it possible to automatically import all ranges ? And not to have to pick them one by one ? My Excel files contains more than 1800 ranges names.

Thanks.
Nicolas

2

Hi Nicolas and welcome to the Community!

Yes, it is possible. You will need to use a loop, or as we call it, iterations. It works as follows:

  1. Create a module (A) that imports one range which name is specified using a parameter.
  2. Create another module (B) that lists all ranges using the “Excel command” action.
  3. Use the “Iterate” action in module B to run module A as many times as there are ranges. In each iteration, pass a range name to module A by assigning its parameter.

This topic has a bit more complex scenario than just loading multiple ranges, but it has detailed explanations and examples: Multiple files, small variation in sheet name, import with parameter

3

Hi Dimitri,

Thanks. I manage to do it with the “Excel Command” action.

Many thanks