App to populate different tabs in a single excel

Question

Hi all,

Just wondering if anyone know of a way to have an app populating data in different tabs within the same excel workbook?

Reading through several posts i've tried;

* using parallel block until done
* Parallel block until done connected to a Block until done
* Parallel block until done connected to a wait a second
* Chaining my Parallel block 
*

* Using AMP engine

The error message i keep getting is the file is in use by a another process

Tranda · Answer

Hi mceleavey,

I managed to open Qiu's workflow, issue was due to the version of Alteryx that i have

How do i wrap the output into a Batch Macro and use the group filepath as a control parameter?

would you have an example somewhere that i can use as reference?

Thank you in advance

Tranda · Answer

Thank you both for your help

Sorry but i'm fairly new to Alteryx, i wasn't able to open Qiu's file

Would you have an example i can use as reference ?

mceleavey · Answer

Hi @Tranda ,

Yes, this is because it's trying to write multiple tabs to the same file and Excel can't support multiple writes to the same open file.

To accomplish what you need, try doing what @Qiu suggested but wrap the output into a Batch Macro and use the grouped filepath, including the sheet name, as the Control parameter.

Then simply overwrite the filepath that is being used each time. This will ensure the file is closed in each write instance.

Hope this helps,

M.