Multiple Excel Sheets

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

Developer

Input

Best Practices

Batch Macro

Accepted answers

caltang

Please find attached. Hope this helps!

For Niranjan.yxzp

caltang

Here you go! Made it more dynamic. @NiranjanK1

For Niranjan v2.yxzp

caltang

Make sure the macro is configured with your input file:

Try using your real data in place of your temporary file in the macro. Open the macro to change the file and follow the configuration to include the full path.

Then, in your main workflow:

Your input should be sheet names & also to include full path.

Then, follow the formula tool, and the macro selection should be "FileName":

All comments

NiranjanK1

Any suggestions please

caltang

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.

NiranjanK1

@caltang thank you so much for detailed explanation.

Any best example workflow you give me.

caltang

Here you go! Made it more dynamic. @NiranjanK1

For Niranjan v2.yxzp

NiranjanK1

@caltang Your sample workflow is working fine, But when im trying to build same logic to main workflow. workflow is not ready all the data from multiple excel files. i could see one sheet data for all the pages. I have checked i could see no difference both the workflows. Not sure how to figure it out. Any suggestions please.

jdminton

I think there was one place missed in the config. The box to replace the string should be checked.

caltang

Can you screenshot the column which the error popped up on? @NiranjanK1 ?

NiranjanK1

@jdminton I have tried with this option same error

NiranjanK1

@caltang it is working fine in download folder. When I moved it to shared folder and updated full path. I'm getting this error

jdminton

The way that the macro is set up in the images shared by caltang is missing a check in the checkbox, as I mentioned earlier. It looks like it only works in the downloads folder because the file being referenced in the macro is the same as the input in the workflow. Once you change that to match the file you desire, the macro will not work correctly without updating that check box. Make sure that the check box highlighted below is checked and that the string below matches the string near the top. After you save these changes, the macro should work correctly. I put in a different file to test, so your file may be different.

caltang

@NiranjanK1 did @jdminton and I help you solve your issue? Kindly mark it as an accepted solution to close the thread.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703