Output multiple files based on number of files in input folder

[stataltgee]

I have 2 inputs - A and B. 

1. A - folder with multiple files.
2. B- single file

Based on these inputs I created a workflow. The output is based on a template file ( the headers are taken from the template file)

So the output should be basically 1 file for each input in A folder such that it has column headers from template and below that the data will be populated. 

I am trying to achieve this but I'm getting only the data populated in the range. The headers are missing in their positions. 

Can anyone guide me through this? 

[Dhrish]

@stataltgee For utilizing the template files you will have to use the preserve formatting setting in the output tool, and since you have 1 template and multiple output files utilizing the same template, you will have to use blob tools to make template file for each input file so that they can be updated with the required data.

[stataltgee]

@Dhrish from where have u taken the filename column in formula tool?

[Qiu]

@stataltgee 
I think we can choose to output the FileName when using the Data Input tool.

[Dhrish]

@stataltgee in the last snip it has the config of input tool. In that I have selected Fullpath for Output Filename as Field, this will give the full path of the File which gets only the fullpath without the sheet name.