How to get table data

[GoogleCodeExporter]

Hi Florent,

I am looking to get all the rows and columns of a table (dynamic) in Excel.
(data can have links as well)

Could you please help.

Thanks in advance.

Regards
Rohit

Original issue reported on code.google.com by rohitkbh...@gmail.com on 14 Nov 2014 at 12:35

[GoogleCodeExporter]

There is many ways to achieve it. 

By using the generic function:
 data = driver.findElementById("tbl1").AsTable.GetData()
 Sheet1.[A1].Resize(UBound(data , 1), UBound(data, 2)).Value = data

By looping over elements:
 For Each row In wd.findElementsByCssSelector("#tableid tr")
   For Each cell in row.findElementsByTagName("td")
       Debug.Print cell.Text
   Next cell
 Next row

By using some JavaScript:
 data = driver.executeScript("return ...")

Original comment by florentbr on 17 Nov 2014 at 10:07

• Changed state: Accepted

[vishnuravig]

data = driver.findElementById("tbl1").AsTable.GetData() Why this piece of code fails in IE ?? It says "object reference not set to an instance of the object"

[raspberryNJ]

.AsTable.GetData. --> .AsTable.Data