Interested to Buy Any Domain ? << Click Here >> for more details...
How to Get data from database(table) to an excel sheet
- 2 Answers
- 5465 Views
- iGate, I also Faced
- E-Mail Answers
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 |
can we write exception handlers (object,tsl,pop-up) programatically then how should we insert this in the script?
WHAT S/W LANGUAGES DOES THE WINRUNNER & QTP SUPPORT? WHAT ARE THE LATEST VERSION OF BOTH THE TOOLS?
In WinRunner Compile Module doesn't support checkpoints Why?
How should we create a compiled module? What is its importance?
How do you suppress a regular expression?
What is Add Watch?
What are the three modes of running the scripts?
what is the difference between unit testing,integration testing and interface testing?
How to insert the data in to the data table from the data base records?
2 Answers CTS, Landscape Technologies,
hi everyone today is the first time i saw this website,and hi iam siraj,iam very impressed by seeing evryones response towards questions,iam a newcomer and i have got tryining in testing can anyone please send me some projects relaited to testing.i know it is very confidential but still if u send it will a great help. my mail id mateen_012005@yahoo.com
what is mean SRS and URS . differns btwn SRS and URS
There is an error in opening WinRunner "Error: open connection to CRV (-1). Exiting..." and then the winrunner is terminating. Can any one suggest solution for this?
WinRunner 
