Handle Excel Workbook with QTP

-          Handling Excel:

http://www.qtpworld.com/index.php?cid=44

Set obj = CreateObject(“Excel.Application”)

 

UsedRange.Columns.Count  ‘--to find the number of columns used

     UsedRange.Rows.Count ‘--- to find number of rows used