How to Get data from database(table) to an excel sheet
Answer Posted / 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 |
Post New Answer View All Answers
what is qtp licence
How do you handle tsl exceptions?
How do you handle dynamically changing area of the window in the bitmap checkpoints?
Hi iam a begginer or rather new stsrter to QTP and strugling to start as i have to start writing the automated scripts for the existing manual testing could some one send me some tips ans tricks for a jump start. Any help is greatly appreciated
Explain the purpose of loading winrunner add-ins?
What is the difference between gui map and gui map files?
Difference between winrunner and test director?
What do you verify with the gui checkpoint for single property and what command it generates, explain syntax?
The title of the window consists of date and time.What is the regular expression to recognize the window as unique?
What is the disadvantage of loading the GUI maps through start up scripts?
Are there any suitable free tools to conduct performance test on a php web application?Manual or automation which is preferable for such kind of application? please answer ASAP
what are the differences you see in e-commerce and banking domain in testing point of view Thanks in Advance
What in contained in the GUI map?
How to read the third party controls in the application
How do you find an object in an gui map.