Row count is always shown as 1 - 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: Row count is always shown as 1 (/Thread-Row-count-is-always-shown-as-1) |
Row count is always shown as 1 - Harry1999 - 04-14-2016 Hi, I am writing a piece of code to copy data from a web table to an excel sheet. I don't understand why I am getting row count and column count 1. Is there something else that I need to add? Here is my code: Dim XL Set XL=createobject("Excel.Application") XL.Workbooks.Open "D:\QTP\RailwaysforSurat.xlsx" Set nsheet = XL.Sheets.Item(1) row=Browser("title:=.*").Page("title:=.*").WebTable("html tag:=TABLE", "index:=0").GetROProperty("rows") msgbox row cols=Browser("title:=.*").Page("title:=.*").WebTable("html tag:=TABLE", "index:=1").GetROProperty("cols") msgbox cols This not complete code. I have trouble getting rows and columns count. Please help! Thanks, Harry P.S. I am using this website for the testing "http://www.indianrail.gov.in/cgi_bin/inet_trnnum_cgi.cgi" |