openpyxl无法打开xlxs文件

Question

尝试使用python首次使用openpyxl打开excel文件。我知道文件就在那里，它在excel中可以很好地打开。我列出了python脚本中的目录，它也显示了该文件。但是当我尝试用openpyxl打开它时，它返回一个错误，说它不支持xlxs文件格式，只是在支持的格式列表中告诉我xlxs是受支持的。 完全糊涂了。这么简单的一件事，我是不是做错了什么

代码如下：

def run():

sourceMiles = input("Enter mileage source file:" )
print("source=",sourceMiles)

arr = os.listdir()
print(arr)
#open the workbook to the first sheet
wb = openpyxl.load_workbook(sourceMiles)
# Read the active sheet:
sheet = wb.active

print("c,4=", sheet["C4"].value)

下面是控制台输出：

    Enter mileage source file:mileageTable.xlxs
source= mileageTable.xlxs
['anonymizer', 'firstProject.qgz', 'generateBurndownReport.py', 'KPIs', 'landLayer.gpkg', 'mileageTable.xlsx', 'MIS 3140 Final Project SQL Code.docx', 'outputs', 'routing app', 'UDBX_Requirements_Ushr_HD_Map_Database_Exchange_Format_Specification.pdf', 'ushr_navigation.zip', '~$mileageTable.xlsx']
Traceback (most recent call last):
  File "c:\Users\cpeddie\Documents\projects\generateBurndownReport.py", line 199, in <module>
    run()
  File "c:\Users\cpeddie\Documents\projects\generateBurndownReport.py", line 93, in run
    wb = openpyxl.load_workbook(sourceMiles)
  File "C:\Users\cpeddie\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\excel.py", line 315, in load_workbook
    reader = ExcelReader(filename, read_only, keep_vba,
  File "C:\Users\cpeddie\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\excel.py", line 124, in __init__
    self.archive = _validate_archive(fn)
  File "C:\Users\cpeddie\AppData\Local\Programs\Python\Python39\lib\site-packages\openpyxl\reader\excel.py", line 94, in _validate_archive
    raise InvalidFileException(msg)
openpyxl.utils.exceptions.InvalidFileException: openpyxl does not support .xlxs file format, please check you can open it with Excel first. Supported formats are: .xlsx,.xlsm,.xltx,.xltm

谢谢你的帮助