Hello,
I'm trying to make a workflow in which i create a table of only the sheetnames containing data within a spreadsheet (so omitting the empty sheets) using "Read xls sheet names"-node. See yellow part in picture for my struggling sofar.
Now im stuck. Could anyone help me on this?
hi Marcv,
See attached for an example for how to count the number of rows in each sheet. Not that you can replace the chunk loop start for a table row to variable loop start, which is a bit more compact.
Thanks Aaron!
Solved it another way (see attached file). However your solution is more elegant i think.
In order to handle completely empty spreadsheets without stopping my workflow i insert an empty row.
gr.
Marc
