How to get tab names in data when using download tool

So I have to download a file from somewhere and have to show the sheets name of that file

I used download tool to get the file but now when i am using dynamic input i am not able to get the sheet names. i don't want the sheets data as an output i am looking for sheet names only

suppose there are 3 sheets in a excel file so the output should be the name of the 3 sheets

sheet1

sheet2

sheet3

Developer Tools

Tips and Tricks

Batch Macro

Download

Accepted answers

joshuaburkhow

The issue you have is in your formula tool. The string size is too small 😉 I created a new field and gave it a bigger size string and then I updated the dynamic input to look at that new file name, it works now.

Hope this helps. Please mark as solved so others can see it

Jonathan-Sherman

Hi @gauravnegi2,

The size of your [file name] field was too short and cutting off the extra text you added in the formula tool. I've upped it and it works perfectly!

If this solves your issue please mark the answer as correct, if not let me know! I've attached an updated workflow for you to download if needed.

Regards,

Jonathan

20201006 - InputSheetNames.yxmd

All comments

joshuaburkhow

Hey @gauravnegi2 It's going to be hard to tell what you need to do without seeing the workflow. Are you able to share or maybe screenshot the output of the select tool? Are you outputting a temp excel file?

Jonathan-Sherman

Hi @gauravnegi2,

I would add a formula tool before your dynamic input tool with the following formula:

[FullFilePath] + "|||<List of Sheet Names>"

And feed this into the dynamic input tool, which will return the list of sheet names in each file.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

gauravnegi2

@Jonathan-Sherman @joshuaburkhow Here is the workflow with the URL

@Jonathan-Sherman i already tried this but it didn't work, can you please check what am i missing.

input file.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703