python pandas向已有excel添加新表sheet/添加行数据
import pandas as pd
from openpyxl import load_workbook
writer = pd.ExcelWriter(excel_name,engine='openpyxl')# pylint: disable=abstract-class-instantiated
one_img_info = ['file', 1]
one_img_info = pd.Dataframe(one_img_info)
# 创建新excel
if not os.path.exists(excel_name):
one_img_info.to_excel(writer, sheet_name=dir_i, index = False)
else:
# 1.向已有excel创建新sheet
book = load_workbook(excel_name)
writer.book = book
one_img_info.to_excel(writer, sheet_name=dir_i, index = False)
# 2.向已有excel添加新行(注释上面三行)
# df= pd.Dataframe(pd.read_excel(excel_name,sheet_name=dir_i), index=None)
# out_df = pd.concat([df,one_img_info],axis=0)
# out_df.to_excel(writer, sheet_name=dir_i, index = False)
writer.save()
writer.close()
