import os
from openpyxl.reader.excel import load_workbook
import pandas as pd
def insert(relist, one): # data = [{"pol": one['pol'], "pod": one["pod"], "gc_scac": z["group"], "line": z["line"]} for z in relist] headers = ['pol', 'pod', 'gc_scac', 'line'] # 转换为 DataFrame df = pd.DataFrame(data, columns=headers) # 文件路径 file_path = 'gc_data.xlsx' # 检查文件是否存在 if os.path.exists(file_path): # 如果文件存在,则追加数据 book = load_workbook(file_path) writer = pd.ExcelWriter(file_path, engine='openpyxl') writer.book = book # 获取工作表的数量,用于创建新的工作表 writer.sheets = dict((ws.title, ws) for ws in book.worksheets) df.to_excel(writer, index=False, header=False, startrow=writer.sheets['Sheet1'].max_row) writer.save() else: # 如果文件不存在,则创建文件并添加表头 df.to_excel(file_path, index=False)
标签:insert,python,writer,excel,pol,book,file,path From: https://www.cnblogs.com/angdh/p/18110437