Import Multiple Excel Files with Varying Worksheets

[crunyeon]

I am looking to import an entire folder of Excel documents into a workflow without having to add a new input tool for each file.  I tried using a wildcard in the Input field, but I am having a problem.

All of the worksheets within the Excel files are named the same, however they don't all exist in each file.  So for example, they appear like this:

Spreadsheet 1

     West Region Sales

     North Region Sales

     South Region Sales

Spreadsheet 2

     West Region Sales

     East Region Sales

Etc. 

Can I perform an If statement on the import that just ignores the excel file if it doesn't have the appropriate worksheet?  Thank you in advance for your help.

[jbudati]

Hi @JordanB 

I'm trying something similar, but it's looks quite different as I would like to create 15 different tables from 15 different tabs all in one excel sheet and also all the 15 tabs have different structure ?

Can you please help me in this scenario ?

[pjandliz]

Hi Jordan

Just found this post - VERY helpful - I'd like to append the sheet name to the output records along with the file name but can't figure it out.

I'm a macro 'gumby' so am hoping this is something pretty simple to do and you could point me in the right direction?

Many thx.

Paul