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

Suppose there is a global variable called Counter.And there is a user defined function called my_function.which does not take in any parameters. How can a test engineer utilize Counter inside my_function body?

1 Answers   FCG,


What do you mean by S/W Testing Automation Framework? What are different types of automation framework?

1 Answers  


what is the extension for WR files?

10 Answers   AppLabs,


what is modul? and differ btwn testing and debugging

1 Answers  


How do you clear a gui map files?

0 Answers  






how are virtual object configured

1 Answers  


which option in WR executes the script line by line

3 Answers  


What are the standards will you maintain at the timing of writing TSL script in WinRunner?

5 Answers   AppLabs,


What actually happens when you load GUI map?

0 Answers  


Difference between actions and functions

2 Answers   Ordain Solutions,


What is the automation process in winrunner?

3 Answers   Second Foundation,


how many checkpoints are provided by WR

3 Answers   Ordain Solutions,


Categories