how to get column count

[Ishul]

Hi All,

how to get the number of columns present in webtable,
as we know the number of rows as rowcount , is there any function for dat.
can any one suggest me how to do.




Thanks in advance

[vIns]

Code:

WebTable().ColumnCount(RowNumber)

[Ishul]

Code:

vf.sheets(1).usedrange.rows.count

we have this method for getting no. of active rows in excel sheet,

but how to get for columns.

[sshukla12]

Hi,

U can use

Code:

col_Count=ExcelSheet.usedrange.columns.count

Regards,
Sankalp

[Vswarna]

Hi,

Please tell how to get the no of columns from a specific sheet of datatble?

Thanks,
Swarna

[ssvali]

Below is used to get column count from a specific sheet of datatable

Code:

DataTable.GetSheet("sheet name"/sheetid).getparametercount

Ex:- Column Count from GlobalSheet
ColCnt = DataTable.GetSheet(1).getparametercount
msgbox ColCnt