from openpyxl import Workbook
from openpyxl import load_workbook
import os
if os.path.exists("sample.xlsx"):
wb = load_workbook("sample.xlsx")
ws = wb.active
else:
wb = Workbook()
ws = wb.active
ws.append(['a1', 'a2', 'a3'])
ws.append([1, 2, 3])
# Save the file
wb.save("sample.xlsx")
参考:
https://blog.csdn.net/qq_33431368/article/details/84777906
https://www.cnblogs.com/k0k000/p/14845300.html