Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How to Get data from database(table) to an excel sheet

Answers were Sorted based on User's Feedback



How to Get data from database(table) to an excel sheet..

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

How to Get data from database(table) to an excel sheet..

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

Post New Answer

More WinRunner Interview Questions

If the object does not have a name then what will be the logical name?

1 Answers  


What are the different kinds of testings done by WR

1 Answers  


What is contained in the test scripts?

0 Answers  


what is custom check point? what is the diff.between custom check point and runtime Record check ?

2 Answers   Infeneon Technologies,


How to Know through script which add-ins are loaded with winrunner?

2 Answers   Accenture,






What is the TSL function in WinRunner to connect to test director?

1 Answers   Infosys, Kanbay, Scope International,


How do you run your sciripts in Win Runner?

2 Answers   Logica CMG,


How do you load GUI map?

0 Answers  


wahat do u mean by exceptional handling in winrunner

3 Answers  


what is software metrics

1 Answers   IBM,


How do you clear a gui map files?

0 Answers  


Can anyone explain me abt Winrunner Automation framework in detail and what r the steps involved in it

1 Answers  






Categories