Get Table data using WebDriver and Python

Following code prints table data. This is just an idea how you can traverse thru table.
your xpath should be something like : "//form[2]/table/tbody"

and you can call this function like ...

self.getTable("//form[2]/table/tbody")

def getTableVersion1(self,locator):

### Locate you table using xpath
table = self._selobj.find_element_by_xpath(locator)

#### This is just to debug....
#### This will print Webelement details like -
print table

### print row content. Entire row in one go.
for tr in table.find_elements_by_tag_name('tr'):
print "Text in TR is " + tr.text

### print cell value
for td in table.find_elements_by_tag_name('td'):
print "Text in TD is " + td.text

Following function prints table cell values.

def getTableversion2(self,locator):

table = self._selobj.find_element_by_xpath(locator)
print "\nEntire Table :\n***\n" + table.text + "\n***"

for tr in table.find_elements_by_tag_name('tr'): ### All rows in the
print "\nTR is " + tr.text ### Prints entire row, header row also...

for td in tr.find_elements_by_tag_name('td'): ### Search for TD tag
print "TD value " + td.text ### Print cell value
else:
print "No TD. May be TH row OR Empty Row"

Output:

Entire Table :
***
Name Domain/IP/Extension Description Keywords Last Modified
afda a.com 10/28/2012 13:53
test t.com 10/30/2012 11:46
***

TR is Name Domain/IP/Extension Description Keywords Last Modified
No TD. May be TH row OR Empty Row

TR is afda a.com 10/28/2012 13:53
TD value afda
TD value a.com
TD value
TD value
TD value 10/28/2012 13:53
TD value
No TD. May be TH row OR Empty Row

TR is test t.com 10/30/2012 11:46
TD value test
TD value t.com
TD value
TD value
TD value 10/30/2012 11:46
TD value
No TD. May be TH row OR Empty Row

To Get the header or field name, you need to search for 'th' instead of 'tr'.
=============================================================================
### number of rows in the given table.
def getRowCount(self,locator):
table = self._selobj.find_element_by_xpath(locator)
return (len(table.find_elements_by_tag_name('tr')))

### number of columns in the given table. Hope your table has TH row in it.

def getColCount(self,locator):
table = self._selobj.find_element_by_xpath(locator)
tr = table.find_elements_by_tag_name('tr')
return (len(tr[0].find_elements_by_tag_name('th')))

Comments

Post a Comment

Popular posts from this blog

Selenium: File download handling.

Image
 When we download any file from internet, browser opens new pop-up windows and prompt user for action. Action could be open, save or save as.  Pop-up windows ( GUI ) could be different based on browser. When you are automating file download dialog box (or action), you should keep following points in mind. -           Browser -           Pop-up windows  title -           Pop-up GUI -           Available buttons on GUI -           File Type (Binary file, zip file, MS file etc..) -           Extra settings See how IE and FF pop-ups ... If you have any doubt or if it is not working , please provide me details and I will try to fix the problem. Func Down_FF_NonMS() Send("{TAB}{TAB}...
Read more

Major Differences between Python and Java

Image
Python and Java are both popular programming languages that have been around for many years. While they share some similarities, there are also some key differences between them. Syntax: One of the most obvious differences between Python and Java is their syntax. Python is known for its simple, readable syntax, which is designed to be easy to learn and use. Java, on the other hand, has a more complex syntax that requires more code to accomplish the same tasks. Performance: Java is generally faster than Python when it comes to execution speed. This is because Java code is compiled into bytecode, which can be executed directly by the Java Virtual Machine (JVM). Python, on the other hand, is an interpreted language, which means that each line of code is executed one at a time by the Python interpreter. Memory Management: Java manages memory through a process called Garbage Collection. This process automatically frees up memory that is no longer in use, which helps to prevent memory leaks ...
Read more

Cypress V/S Selenium

  Cypress V/S Selenium During my learning of Cypress, I noted down a few important differences between these tools. Documentation: Cypress Selenium Feature Cypress Selenium Language Support JavaScript Multiple languages including Java, C#, etc. Test Architecture Mocha test runner and Chai assertion library built-in Requires separate test frameworks and assertion libraries Browser Support Chrome, Firefox, Electron Multiple browsers including Chrome, Firefox, Safari, Edge, etc. Test Structure Built-in test runner and assertion library Needs separate test runners and assertion libraries Test Execution Faster execution Slower execution due to the use of WebDriver DOM Manipulation Native commands for DOM manipulation Needs to use JavaScriptExecutor for DOM manipulation Locators Cypress uses jQuery-like syntax for selecting elements Selenium uses various locating strategies such as XPath, CSS Selector, etc. Automatic Waits Automatically waits for commands to complete before moving...
Read more