Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 2 Answers
- 7995 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
how can i change the action path that called in other action. when i copy one action to other pc,the action"test2" calls another action(C:\test1\action0),and i update this"test1",the folder update to "action1",but when i open "test2", it just point the call path to "C:\test1 \action0", but does not update to "action1",and the change i make can be shown in test2. so, can i update the call path manully? thanks
I am verifying the actual vs the input value to make sure that they been entered correctly. In the Global Sheet I have a column called Customer with the multiple names in each row and now I am trying to capture the value during runtime under the column name Customer_in_Apps. Somewhat it works but during runtime the values are being stored in each column vs each row i.e., Customer_in_Apps, Customer_in_Apps1. Automatically it add columns instead of rows. row=datatable.getsheet("Global").GetRowCount for x=1 to row datatable.getsheet("Global").SetCurrentRow(x) Window("Customer Desktop").Window("Customer Tracking (Privacy").WinObject("TreeView20WndClass").Click 92,244 runtimevalue = .VbTreeView("vbname:=AppServerTree").GetROProperty("Selectio n") Val1=Datatable.Value("Customer",dtGlobalSheet) Val2 = Datatable.GlobalSheet.AddParameter("Customer_in _Apps",runtimevalue) If (trim(Val2)=trim(Val1)) Then Reporter.ReportEvent micPass, "Customer validation successful", "Actual Value: " &Val1&vbcrlf& "Customer Value: " &_Val2 else Reporter.ReportEvent micFail, "Customer validation unsuccessful", "Actual Value: " &Val1&vbcrlf& "Customer Value: " &Val2 End If Next
What is diff. between ordinal identifier INDEX and Location?
Hi cud you plz answer my question.. what is the size of Object Repository?
What is the extension of the qtp local repository?
in a web page How to check and display a particular word from a paragraph?
How can i test an application like Google Earth.In my application data will be fetched from a oracle database based upon which graphs are generated..so these all are dynamic..how can i use qtp here..alongwith that how can i test the map generated by a satellite just like google earth..
why do we go for Test Automation?
What is .Ini file in QTP?
Hi, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?
How to face prjoect manager round what type of questions they will Ask ? (Chandana)
1 Answers Call Centre, Convergys, IBM,
Have you used xml check point in your project? How?
WinRunner 
