How to put files in standard template

[Pandey19]

Hi,

I've a standard template with some color coded column names and i've some input files .

I want to simply copy data from input files to the standard template removing headers of input file and keeping everything in template file. And the color code of template should also be not disturbed.

Is it possible to achieve in alteryx?

Template:

Some headers
system	system	system	system	system	system
a1
Date	Num	Type	Acct	Code	Name

Input:

Date	Num	Type	Acct	Code	Name
10/7/2021	182	S	200	2000	ABC
10/7/2021	182	S	209	2300	DEF
10/7/2021	182	S	212	2000	GHI
10/7/2021	182	S	313	2000	JKL

Output:

Some headers
system	system	system	system	system	system
a1
Date	Num	Type	Acct	Code	Name
10/7/2021	182	S	200	2000	ABC
10/7/2021	182	S	209	2300	DEF
10/7/2021	182	S	212	2000	GHI
10/7/2021	182	S	313	2000	JKL

[AZuc]

@Pandey19 

I believe the answer is in this link https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Outputting-to-a-formatted-excel-templa...

[Pandey19]

@AZuc ,

I just want to copy my input data and paste into template file . Row 1 to 4 will be the headers from template file and from row 5 will be my input data

[AZuc]

@Pandey19 

Sorry, this is the correct link https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-output-to-formatted-sheet/td-p/5...

You basically need to configure your excel output in a way similar to this one