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

[Vars01]

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

[Marsha_R · Accepted solution]

This may help

https://community.smartbear.com/t5/TestComplete-Functional-Web/How-to-Retrieve-data-from-CSV-File/td...

Just curious, why are you testing Excel?