Micro Focus QTP (UFT) Forums
how to get column count - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: how to get column count (/Thread-how-to-get-column-count)



how to get column count - Ishul - 03-25-2012

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


RE: how to get column count - vIns - 03-25-2012

Code:
WebTable().ColumnCount(RowNumber)



RE: how to get column count - Ishul - 03-27-2012

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.


RE: how to get column count - sshukla12 - 03-27-2012

Hi,

U can use
Code:
col_Count=ExcelSheet.usedrange.columns.count

Regards,
Sankalp


RE: how to get column count - Vswarna - 09-25-2012

Hi,

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

Thanks,
Swarna


RE: how to get column count - ssvali - 09-27-2012

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