I want to assign values in a table in my software, in first column i will give v

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.

Question Posted / azjk786

4 Answers
4849 Views
TCS, Wipro, I also Faced
E-Mail Answers

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