Issue with xl file reading | Selenium Python Forum

K

kalpana Posted on 16/04/2021

Hello,

I am getting the following error in execution of file with code to read data from xl file.

Please help what could be the issue.

File "D:\Kalpana\learnbay_python\pytest_training\venv\lib\site-packages\xlrd\__init__.py", line 170, in open_workbook
raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported')
xlrd.biffh.XLRDError: Excel xlsx file; not supported

Thank you

Kalpana

K

kalpana Replied on 18/04/2021

Hello,

I was able to solve the above issue by using openpyxl package instead of xlrd package. I was able to perform operations fine.

In Datadrivenframework project i am facing the below issue. Error says

'genkeywords' object has no attribute 'driver'

this is the link of allure report http://192.168.246.1:64880/index.html#suites/7db21133bf389fa43eef71e3fe0b0e68/6b0d934c37b6a970/

and code file is attatched. Please check and suggest where i am doing wrong.

K

kalpana Replied on 18/04/2021

Hello...

Fixed the issue by referring previous forum queries.

0

Instructor

09914040666 Replied on 14/07/2021

Hey,

Thank you for the update.