Pass Parameters to Excel workbook

[thulasiram1982]

Hi Team

I would like to pass data to excel sheet which should be placed in different locations and the file needs to be saved.

Can someone help me!

Regards

Thulasi Ram Developer

[alexnajm]

@thulasiram1982 this is a very common use case in Alteryx, so can you provide more details? Is it multiple excel files in multiple locations, or multiple tabs in the same file? Is there a column to help distinguish how to split into the multiple files?

A workflow with data would be helpful to better answer your question!

[thulasiram1982]

@alexnajm 

The requirement is to generate output in the predefined template. The template contains only one page which is predefined, and this should be copied for each item, and the data has to be placed in multiple cells and then save the file. Basically, I'm looking for a For Loop type condition to generate similar set of conditions.

[alexnajm · Accepted solution]

Thats very possible to do - you'll need an Output Data tool outputting to the range you want for each set of data, while also selecting the option to "Preserve Formatting on Overwrite" so your predefined template stays as is.

You will likely need the Block Until Done tool to make sure the processes don't overlap each other. Here is a simplified screenshot of generally how it'd work. Good luck!

[thulasiram1982]

Hi Alex Najm

I'm trying to generate the multiple file using the template. This flow creates multiple files but overwrites with the data what is expected to show. Request you to help me on this and let me know if you need any other details.

 

[alexnajm]

I am sorry but I do not understand the question. What is your input and expected output? Can you share the workflow with us?