Create New CSV File and Modify it/Input Data in it

Hi All,

I have a requirement where I need to create an csv file from scratch and input values in first and second row of the excel through another excel file and save it in csv format
. I should create 100 different csv file. I am trying to use Excel existing commands but it is not working for me. So I tried recording it and I got TestedApps.EXCEL.Run(1, true);

Now I am not sure how to input data in the same and when I run this command every time  it opens Selection of excel Template page before opening to blank workbook. Could anyone help me on the same