Option to select ALL/NONE Sheets to import from Excel spreadsheet

[roberto]

Hello,

It would be cool to have the option to select ALL sheets (and NONE, so they can also be deselected massively) to import in the “Import Excel spreadsheet” action, so that if you have many sheets you don’t have to select them one by one:

Thanks,

Roberto

[dgudkov]

Note taken. Moved the topic to #feature-requests

[reynsnivea]

Any idea when this would be available ?

[joost.pieper]

Hi there, is this already somehow possible (select all sheets independent of the number of sheets in de file)? My source is an Excel file (xlsx) with mutiple, but each time a different number of, sheets)

[dgudkov]

It's still not possible to load all sheets in one action. The workaround is to use the "Spreadsheet metadata" to list all sheet names, then use iterations to load each sheet individually and append the results into one table.

See also:

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: Create a project (A) that loads 1 sheet which name is specified by a parameter. Create another project (B) that uses the “Spreadsheet metadata” to produce a list of sheets. 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 exa…

[joost.pieper]

Thanks. Already thought of that. I will look at the examples. Thanks again.