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



I want to assign values in a table in my software, in first column i will give values, table is of 4..

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

I want to assign values in a table in my software, in first column i will give values, table is of 4..

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

I want to assign values in a table in my software, in first column i will give values, table is of 4..

Answer / pravati

Datatable.Getsheet(id)
Datatable.value(4,4)=values

Is This Answer Correct ?    0 Yes 1 No

I want to assign values in a table in my software, in first column i will give values, table is of 4..

Answer / pravati

Datatable.Getsheet(id).setcurrentrow(4)
Datatable.value(shtid,4)=value

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More QTP Interview Questions

Hi, Plz give best Definition of Software Testing? Why we need Software Testing? and plz send 2+yrs experience Interview qutions (Manual,Qtp).

1 Answers  


Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

0 Answers  


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.

2 Answers   Banking,


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?

1 Answers  






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

1 Answers  


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

2 Answers   iLink,


Hi am New to Automation Testing , any one can you help me what are the basic questiion are asked an interview?

0 Answers  


HoW to open QTP in Real time.after getting the qtp window how to log in .pl answer real time people

3 Answers   GE,


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

1 Answers  


How does QTP identifies the object in the application?

1 Answers   Crea,


Categories