Designer 19.3 - Import multiple xlsx

[Hamder83]

Hi 

I have just recently updated to 19.3 

But now I cannot get any of my macros working that imports multiple xlsx files from a folder.

Anyone got any ideas? 


Errors:
Error: Multiple Sheets Multiple Excel Files (15): Record #14: Tool #2: Field: "Sheet Names" is 0 length.

Or:
Error: Claje_LoadMultipleExcelFiles (1): Record #20: Tool #1: No sheet specified, you must specify a sheet

- Any thoughts?

[Jonathan-Sherman]

Hi @Hamder83.,

Could you check the input tool section (3)?

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

Regards,

Jonathan

[Hamder83]

Hey Jonathan 

Im trying out various macros, to be able to import multiple excel files at once.

Therefore to my knowledge, im not able to specifi sheet name?

[mmishal001]

Hi @Hamder83, this error "No sheet specified" comes up because you have multiple sheets on your file and the macro is being applied to only one sheet.

The solution is to have one sheet per .xlsx file.

Hope this helps.

[Hamder83]

Hi 

Ive just tried a sample of 5 files, all with just 1 Sheet, and it still doesnt work. 

Do you have a macro you know works, with importing multiple excel files at once?

[Jonathan-Sherman]

Is there the potential to input the sheet names into a control parameter? And convert the workflow into a batch macro?

Regards,

Jonathan

[mmishal001 · Accepted solution]

This link has a useful file that works. Unfortunately, I can't share the files I have as a sample but this link should help you achieve what you are looking for.

Here are some screenshots that may be of help to you.

Workflow with the Macro attached

This is inside the Macro (use one of the files you have in the folder) 

Configuration of the parameter

This link is also useful