How to read data from a CSV file using Test Complete functional tool?

Replies to This Discussion

Permalink Reply by Aleksandar Karamfilov on January 20, 2010 at 6:41pm

You can read data from CSV or XLS, databases etc. There is thing called CSV Driver. Only thing you should to is to call that method and type path to the csv file inside. Thats all you should do.

• ▶ Reply

Permalink Reply by John Johnson on January 29, 2010 at 12:22am

We are reading data from XLS files like databases using connection strings and SQL. Don't know if that works with csv files.

• ▶ Reply

Permalink Reply by Aleksandar Karamfilov on February 8, 2010 at 5:55pm

if we talk about TC yes it works the same way for a csv files

• ▶ Reply

Permalink Reply by Vallabh Chitnis on July 27, 2010 at 9:34am

Hello,

Please read the topic - Data Driven Testing in Test complete Help. You should be able to do basic things after reading the topic. We use excel file instead of CSV file.

Thanks.
Regards,

Vallabh Chitnis

• ▶ Reply

Permalink Reply by Lakshmi Srinivas on September 15, 2010 at 3:48pm

Hi Friend, did u get the solution for the question?

Lakshmi

• ▶ Reply

Permalink Reply by Deepak Falke on October 26, 2010 at 4:00pm

Hi Aarya,
please see the code this will help you !!

HostName = Project.Variables.Hostname;
VDir = Project.Variables.VDir;
path = Project.Variables.path;


p1 = Sys["Process"]("iexplore", 1);
w=Sys["Process"]("NOTEPAD");

FS1 = Sys["OleObject"]("Scripting.FileSystemObject");

F1 = FS1["OpenTextFile"](path+"\ProgramDoc.txt", ForReading);
while(! F1["AtEndOfStream"])
{
str = F1["ReadLine"]();
intRecordCount++;
}
F1["Close"]();

Thanks,
Deepak

• ▶ Reply