How to import several tabs from an Excel file?


I have an Excel file with several tabs and I want to import all the tabs at one time.
Effectively, only the first tab is exploitable. I have to import the file and to choose the good tab I need to work with.

Thank you in advance.


Loading several tabs requires using iterations in EasyMorph. From a high-level perspective, the workflow is following:

  1. Create a project (A) that loads 1 sheet which name is specified by a parameter.
  2. Create another project (B) that uses the “Spreadsheet metadata” to produce a list of sheets.
  3. In project B iterate across the list of sheets running the project (A) created in p.1.

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