Can anybody give the script of below things.
1. Add sheet
2. Adding columns
3. Set the values in that columns(In the rows)
4. Close the sheet
5. How can we create 3 sheets in one Excel sheet??

Answers were Sorted based on User's Feedback



Can anybody give the script of below things. 1. Add sheet 2. Adding columns 3. Set the values in ..

Answer / srikanth

1.Datatable.AddSheet("Global")
2.Datatable.GetSheet("Global").Addparameter("User_name")
3."srikanth"=set Datatble("User_name", dtGlobalSheet)
4.Datatable.close
5.Datatable.Addsheet("Sheet1","Sheet2","Sheet3")

Is This Answer Correct ?    2 Yes 1 No

Can anybody give the script of below things. 1. Add sheet 2. Adding columns 3. Set the values in ..

Answer / saritha

hi
data table methods:
1.Add sheet: adds specified sheet to runtime data table
syntax: datatable.addsheet("sheet name")

3.set currnt row method;
sets the specified row as the current row

syntax: datatable.setcurrentrow(rownumber)

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More QTP Interview Questions

what difference between runtime object and text object and what property they have. whether they have same properties or different properties.

0 Answers   Intel, Satyam,


What is test object model in QTP ?

8 Answers  


For an application we automated QTP scripts. At the same time new requirement comes for a new module for the same application and its already developed. So how we automated now this new module with the old application(using old QTP script).

2 Answers   Bosch,


Tell some commonly used Excel VBA functions?

0 Answers  


results.xls file is automatically generated while running the script in QTP.But it is showing error to open the file

1 Answers  


What is time parameter?

1 Answers  


Set DR= CreateObject("Mercury.DeviceReplay")

2 Answers  


Are Shared ORs read-only?

0 Answers  


can any one tell me what is syntax error in line msgexist=Browser("title:=Gmail: Email.*").Page( "title:=Gmail: Email .*").WebElement(innertext=&msg).exist 'code ************** Call login("lal="," " ) wait(5) Call errormsg("Invalid email address. [?]" ) Function errormsg(msg) msgexist=Browser("title:=Gmail: Email.*").Page( "title:=Gmail: Email .*").WebElement(innertext=&msg).exist if msgexist then Reporter.ReportEvent micPass,"enter valid username or pwd ",msg else Reporter.ReportEvent micFail, "entered valid uname and pwd",msg end if End Function

5 Answers  


what is defenetion of kiran can u tell me plz CVS, SVN

0 Answers  


Write a command for setvalue function in a webedit

3 Answers   Wipro,


how to pripare BRS/FRS Document for different projects?

1 Answers   Wipro,


Categories