Multiple Input to One Output Excel File

[ben_d_jacob]

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?

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

[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

[atcodedog05]

Hi @ben_d_jacob 

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)

your error is clearly saying its a issue from output tool.

Can you share a snapshot of your workflow.

[ben_d_jacob]

@messi007 @atcodedog05 @PhilipMannering 

I've just understood that the dynamic input is failing to do the job because my input files do not have the same headers or columns...

Is there anything else I can do?

Also, I'm not able to share the screenshot as I'm not allowed to do so...(I hope you understand).

It would be great if a solution can be given at the earliest 🙂

[atcodedog05]

Hi @ben_d_jacob 

If the headers are not same if kind of a major roadblock.

There maybe workarounds but very tedious ones.

Sorry 😶

All the best though 🙂

[PhilipMannering]

@ben_d_jacob Are the headers in the same order between Excel Workbooks?

[AkimasaKajitani]

Hi @ben_d_jacob 

I made the workflow that read different schema Excel files and put into one Excel each sheet.

Batch macros are needed for this process.

Please try the attached workflow.