mmbhatti
New Member
- Joined
- Mar 5, 2023
- Messages
- 8
- Office Version
- 365
- 2019
- 2016
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
I am trying to scrape data from website on bases of product name. There are different rows in web table for a unique product. Some have single row from which I have to grab data, some have two rows and some contain multiple rows. What I want to do is count the number of rows of that product, and then want to run Loop one by one as much times as rows of the product.
Xpath for that matching rows is
This xpath gives the all rows on which I have to work further. How can I count number of these rows and store to use in a loop.? I am using Chrome browser for automation.
Any suggestion and help is much needed and warmly appreciated. Thanks in advance.
Xpath for that matching rows is
VBA Code:
//td[contains(., 'Product Name') /parent::tr
This xpath gives the all rows on which I have to work further. How can I count number of these rows and store to use in a loop.? I am using Chrome browser for automation.
Any suggestion and help is much needed and warmly appreciated. Thanks in advance.