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 |
will QTP 9.2 run successfully on Linux(gui) operating system
wt is memory leakage?
how did u use automating testing tools in ur job?
How to handle Dynamic Arrays?
What is meant by Environmental variables?2 types r there know…can u pls explain clearly?
Tell me the situations where we will use Data Driven?
What are different types of frame works ?
how will check the links in multiple pages at a time
Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?
Actually How do we use this Smart Identification Technology during Recording mode.
What are the Features & Benefits of Quick Test Pro (QTP)..?
if the excel sheet specified in script is not there,we get run time error how to handle the error ,please anybody explain me in detail