How to read only specific excel sheets? Half way there - stuck.

[sroberts]

Hi all,

I am trying to figure out a way to go through numerous files (200+), pull out the sheet names, and have the Excel reader only from those sheet names - pulling data from each one.

Right now, my workflow is

Read Excel Sheet Names > Gather a list of the names on my folder with the files I need

Row Filter > Filter out unnecessary sheet names

Table row to variable loop start > tell excel reader which variables it will be reading for the sheet names

Excel Reader > Pull the data from the selected sheets

Loop End > Hopefully get my output

My issue is that not all of the excel files have all of the sheet names in them. So I run into errors where it says ‘File does not contain a sheet named April 2022’. Many files will have sheets for different months so not all will be contained within it.

[piotr_domagala]

Pass to final loop name of excel file together with desired sheet name - instead of just sheet names. (of course it will be more steps in loop but allow you to pass entire loop without error).

[mlauber71]

@sroberts maybe you take a look at this example

This workflow demonstrates how to use the new Excel Reader and path variables...