Multiple Excel Sheets

[NiranjanK1]

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

[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.

[caltang · Accepted solution]

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":

[NiranjanK1]

@caltang Awesome it us working now. I missed to update the interface designer.

[NiranjanK1]

@caltang sorry to bother you, out of 41 sheets it is reading jnly 38 sheets any issue or do I need to enable option.

[caltang]

Is it because the sheet column names are different? Can you provide some images of the ones which are left out?

[NiranjanK1]

@caltang now I got one more when I'm using full path, it is giving some different error 

Record #1: Tool#1:<List o does not match a sheet or named range in uioutput.xlsx or the file is corrupted. 

I'm getting above error when I'm using full path. How to fix 

[caltang]

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Input-Error-quot-Does-...

Try doing this.

[NiranjanK1]

@caltang I have try it, but they are using only one sheet. I have multiple sheets details how to use same logic. I have implemented but it is reading only one sheet information. Please suggest me.

[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 ?