This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi @rajputakansha ,
Take a look at the attached example where I'm using two dynamic inputs to read all the tabs from all files.
Best,
Fernando Vizcaino
Hi @fmvizcaino ,
Thanks for sharing the workflow. What do I need to change in the workflow to make it work for my file? I changed the directory path and the sample file in Dynamic input.
Thanks
Hi @rajputakansha ,
I made it simple and for one file only now. You only need to change the input data file and the template as well.
The idea is to get all sheet names using an input data tool, for that, configure as image below.
Then, to dynamically insert the full path into other dynamic input tool to open them all.
Keep in mind that the dynamic input tool demands that all your tabs have the same structure.
Best,
Fernando V.