Was passiert bei dir in folgender Zeile?
Code: Alles auswählen
SOURCE_PATH = Path("test.xlsx")
Redeclared 'SOURCE_PATH' defined above without usage
File "C:\Users\t3wa893\PycharmProjects\TestProject\main.py", line 48, in <module>
main()
File "C:\Users\t3wa893\PycharmProjects\TestProject\main.py", line 42, in main
for signal_name, test_name_to_id in process_tests(iter_tests(SOURCE_PATH)):
File "C:\Users\t3wa893\PycharmProjects\TestProject\main.py", line 17, in iter_tests
workbook = load_workbook(file_path)
File "C:\Users\t3wa893\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\reader\excel.py", line 315, in load_workbook
reader = ExcelReader(filename, read_only, keep_vba,
File "C:\Users\t3wa893\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\reader\excel.py", line 124, in __init__
self.archive = _validate_archive(fn)
File "C:\Users\t3wa893\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\reader\excel.py", line 96, in _validate_archive
archive = ZipFile(filename, 'r')
File "C:\Users\t3wa893\AppData\Local\Programs\Python\Python310\lib\zipfile.py", line 1240, in __init__
self.fp = io.open(file, filemode)
FileNotFoundError: [Errno 2] No such file or directory: 'test.xlsx'
Ohne die oben genannte Zeile sieht es wie folgt aus:
> Signal_1
{'Test A': 'Test_ID_1',
'Test B': 'Test_ID_2',
'Test C': 'Test_ID_3',
'Test D': 'Test_ID_4',
'Test E': 'Test_ID_5',
'Test F': 'Test_ID_6',
'Test G': 'Test_ID_7'}
> Signal_2
{'Test A': 'Test_ID_12',
'Test B': 'Test_ID_23',
'Test C': 'Test_ID_33',
'Test D': 'Test_ID_47',
'Test E': 'Test_ID_53',
'Test F': 'Test_ID_69',
'Test G': 'Test_ID_71'}
> Signal_3
{'Test A': 'Test_ID_14',
'Test B': 'Test_ID_22',
'Test C': 'Test_ID_38',
'Test D': 'Test_ID_47',
'Test E': 'Test_ID_54',
'Test F': 'Test_ID_60',
'Test G': 'Test_ID_74'}