Counting the number of rows(tr) in a table(html) in a website using selenium in VBA

[Gautamsunil]

Hi all
I am extracting data of individual student from an institute's website into excel spreadsheet for further manipulation. Though the number of questions in the website are same for all, number of answers differ from one student to another depending upon the number questions he answered. Because of this reason, for the same topic, one student has 5 rows in the table and the other has 7 rows in the same table. I am guessing counting the number of rows in that particular table in the website and then applying if else condition will solve the issue. How can I count the number of rows in a table in a website?
I have tried few codes I found around but ran into problem every single time.
I am using selenium basic to allow extraction through chrome. I have done same thing through Internet Explorer without having any issues.
Any help would be much appreciated as I have spent hours trying to solve this.
Thanks in advance.

 

[John_w]

Try this:

    Dim theTable As WebElement
    '...... your code to get the table
    Debug.Print theTable.FindElementsByTag("TR").Count

 

[Gautamsunil]

Try this:

    Dim theTable As WebElement
    '...... your code to get the table
    Debug.Print theTable.FindElementsByTag("TR").Count

Thanks a lot. This was exactly what I needed.

 

[Marc L]

John,​

​

as a web table as a rows collection so you can directly extract {table object}.rows.length …​

 

[John_w]

Marc, the rows property isn't available for me. These are the only properties available:

 

[Marc L]

Ok I was thinking of DOM under IE but it not exists under selenium, so weird …​

 

[John_w]

Yes, it's odd that the Selenium library has only one generic class (WebElement), whereas the MS HTML library has a specific class for many HTML elements.