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 |
Hi, Plz give best Definition of Software Testing? Why we need Software Testing? and plz send 2+yrs experience Interview qutions (Manual,Qtp).
Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?
Given a string variable contain a full name (last name, first name), using vbscripting, how can you extract first and last name and save them into two different variables.
for example u can take ebay or plifcart online shoping web application--------- write acode in vbscript in qtp---- search box and write (iphone6)and click on go button then opened diff prise iphones in next page but u can select 30,000 to 90,000 list pls write code?
2 Answers FFASVA, Genpact, Wipro,
In Test Director bug rEPORTS, wHAT ARE THE CONTENTS(fIELDS)? iF yoU PREAPARE BUG REPORT IN eXCEL sHEET , hOW U SEND TO dEVELOPMENT TEAM THRW T.D?
The Senario is Steps to do 1.Entered userid in textbox 2.saved with details 3.i want to open user which i have created its in hurry.....
we have a link in a website or webtable How can we record link in that table or site? link is not static we don't know exact location of that link? how ? if u know pls give reply with script also?
6 Answers Cognizant, Covansys,
What are the Mandatory Properties of WebTable Object and Link Object in Web testing using QTP
Hi am New to Automation Testing , any one can you help me what are the basic questiion are asked an interview?
HoW to open QTP in Real time.after getting the qtp window how to log in .pl answer real time people
Please let know the scripts for counting number of repeated letters in the word. Note repeated letter should not be count agian. Ex: If "Hello" is my word... l is coming twice.. it should count once and print... secong 'l' should not count again..
How does QTP identifies the object in the application?