Directory input ; file path with sheet name

[Stacy]

Hi,

Is there any way that I can open the several files by directory tool and get full path with each sheet name? Thank you!

[MarqueeCrew]

You might want to check out @ned s blog post. 

http://community.alteryx.com/t5/Engine-Works-Blog/Alteryx-Reading-XLSX-Directly/ba-p/2190

[KaneG]

Hi Stacy,

If you are on v10, then the way to do this would be to read the directory in using the directory tool and then feed that into a dynamic Input tool, with <List of Sheet Names> selected as the sheet on the template in the Dynamic Input tool. That will return a list of sheets for each file, which you can then use a formula tool to make the filename|Sheetname combo you need. So in the Dynamic Input, your settings for the template will look like this...

Kane

[swatisharma32]

Hi Team,

I have a scenario where i have multiple folders inside a folder and all those multiple folders have many excel files in it .

Below is the screenshot for better understanding -

want to automatically access the all the folders and all the excel files inside it .

Please let me know how to achieve this.

Thanks,

Swati Sharma

[mmishal001]

@swatisharma32 

Use a Directory Tool and make sure the configuration is set as per below where file specification is your file type and you select the sub directory checkbox to include the files from your sub folder as per your requirement.

Then select the dynamic input tool and make sure the configuration is as per below,

This will work if there is one sheet in each of your excel files.

If there are multiple sheets in your excel file then you will get an error on your dynamic input tool which will say "No sheet specified"

Follow the answer which has been marked on this question.

I hope this helps!

Kind regards,

Mishal

[Ragini]

Hi Mishal,

Do you know what is the workaround if there are multiple sheets in the excel files?

Thanks!

Ragini

[KaneG]

@Ragini,

I'm not sure that I understand your question. The above works with Multiple sheets in the Excel file.