I want to assign values in a table in my software, in first column i will give values, table is of 4x4 i.e 4 row and 4 columns, i m using VBScript in my automation work. it is a simple table for giving values.
Answers were Sorted based on User's Feedback
Answer / sisira
set wbtable=Browser(“micclass:=Browser”).Page(“micclass:=Page”).WebTable(“name:= TTable")
no_row=wbtable.RowCount
no_columns=wbtable.columnCount
strobjType ="WebEdit"
For introw=1 to no_row-1
For intcol=1 to no_columns-1
Set ChldItm = wbtable.ChildItem(introw,intcol,strobjType ,0)
If ( strobjType ="WebEdit") Then
ChldItm.set "value"& introw&intcol
End If
next
next
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pravinkumar
Set exc=createobject("Excel.application")
set a=exc.Workbooks.Open("C:Documents and SettingspravinkumarmDesktopNew Folderpra.xls")
Set s=exc.Worksheets.Item ("sheet1")
exc.Cells(1,1)="Hello"
Exc.Cells(1,2)="Welcome"
Exc.Cells(2,1)="Hi"
Exc.Cells(2,2)="Jim"
exc.ActiveWorkbook.Save
'a.Save
exc.Quit
Set a=nothing
Set s=nothing
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / pravati
Datatable.Getsheet(id)
Datatable.value(4,4)=values
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / pravati
Datatable.Getsheet(id).setcurrentrow(4)
Datatable.value(shtid,4)=value
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain the concept of how quicktest professional (qtp) identifies object?
What are the Features & Benefits of Quick Test Pro ?
How to handle the exceptions using recovery secnario manager in Qtp?
How many types of Automation frameworks are there in UFT? Describe them.
How can i open 5 multiple browser at once through QTP VB script
how to convert 100 into hundred repees only and viceversa
An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))
what is the difference between link and hyperlink?
1.How to find in which row or column,string "Hyderabad" exist in excel sheet? 2.How to find how many times character "a" repeated in a given string "Koteswararao"
1)how to write test cases in test director? not go throuth requirments and plan but should be different way i need? 2)what is the mediator between qtp and application or project?
How QTP recognizes Objects in AUT?
How do you test the different ads displayed in the Inbox home page of Yahoo. Once u login Yahoo mail, in inbox page there will a banner, where different ads are scrolling, how do you test that using qtp?