python - Pandas datframe excel错误

Question

我一直在调试这个脚本并继续得到以下错误

'python3 report_generator_1_5_3.py

从 .\CVB Logix Firmware-Test Run-20210430.xls 打开电子表格...

回溯（最近一次通话最后）：

File "C:\Users\report_generator_1_5_3.py", line 542, in <module>
main()
File "C:\Users\report_generator_1_5_3.py", line 506, in main
[all_data,suite_list] = openSpreadsheet()
File "C:\Users\report_generator_1_5_3.py", line 102, in openSpreadsheet
all_data = pd.read_excel(workbook_name, 1 ,usecols=['Name','Test Stand','Report Location', 'Output Location', 'Status',
File'

这是一些代码

 def openSpreadsheet():
 93     '''Opens spreadsheet generated by qTest, reorders the columns 
 94     and sorts rows by test name'''
 96     #File name of today's regression results
 97     workbook_name = today.strftime('.\Regression\CVB Logix Firmware-Test Run-%Y%m%d.xls')
 98     print(f'Opening spreadsheet from {workbook_name}...\n')
 99 
100     #Turns regression data into dataframe
101     all_data = pd.read_excel(workbook_name, 1 ,usecols=['Name','Test Stand','Report Location', 'Output Lo    cation', 'Status',
102                             'Link to Execution Artifacts', 'Test Case Id','Id', 'Test Case Version',
103                             'Executed Start','Executed End','Execution State','Test 
Suite', 'Test Cycle',     'Test Case Automation Metadata: Script Name'],index=False)'

有什么帮助吗？

标签： pythonpython-3.xexcelpandas