Yogesh
Yogesh

Reputation: 15

Which library to import in Python to read data from an Excel file, for automation testing using Selenium?

Which library to import in Python to read data from an Excel file, I want to store different xpaths in Excel file for automation testing using Selenium?

Upvotes: 0

Views: 781

Answers (2)

saket saurabh
saket saurabh

Reputation: 17

You may use XlsxWriter. It is a Python module for writing files in Excel. xlutils is also very useful collection of utilities for automating excel sheet operations.

https://xlsxwriter.readthedocs.io/

Upvotes: 1

Kidus
Kidus

Reputation: 1833

The xlrd library is what you are looking for to read excel files. And to write, you can use xlwt.

Upvotes: 0

Related Questions