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:
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)
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.