Python-Excel-openpyxl-09-向Excel中写入数据

import os
from openpyxl import load_workbook

root_address = os.path.dirname(os.path.abspath(__file__))
input_folder = "TEST"

folder_address = os.path.join(root_address, input_folder)
list_file = os.listdir(folder_address)
print(list_file)


excel_name = r"openpyxl示例_9_文件清单.xlsx"
excel_address = os.path.join(root_address, excel_name)
print(excel_address)

wb = load_workbook(excel_address)
sht = wb.worksheets[0]

sht["A1"] = "序号"
sht["B1"] = "文件名"

# 清空原有信息
max_row = sht.max_row
max_col = sht.max_column

if max_row > 1 and max_col > 0:
    for row in sht.iter_rows(min_row=2, min_col=1, max_col=max_col, max_row=max_row):
        for cell in row:
            cell.value = ""

for i, ele in enumerate(list_file):
    sht.cell(row=i+2, column=1, value=i+1)
    sht.cell(row=i+2, column=2, value=ele)

wb.save(excel_address)
print("ok")