Get Sheet Name From Excel

[fjlorenzo]

Hi, can someone help me? How can I get the sheet name from Excel file and put the sheet name on the formula tool. Below is my sample workflow. Thank you for your help.

[Emil_Kos]

Hi @fjlorenzo,

I have looked into the community and I found the below answer for you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Directory-input-file-path-with-sheet-n...

If this is helpful please mark my post as an answer!

Good luck!

[fjlorenzo]

Hi Emil,

Thank you for prompt response. I tried your suggestion and when I click on the Dynamic Input file and click on 3. Table or Query row I got this error message, "Unable to open file for read.."

[Emil_Kos]

Hi @fjlorenzo,

Apologies for the obvious suggestion but do you have this excel file opened? 

Edit:

Looking at this topic as well it looks like this is correct approach:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-List-of-Excel-Sheet-Name...

[fjlorenzo]

Hi Emil,

No, that file is closed. Also, to more info that Excel has two worksheets and I want to use the second worksheet inside the formula tool because the second worksheet name changes everyday. Currently, what I'm doing is to change the name of the worksheet from the formula tool before running the workflow. I just want to run it automatically without the manual changing of worksheet name.

[Emil_Kos]

Hi @fjlorenzo,

This is a post with a link to a workflow that should guide you with correct setup:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/using-dynamic-input-on-excel-files-wit...

Good Luck!

[fjlorenzo]

Hi Emil,

I will try this and will keep you posted. Thank you for your help.

[fjlorenzo]

Hi Emil,

I'm still having an error message of "has different schema than the 1st". Thanks.

[fjlorenzo]

Here is my latest workflow.

[dougperez]

Can you post your formula in formula tool?