How to Get data from database(table) to an excel sheet
Answers were Sorted based on User's Feedback
Answer / naga chiranjeevi kota
Session="mysession";
connstring="DSN=DQMCHIRU;UID=dqm5map;pwd=dqm5map;server=Orcl";
rc=db_connect(Session,connstring);
x="select PART_NUM,PART_ORG ,RDX_ID,DESCRIPTION from
reference_data_part where part_num like '%31' order by
PART_NUM";
printf(x);
# Opening the excel sheet
dqmdata = "C:\ExecuteSampleData.xls";
rc = ddt_open(dqmdata, DDT_MODE_READWRITE);
if (rc!= E_OK && rc != E_FILE_OPEN)
pause("Cannot open table.");
dc=db_execute_query(Session,x,rows);
#ddt_get_row_count(dqmdata,rows);
for(i=0;i<rows;i++)
{
db_get_row(Session,i,rowcon);
#ddt_set_row(dqmdata,i);
split(rowcon,rdp,"\t");
for(j=0;j<4;j++)
{
printf("R"&i+1&", C"&j+1&": "&rdp[j+1]);
ddt_set_val_by_row(dqmdata,i+1,"C"&(j+1),rdp[j+1]);
}
}
db_disconnect(Session);
ddt_save(dqmdata);
ddt_close(dqmdata);
answer by: Naga Chiranjeevi Kota(iGATE)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / softwaretester4u
hi this is good answer.But i have one question is it
possible to call differect sheets in same excel
like sheet1 have one data,sheet2 have some data in same
excel .is it possible to call ? pls tell me
Is This Answer Correct ? | 0 Yes | 0 No |
How do you invoke a text file from winrunner?
winrunner supports .NET technology or not?
we have three windows with title(logical description),India.com,Government of India.com,India Inc.com.All three windows have similar properties and object.A test script has to be run on all these windows.what changes will u make in GUI or script so that the script runs succesfully on all these three windows with the least alteration required? Please explain clearly with steps.
How do you suppress a regular expression?
What is Data Driven TEsting?
How do you handle unexpected events and errors?
What is the Purpose of Virtual Object Wizard in WinRunner?
What is Add Watch?
How to Know through script which add-ins are loaded with winrunner?
How does WinRunner recognize objects on the application?
what is add-in manager in WinRunner?
who prepare the RTM?