Can't find a way to generate multiple excel files using a template

[jaypatnaik]

Hello,

I have a workflow where I use a combination of a macro and dynamic input to source multiple excel files in a directory, perform some manipulations, generate an output file for each input file (using a dynamically created Output File Path based on the input file path name). I'm looking for a way to generate each one with two "dummy rows" above the data, the first saying classified in cell A1, and the second row being a blank row. The headers in the file have to be in row 3 as shown in the second screenshot. I have tried using a union to append the rows, using a template file and appending, but those options do not seem to work. Is there an easier way to do this?

[Qiu · Accepted solution]

@jaypatnaik 
I believe that you have overcome the part of importing multiple Excel files with a batch macro.

Then in order to add 2 rows as you have requested, we can do something as below.

In the Input tool, check the option "First Row Contains Data" which will bring the header in.