How to get the total no. of columns used for a particular row

[kumsweta]

my code says .
DataTable.SetCurrentRow (2)
now i need to retrive the total number of column used in 2 nd row ..
is there any syntax
what is the substitute of "ddt_get_parameters" used in Winrunner in QTP ..

please reply asap

[sreekanth chilam]

Hi Swetha,

For retrieving the columns(Parameters) count in datatable, check the below code.

Code:

datatable.GetSheet("Sheetname").GetParameterCount

Try it n See .... u will get the columns count for any sheets in datatable easily...


Regards,
Sreekanth CR
sreekanth.chilam@gmail.com

[kumsweta]

Hi Sreekanth ,
This code retrives total column count of the sheet .
I want to retrieve column count of just 1 particular row ..
suppose i have 3 row .. 1 row has 6 colunm and 2 nd one has 3
third one has 4 .. so how to retrive the column count of 2nd row
please reply asap

[kumsweta]

Hi Sreekanth ,
This code retrives total column count of the sheet .
I want to retrieve column count of just 1 particular row ..
suppose i have 3 row .. 1 row has 6 colunm and 2 nd one has 3
third one has 4 .. so how to retrive the column count of 2nd row
please reply asap

[bfakruddin]

Code:

Dim rc,cc rc=datatable.GetRowCount msgbox rc For i=2 to 2 cc=datatable.GetSheet("Global").getparametercount msgbox cc Next

[sreekanth chilam]

HI Swetha,

I wrote one user defined function which takes requires row number as an Input argument/Parameter.

1. Refer the below function defination :

Code:

Function Column_Count_Retrieve(Rownumber) Datatable.Getsheet("Global").SetCurrentrow(Rownumber) Temp=0 Col_Count=Datatable.GetSheet("Global").GetParametercount for j=1 to Col_Count Val=Datatable.GetSheet("Global").GetParameter(j).Value if Val<> "" then Temp=Temp+1 end if Next msgbox "Row " &Rownumber&" : "&Temp&" rows" End Function

2. Call the above function as given below :

Call Column_Count_Retrieve(3) ' Calling the function for finding the no. of columns used by 3rd Row
Call Column_Count_Retrieve(1) ' Calling the function for finding the no. of columns used by 1st Row
Call Column_Count_Retrieve(2) ' Calling the function for finding the no. of columns used by 2nd Row

I hope now your requirement has been solved.

[nageshpv]

Hello bfakruddin , i guess you need to change the code.

[bfakruddin]

Sorry,
I have check only 2nd column, not for all rows... Sreekanth given beautiful code...
You can use that...

[Sivakumar Munganda]

Code:

datatable.columncount(rows) webtable.columncount(rows)