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 |
what is mean SRS and URS . differns btwn SRS and URS
what is the name given by WR to Microsoft excel file
When it is appropriate to change physical description?
How can I check the font size and color using winrunner?
Can anyone explain me abt Winrunner Automation framework in detail and what r the steps involved in it
When you create GUI map do you record all the objects of specific objects?
ca n u give the eample for low severity & high priority in ur Internet Banking project
Hi, Currently i am using winrunner for my project.Its a java project. When i am running the script its failing in cliking an image link("My Profile"). The image object is eventhough exists in GUI map editor script is failing to recongize the object. I am getting the error of "Web_image_click:"My Profile" Error:Object is not found". I recorded the script and executed it is not running it shows the same error. The following physical description displaying in GUI map editor : { class: object, MSW_class: html_rect, html_name: "My Profile" } The thing was running successfully, I could not able to identify something happen to the script its showing error. Please give solution for this problem. Let me know if need more information. Regards, Sankar shankarmg@gmail.com
How to break infinite loop?
what is the function key to toggle a breakpoint
How to check the Back Ground Color of screen in Winrunner?
3 Answers 3i Infotech, Satyam,
what type of licence key r u using for winrunner software in your company?