Generate output excel where format is exactly same as excel input file

[PB41091]

I have data like below:

Based on column G, there should be different excel files.

1. Arjun file with 3 entries, Chintan with 1 entry, Raj with 3 and Riaan with 1. (Basically, we need to split excel file as per names given in Column G)

the excel has colour coded cells, formatting and and also dropdown entries (for column E and F). I want everything as it is after splitting file.

				Input Data
A	B	C	D	E	F	G	H	J	K	L	M
123	James	Tier 3	N/A	<<Select>>	<<Select>>	Arjun	Arjun	-	533	-	4,205,311
21	Danu	Tier 5: <$1B	N/A	<<Select>>	<<Select>>	Arjun	Arjun	-	-	-	-
43	priya	Untiered	N/A	<<Select>>	<<Select>>	Arjun	N/A	-	-	-	-
543	payal	Tier 4	N/A	<<Select>>	<<Select>>	Chintan	Chintan	-	-	-	-
6775	prachi	Tier 4	N/A	<<Select>>	<<Select>>	Raj	N/A	-	-	-	-
788	suni	Tier 5: <$1B	N/A	<<Select>>	<<Select>>	Raj	Raj	3,358,956	527,239	-	104,637
976	shina	Untiered	N/A	<<Select>>	<<Select>>	Raj	Raj	-	10,065,595	-	-
234	john	Tier 5: <$1B	N/A	<<Select>>	<<Select>>	Riaan	Riaan	8,092,137	510,876	-	5,168,328

[Gunnar-Scheck]

Hi @PB41091,

I think this thread may have some useful information for creating a formatted output for you. 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formatting-Excel-Output-File/t...

You may need to create template files for each output and set up the output data tool to preserve the formatting on overwrite. However, some potential issues I can see with this approach is with the dropdown entries in column E and F, as well as if there are additional people that would need a separate output file. 

It may be helpful to provide a sample file of the type of formatting and color coded cells that are being used.

[OTrieger]

@PB41091 
You will be able to do it with a Blob tool.

All you have to do it creating one template that Alteryx will use.

Put the WF into a Batch macro that the Control Parament will be the entries for Column G, ensure that you integrate it into the output path so you will get different outputs without overwriting the output file again and again.

Get the data in, call the template with a Blob tool, write out the template with the new name and then enter the data into a specific field, that will do the job.