Selenium Python I can iterate over the html table how do I print the values from column 3

Question

I have a HTML table with some rows and columns. I can iterated over the rows and print out all of the column values. I would like to print the values from column 3. How do I do this?

The HTML snippet is:

    <table id="search_data_browser_ct_data_browser" class="GFNQNVHJE" cellspacing="0" __gwtcellbasedwidgetimpldispatchingfocus="true" __gwtcellbasedwidgetimpldispatchingblur="true">
<thead aria-hidden="false">
<colgroup>
<tbody>
<tr class="GFNQNVHCD GFNQNVHJD" __gwt_subrow="0" __gwt_row="0">
<td class="GFNQNVHBD GFNQNVHDD GFNQNVHED GFNQNVHKD">
<div __gwt_cell="cell-gwt-uid-193" style="outline-style:none;">
<span class="linkhover" title="31" style="white-space:nowrap;overflow:hidden;text-overflow:ellipsis;empty-cells:show;display:block;color:#00A;cursor:pointer;">31</span>
</div>
</td>
<td class="GFNQNVHBD GFNQNVHDD GFNQNVHKD">
<div __gwt_cell="cell-gwt-uid-194" style="outline-style:none;">1</div>
</td>
<td class="GFNQNVHBD GFNQNVHDD GFNQNVHKD">
<div __gwt_cell="cell-gwt-uid-195" style="outline-style:none;">
<span class="linkhover" title="Mr|Batman|Bane|Male" style="white-space:nowrap;overflow:hidden;text-overflow:ellipsis;empty-cells:show;display:block;color:#00A;cursor:pointer;">Mr|Batman|Bane|Male</span>
</div>
</td>
<td class="GFNQNVHBD GFNQNVHDD GFNQNVHKD">
<td class="GFNQNVHBD GFNQNVHDD GFNQNVHKD">
<td class="GFNQNVHBD GFNQNVHDD GFNQNVHOD GFNQNVHKD">
</tr>
<tr class="GFNQNVHCE" __gwt_subrow="0" __gwt_row="1">
<tr class="GFNQNVHCD" __gwt_subrow="0" __gwt_row="2">
<tr class="GFNQNVHCE" __gwt_subrow="0" __gwt_row="3">
<tr class="GFNQNVHCD" __gwt_subrow="0" __gwt_row="4">
<tr class="GFNQNVHCE" __gwt_subrow="0" __gwt_row="5">
<tr class="GFNQNVHCD" __gwt_subrow="0" __gwt_row="6">
<tr class="GFNQNVHCE" __gwt_subrow="0" __gwt_row="7">
<tr class="GFNQNVHCD" __gwt_subrow="0" __gwt_row="8">
<tr class="GFNQNVHCE" __gwt_subrow="0" __gwt_row="9">
</tbody>
<tbody style="display: none;">
<tfoot style="display: none;" aria-hidden="true"/>
</table>

My method implementation is:

def is_results_displayed_in_data_browser(self):
try:
    table_id = self.driver.find_element(By.ID, 'search_data_browser_ct_data_browser')
    rows = table_id.find_elements(By.TAG_NAME, "tr")  # get all of the rows in the table
    for row in rows:
        # Get the columns (all the column 2)
        cols = row.find_elements(By.TAG_NAME, "td")  # note: index start from 0, 1 is col 2
        for col in cols:
            print col.text
except NoSuchElementException, e:
    print "Element not found "
    print e
    self.save_screenshot("is_results_displayed_in_data_browser")

I have tried:

print col[2].text

The error I get is:

    Traceback (most recent call last):
  File "E:\test_runners 2 edit project\selenium_regression_test_5_1_1\LADEMO_Matching_and_Reporting_TestCase\Lademo_Matching_and_Reporting_TestCase.py", line 496, in test_000008_simple_text_search
    data_browser_page.is_results_displayed_in_data_browser()
  File "E:\test_runners 2 edit project\selenium_regression_test_5_1_1\Pages\Reports\reports_data_browser.py", line 104, in is_results_displayed_in_data_browser
    print col[2].text
TypeError: 'WebElement' object does not support indexing

I have also tried:

for col in cols:
print cols[2].text

I get the error:

    Traceback (most recent call last):
  File "E:\test_runners 2 edit project\selenium_regression_test_5_1_1\Base\BaseTestCase.py", line 174, in tearDownClass
    cls.login_page.click_logout()
  File "E:\test_runners 2 edit project\selenium_regression_test_5_1_1\Pages\login.py", line 129, in click_logout
    self.click_yes_from_confirm_dialog_to_confirm()
  File "E:\test_runners 2 edit project\selenium_regression_test_5_1_1\Pages\base.py", line 106, in click_yes_from_confirm_dialog_to_confirm
    yes_button_element = WebDriverWait(self.driver, 20).until(EC.element_to_be_clickable((By.ID, 'message_dialog_b_yes')))
  File "E:\Python27\lib\site-packages\selenium\webdriver\support\wait.py", line 80, in until
    raise TimeoutException(message, screen, stacktrace)
TimeoutException: Message:

Thanks, Riaz

Your error is in this code block and not int the code which you have mentioned above. yes_button_element = WebDriverWait(self.driver, 20).until(EC.element_to_be_clickable((By.ID, 'message_dialog_b_yes'))) — saurabh baid
– saurabh baid, Commented Sep 26, 2016 at 9:55
If i do print cols[2].text I get IndexError: list index out of range — Riaz Ladhani
– Riaz Ladhani, Commented Sep 26, 2016 at 12:37
If i do print cols[0].text it prints out all the ID values from the very first column. Strange cols[2] does not work — Riaz Ladhani
– Riaz Ladhani, Commented Sep 26, 2016 at 12:54

Saurabh Gaur · Accepted Answer · 2016-09-26 13:20:07Z

2

'WebElement' object does not support indexing

Actually col is single WebElement while you'r assumming list, so It should be

print cols[2].text

If i do print cols[2].text I get IndexError: list index out of range

You need to check cols list length before passing index to overcome this error as below :-

if len(cols)  >= 3 :
  print cols[2].text

answered Sep 26, 2016 at 13:20

Saurabh Gaur

23.9k11 gold badges56 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Riaz Ladhani Over a year ago

This works for me. No index out of range anymore. All name values are printed now. Thank you for your help.

Piyush · Accepted Answer · 2016-09-26 10:50:26Z

2

Here I will give you working code in which extract all td tag's value.

from selenium import webdriver
from selenium.webdriver.support.ui import Select
import time

driver = webdriver.Chrome('./chromedriver')

#Open the page
driver.get('file:///.../a.html')

ele = driver.find_elements_by_xpath("//table[@id='search_data_browser_ct_data_browser']/tbody/tr")
for e in ele:
    for td in e.find_elements_by_xpath(".//td"):
        print td.text

answered Sep 26, 2016 at 10:50

Piyush

5214 silver badges13 bronze badges

1 Comment

Riaz Ladhani Over a year ago

Thanks, I have a working code to print out all column values. I would like to print out all values from column 2. How do i print out values from column 2 only using it's index?

saurabh baid · Accepted Answer · 2016-09-26 13:24:28Z

0

I have tried:
print col[2].text

Try This

if len(cols)>2:
    cols[2].text

edited Sep 26, 2016 at 13:24

answered Sep 26, 2016 at 9:58

saurabh baid

1,8771 gold badge17 silver badges28 bronze badges

6 Comments

Riaz Ladhani Over a year ago

print cols[2].text gives me the error IndexError: list index out of range

Riaz Ladhani Over a year ago

If i do print cols[0].text it prints out all the ID values from the very first column. Strange cols[2] does not work.

Riaz Ladhani Over a year ago

Ah it is printing the values from cols[2] now. But at the end of the iteration it says IndexError: list index out of range

saurabh baid Over a year ago

That is because some your row does not have these column. You only have multiple columns in first row. I think you can easily put the logic to handle that.

saurabh baid Over a year ago

I may be able to give you a solution specific to this scenario but a long term solution will based on your actual data and not just the test data.

|

Karlo Abapo · Accepted Answer · 2018-06-27 03:00:55Z

0

You may use CSS Selectors to find the nodes under the td. Use td:nth-child() syntax.

 table_id = self.driver.find_element(By.ID,'tableid')

 rows = table_id.find_elements(By.TAG_NAME, "tr")

 for row in rows:
 cols = row.find_elements_by_css_selector('td:nth-child(2)')
 for col in cols:
     print('this is {}'.format(col.text))

answered Jun 27, 2018 at 3:00

Karlo Abapo

413 bronze badges

Collectives™ on Stack Overflow

Selenium Python I can iterate over the html table how do I print the values from column 3

4 Answers 4

1 Comment

1 Comment

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related