how to read data from a csv file using Test complete
functional tool..please can anyone post the code
- 5 Answers
- 18616 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasad gali
HI Aparna,
Testcomplete is having Drivers to work with any database
such as CSV files,EXCEL files..
This is done in TestComplete using DDT project item.
DDT.CSVDriver("Application Path");
//then wotk with ur CSV file..
Regards
Prasad Gali
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / sheeja paul
var RecNo;
// Creates the driver (main routine)
function TestCSVDriver()
{
var Driver;
Driver = DDT["CSVDriver"]("C:\\MyCSVFile.csv");
// Iterates through records
RecNo = 0;
Driver["DriveMethod"]("csvread.ProcessCSVData");
// Closing the driver
DDT["CloseDriver"](Driver["Name"]);
}
function ProcessCSVData()
{
var i;
for(i = 0; i < DDT["CurrentDriver"]["ColumnCount"]; i++)
{
Log.Message(DDT["CurrentDriver"]["ColumnName"](i));
Log.Message(DDT["CurrentDriver"]["Value"](i));
}
RecNo = RecNo + 1;
}
// Content of MyCSVFile.csv is
//Head 1,Head 2,Head 3,Head 4,Head 5
//Z1,Z2,Z3,Z4,Z5
//Y1,Y2,Y3,Y4,Y5
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / rajkiran
Can we Pass Blank values through CSV file or Excel file to test complete? i tried but it shows "Type Mismatch" Error.
Please help.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nivedita
Can u please pass some piece of code for writing data or
inserting the values in the excel sheet using ddt driver
| Is This Answer Correct ? | 0 Yes | 0 No |
What testing activities you may want to automate in a project?
What are the advantages of the automation framework?
What is tree view in automation testing?
What kind of tests should not be automated?
How to decide the tool that one should use for automation testing in their projects?
how to re-install QTP 11.0 trial version
Explain me what is testng and why is it better than junit?
1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?
Does automation replace manual testing?
IS DATA INTEGRITY TESTING AND INTEGRATION TESTING ONE AND THE SAME?IF DIFF CAN U SPECIFY THE DIFFERENCES
What is open source tool and give example?
Tell me how would you test your own element locator?
WinRunner 
