how do we add a new sheet to data table in QTP?

Answer Posted / raavi

The created shhet in virtual sheet then we can cal any
where in the program

Datatable.getsheet"Sheetname"

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi Guys, I want to place all of my values which i am getting it from a loop in to a global shee. For that i had written the script like this For i = 1 to ECOs-1 ECO = List(i).GetROProperty("innertext") DataTable.AddSheet("ECOList") DataTable.GetSheet("ECOList").AddParameter "ECOList",ECO AbortECO = DataTable.GetSheet("ECOList").GetParameter ("ECOList").Value msgbox AbortECO DataTable.GetSheet("ECOList").SetNextRow Using the above script, whenever the loop iterates it is creating new column "ECOLIST" in the sheet called "ECOLIST". It means, the values are displaying in the column wise even though i added the script " DataTable.GetSheet("ECOList").SetNextRow" . The cursor is not moving to the next line. Anybody help me out how to pass the values from script to the excel(Global/Local) sheet. Pls let me know @ nbabu11@gmail.com if you are not clear about the question.

1378


Explain the benefits of quick test pro(qtp)?

563


hi all can anyone explain how to write the code for finding the mandatory columns in table which are having (red*) (red Astrik)

1392


How can you send user defined messages to test report?

577


Hi,Sudhanandareddy plz forword framework and ppts for QTP to me. This is my mail id: ranjith_99reddy@yahoo.co.in (your contact number also)

1730






How to test login module with different username and password by using data driven testing in QTP?

601


Hi there, I've installed a trial version of QTP to see if it works with my product but I cant automate selecting windows from a tree view? Can anyone give me any pointers? Many Thanks

1412


what is the difference between built-i function and In-built function?

1625


Hi All, I Want To excute scripts batch without using QC .I need code for that Thanks Balaji

1312


What is 'sleep' in sync point?

612


Hello Everyone, Please provide me the practical example of business component concept of QTP.Like how to create business component,how to connect the quality center etc.... Thanks in advance, Gaytri

1397


Client is able to provide budget..he want you to choose the automation tool for the web application? which one you will select ? QTP or Selenium ? what are the reasons?

1223


What does it mean when a check point is in red color? What do you do?

561


Where is the Bitmap checkpoint information stored?

1753


What are the Disadvantages of shared object repository?

559