Multiple Input to One Output Excel File

I have 39 different input files in one folder. and I just want them to be as 1 output excel file but different sheets..

so in short...i need 39 sheets in my output excel file... can someone please tell me the exact procedure for this?

I was facing the error - Error: Output Data (6): Unable to open file for write:
: The process cannot access the file because it is being used by another process. (32)

I tried the block until done..but it's not working for me...

is there a workaround for this?

Output

Accepted answers

All comments

atcodedog05

Hi @ben_d_jacob

Make sure all files to which you are writing are closed. Because that causes file lock.

There is a possibility for this to happen if you are using multiple output tools. You might have to use multiple block until done in a sequence.

Can share a snapshot of your workflow.

philipmannering

@ben_d_jacob

If what @atcodedog05 suggests fails, I would actually make sure all Excel files are closed when writing to multiple sheets. I've got errors of this nature when writing to multiple sheets even if a different excel file is open.

messi007

Dear @ben_d_jacob,

Attached the workflow that do the job.

However, as @PhilipMannering and @atcodedog05 this error happen when the excel output file is open.

Best regards,

dynamic input.yxzp

ben_d_jacob

Dear @messi007

Can you please explain the procedure on how you did this? i seem to have an issue at the dynamic input tool.

All my files are closed. No input or output file is open.

I'm sorry but I'm just a beginner in alteryx and i'd really appreciate the help

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703