Ask a Question

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

SOLVED
Vars01
Occasional Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Marsha_R
Community Hero

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

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?


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame

View solution in original post

1 REPLY 1
Marsha_R
Community Hero

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

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?


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame

View solution in original post

cancel
Showing results for 
Search instead for 
Did you mean: