Hi,

Please guide me to resolve the error: xlrd.biffh.XLRDError: Excel xlsx file; not supported

temp.py file:

from testresources.dataReading import XLSReader


def getData():
    xls = XLSReader("C:\\Git_Data\\automationFrameworks\\DataDrivenFramework\\testresources\\DDF.xlsx")
    print(xls.readXLS.sheet_by_name("sheet1").cell_value(2,1))


getData()

Output:

Traceback (most recent call last):
  File "C:/Git_Data/automationFrameworks/DataDrivenFramework/temp.py", line 9, in <module>
    getData()
  File "C:/Git_Data/automationFrameworks/DataDrivenFramework/temp.py", line 5, in getData
    xls = XLSReader("C:\\Git_Data\\automationFrameworks\\DataDrivenFramework\\testresources\\DDF.xlsx")
  File "C:\Git_Data\automationFrameworks\DataDrivenFramework\testresources\dataReading.py", line 8, in __init__
    self.readXLS = xlrd.open_workbook(path)
  File "C:\Users\valergau\PycharmProjects\ShoppingDemo\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

For your reference - dataReading.py:

import xlrd
import xlwt


class XLSReader:
    def __init__(self, path):
        self.path = path
        self.readXLS = xlrd.open_workbook(path)