1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

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??

Question Posted / priyareddy

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

Give me some real time point of way where exactly we can conduct audits?

0 Answers   CTS,

What is use of Global Sync Timeouts in QTP9.2?

2 Answers  

what is L-trim function will do?

2 Answers  

hi can any body give me a script for creating a modularity or keyword driven framework..i am working as a qtp tester for 2 months but still i am not exposed to framework in my company

0 Answers   Excel,

can we do load testing , by using QTP......?

1 Answers  




What is smart identification?

2 Answers   Ordain Solutions,

I have written some script in QTP and i added those objects in Object Repository. All written script has been executed successfully. After few days when i tried to execute the same script i got error message "objects not found in Object Repositiry". How can we solve this issue?

3 Answers  

What is the exact difference between QTP and RFT ?

2 Answers   CTS,

how can u put synchronization point in qtp,wat is exactly synchroniztion why we use it wat is benifit in qtp

13 Answers   College School Exams Tests, Mind Tree,

i am entering wrong data or wrong password in a text box and click on submit button .i am getting a popup window with a message Please enter the correct password or data .How can i handle this situation by using QTP.

11 Answers   SAP Labs,

we have 10 more actions in our test and we are using exit action command to come out from the action if any error s occured.In action 1 if any error occurs control is moving to second action but if we get error in second action exitaction is throwing general run error. Please give a idea to overcome .

1 Answers   TCS,

Explain about the Test Fusion Report of QTP?

1 Answers  

For more QTP Interview Questions Click Here
Categories