07-16-2009, 07:01 PM
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.
'--------------------------------------------------------------------------------------
'--------------------------------------------------------------------------------------
Let me know if you need any more info.
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.
Thanks,
SUpputuri
SUpputuri