How to import several tabs from an Excel file?

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

1 Like