Hi.....all
How to retrieve the values by using the Getcelldata and setcelldata.is it only applicable for Web based application .Then how to use this.I tried with yahoo.
Is tis one correct and what is the actuall use of doing this...
Code:
Dim i,j
For i=1 to Row count
For j=1 to column count
msgbox browser("Yahoo! Mail: The best").Page("Yahoo! Mail: The best").WebTable("Yahoo! ID:").GetCellData (i,j)
Next
Next
Pls anyone answer me.............
Hi all,
**********getting the rowcount**********
Code:
var=SAPGuiSession("Session").SAPGuiWindow("Create Sales Order: Initial").SAPGuiTable("Distribution Channel").rowcount
msgbox var
*********Getting the cell data for the particular row and column*********
Code:
SAPGuiSession("Session").SAPGuiWindow("Create Sales Order: Initial").SAPGuiTable("Distribution Channel").getcelldata(1,"Material")
1 is row number
Material is columnname of the GuiTable
Hi rajeshdizzy ,
i think you know the use with getcell data and setcelldata.
You can use the following code. For better understanding purpose please use one column and get all data from all the rows based on the column and then move to another column.
'One more thing is we should specify the row number while getting the column count.
'--------------------------------------------------------------------------------------
Code:
For i= 1 to Browser("SAM").Page("SAM").WebTable("Database:").ColumnCount(1)
For j = 1 to Browser("SAM").Page("SAM").WebTable("Database:").RowCount
Msgbox "Data from Column # " & i & ",Row # " & j &" is ''"& Browser("SAM").Page("SAM").WebTable("Database:").GetCellData(j,i) & "''."
Next
Next
'--------------------------------------------------------------------------------------
Let me know if you need any more info.
Hi...King....
i cannot understand anything.....explain with an example of any website like yahoo or gmail.............and want 2 know wat is the use of doin this and wat to check?
Hi dizzy,
see the example below,
for getting the rowcount for the webtable,SAPGuiTable etc., ,use rowcount method.
Code:
var=SAPGuiSession("Session").SAPGuiWindow("Create Sales Order: Initial").SAPGuiTable("Sales Order").rowcount
msgbox var
here getting how many rows present in the GuiTable
for i=1 to var
var1=SAPGuiSession("Session").SAPGuiWindow("Create Sales Order: Initial").SAPGuiTable("Sales Order").GetCellData(i,"Material")
msgbox var1
next
here we can get the cell data upto the loop will exit.
for set the cell data in the SAPGuiTable
Code:
SAPGuiSession("Session").SAPGuiWindow("Create Sales Order: Initial").SAPGuiTable("Sales Order").SetCellData 1,"Material","100"
1 is row name
"Material" is column
"100" is data
here i have explained for SAP application ,this script same for web application also.