python - 在系统中找不到文件

Question

import pandas
import xlwings as xw
A = pandas.read_excel('Thali Details.xls', sheet_name='A')
sheet = xw.Book(r'D:\Taha\Python\Test Codes\Thali Details.xls').sheets("A")
count = 2
count = count + 1
cell = "D" + str(count)
Scan = input('ID:')
RFID_A = A['RFID']
list_A = list(RFID_A)
Status = A['Status']
for x, y in zip(RFID_A, Status):
if int(Scan) == x:
    while int(Scan) == x:
        if y == 'Start':
            print('Thali scanned successfully')
            sheet.range(x).value = "tick"
            break
        else:
            print('Thali Stop')
            break
else:
    while int(Scan) != x:
        for x, y, in zip(RFID_A, Status, ):
            if int(Scan) == x:
                if y == 'Start':
                    print('Thali scanned successfully')
                    break
                else:
                    print('Thali Stop')
                    break


Scan = input('ID: ')

我收到此错误“pywintypes.com_error: (-2147024894, '系统找不到指定的文件。', 无, 无)”我应该怎么做，因为我什至提供了路径

标签： python

Answer 1

如其所述，找不到该文件。
打开 CMD 和命令IF EXIST "D:\Taha\Python\Test Codes\Thali Details.xls" ECHO File exists.，如果输出File exists，请更新问题并告诉我们。