python-3.x - (openpyxl) FileNotFoundError : [Errno 2] No such file or directory

Question

from os import listdir
from openpyxl import load_workbook, Workbook

files = listdir(r'C:\Users\MyID\Desktop\auto_task\examples\06')
result_xlsx = Workbook()
result_sheet =result_xlsx.active

for file in files:
    if file[-4:] != 'xlsx':
        continue

    tg_xlsx = load_workbook(file, read_only=True)
    tg_sheet = tg_xlsx.active

    for row in tg_sheet.iter_rows():
        row_data = []
        for cell in row:
            row_data.append(cell.value)
        result_sheet.append(row_data)

result_xlsx.save('result.xlsx')

一直在看书练习openpyxl模块，出现错误。

FileNotFoundError: [Errno 2] No such file or directory: '2017.12.1.xlsx'

如你所见，我把具体路径写在了files = listdir....我还有一个名为 2017.12.1.xlsx

的 excel 文件

有什么问题吗？

Answer 1

您需要提供文件的完整路径 --> load_workbook(os.path.join(path, file), read_only=True)

例如:

path = r'C:\Users\MyID\Desktop\auto_task\examples\06'
files = listdir(path)
result_xlsx = Workbook()
result_sheet =result_xlsx.active

for file in files:
    if file[-4:] != 'xlsx':
        continue

    tg_xlsx = load_workbook(os.path.join(path, file), read_only=True)
    tg_sheet = tg_xlsx.active

    for row in tg_sheet.iter_rows():
        row_data = []
        for cell in row:
            row_data.append(cell.value)
        result_sheet.append(row_data)

result_xlsx.save('result.xlsx')