Executing a script for every row in a table using Python and Selenium

Question

Executing a script for every row in a table using Python and Selenium

As a newcomer to Python and Selenium, I have been struggling with a specific task for days now. Despite my efforts to search and experiment, I find myself completely stuck.

My goal is to access sales records within a table that contains information about each order. The challenge lies in clicking on the "View sales record" option for every sale on the page and opening each record in a different tab.

The only code that seems to work for me so far is:

driver.execute_script("document.querySelector('#LineActions > div > div > div.mu-ov-w.mu-d-ov > div > div.mu-ov-c1 > div > div > table > tbody > tr > td > ul > li:nth-child(3) > a').click();")

However, this script only opens the sales record for the first order. I am unsure of how to proceed to open records for all other orders.

The tables displaying sales records are structured as follows:

<table id="tbl_mu_active_tbl_id"....>
    <thead class="dt-cs" id="tbl_mu_active_tbl_id_h_0">
        ....
    <tbody class="dt-rs dt-cs">
        <tr class="dt-sh dt-slb dt-fr" id="mu_active_tbl_id_0">
        ....
    <tbody class="dt-nsb">
        ....
    <tbody class="dt-rs dt-cs">
        <tr class="dt-sh dt-slb dt-fr" id="mu_active_tbl_id_1">
        ....

The rows containing relevant information increment their IDs by one. For example,

#tbl_mu_active_tbl_id > tbody:nth-child(2)

refers to the first row, while

#tbl_mu_active_tbl_id > tbody:nth-child(4)

pertains to the second row, and so forth.

I have attempted various methods to iterate through these rows but have not been successful in executing the script for any other row besides the first one.

Therefore, my current questions are:

How can I ensure the script runs on each row of the table?

Is there a way to modify the script to open the link in a new tab?

python html selenium html-table

Answer 1

Answer №1

If you want to run a script on each row of a table, the first step is to gather all elements within that table and store them in an array. Then, simply loop through the array. This task can be easily accomplished using the find_elemens_by_xpath method like this:

table = driver.find_element_by_id('tbl_mu_active_tbl_id')
rows = table.find_elements_by_xpath('//tbody')  #Find all tbody elements inside the table

Next, iterate through the rows array:

If you need help with opening a new tab, check out this resource: Open web in new tab Selenium + Python

from selenium import webdriver
from selenium.webdriver import ActionChains
from selenium.webdriver.common.keys import Keys

actions = ActionChains(driver)
for i in rows:
    actions = ActionChains(driver)
    actions.key_down(Keys.CONTROL).click(i).key_up(Keys.CONTROL).perform()

It's important to proceed with caution when dealing with new tabs as switching to the new tab window to continue executing scripts may pose a challenge. For guidance on handling this situation, refer to: Selenium webdriver using switch_to_windows() and printing the title doesn't print the title.

Answer 2

If you want to run a script on each row of a table, the first step is to gather all elements within that table and store them in an array. Then, simply loop through the array. This task can be easily accomplished using the find_elemens_by_xpath method like this:

table = driver.find_element_by_id('tbl_mu_active_tbl_id')
rows = table.find_elements_by_xpath('//tbody')  #Find all tbody elements inside the table

Next, iterate through the rows array:

If you need help with opening a new tab, check out this resource: Open web in new tab Selenium + Python

from selenium import webdriver
from selenium.webdriver import ActionChains
from selenium.webdriver.common.keys import Keys

actions = ActionChains(driver)
for i in rows:
    actions = ActionChains(driver)
    actions.key_down(Keys.CONTROL).click(i).key_up(Keys.CONTROL).perform()

It's important to proceed with caution when dealing with new tabs as switching to the new tab window to continue executing scripts may pose a challenge. For guidance on handling this situation, refer to: Selenium webdriver using switch_to_windows() and printing the title doesn't print the title.

Executing a script for every row in a table using Python and Selenium

Answer №1

Similar questions

Using JavaScript to ensure that a div is not hidden on page load if a checkbox is unchecked

After attempting to refresh the webpage with the F5 key, I noticed that the jQuery progress bar was not functioning properly. Additionally, the webpage failed to display any

Encountering an inexplicable "undefined" error in HTML after receiving an

Is there a way to embed an AJAX submit form into a notification without the need for page refresh?

Skipping every third index in a JQuery .each loop after removing an element

Is there a way to activate the width styling from one class to another?

Determining the visible dimensions of an iframe

Simple 3-column grid design in HTML and CSS

Using the Play framework to showcase data in an HTML table

How can I disable image loading in Internet Explorer using Selenium and Java?

The certificate verification process encountered an error: unable to retrieve the local issuer certificate

Retrieve the content of a different page and store it as a variable using ajax

Tips for wrapping text within a span element that is positioned absolutely

Issue with SciPy installation on Windows: Unsupported wheel format for f.whl on this system

Eliminating Inferior Strategies in Competitive Games

Encountering a RuntimeError when attempting to run a JustPy web app on Jupyter

Using React.js to create table cells with varying background colors

The background-size property in CSS does not seem to properly display on iPhones

The send_keys() function in Selenium version 3.141.0 works perfectly on Windows, but unfortunately, it is not functioning correctly on Linux Debian 11

Is it possible to produce data on the server and then transmit it to the client?