Hi All,
I have an excel file with multiple sheet names. I want to read all excel sheets information. I have tried with community examples it is working on my desktop. when i move same workflow to shared folder. it is not working. I have tried with multiple ways examples avilable in community. Please suggest any other way can i read all sheets details.
Thanks in Advance,
Niranjan
Solved! Go to Solution.
Any suggestions please
If your sheets are of the same data format (meaning, the fields - i.e the columns are of the same name, same data type, and of the same length), then you can use a Dynamic Input tool to call all of it in.
Otherwise, you can also use a Batch Macro to do the job.
Refer to documentation below:
If you're still stuck, you can provide us with some sample data and we can show you also.
@caltang thank you so much for detailed explanation.
Any best example workflow you give me.
Can you provide some data?
@caltang I do not have access upload/send an emails. I'm doing it from my mobile. Tomorrow I can upload sample data with personal laptop.
@caltang Please find the attached sample data, Im unable to read multiple sheets details. Please help me.
@caltang I could see sheet1 data 4 times. i want to fetch multiple sheets data. Please suggest me do i need to select any other option.
Here you go! Made it more dynamic. @NiranjanK1