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 |
If the object does not have a name then what will be the logical name?
What are the different kinds of testings done by WR
What is contained in the test scripts?
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?
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?
How do you load GUI map?
wahat do u mean by exceptional handling in winrunner
what is software metrics
How do you clear a gui map files?
Can anyone explain me abt Winrunner Automation framework in detail and what r the steps involved in it