Getcelldata and Setcelldata

[rajeshdizzy]

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

[balakrish]

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

[supputuri]

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.

[rajeshdizzy]

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?

[balakrish]

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.