python操作excel一个sheet，其他sheet内容不变

用ExcelWriter

import openpyxl

from openpyxl import load_workbook

import pandas as pd

excel_file = 'D:/test.xlsx'

df = pd.DataFrame(pd.read_excel(excel_file,'Sheet1'))
df = df.loc[:['A','B']]#对目标Sheet进行处理，本案例作删除列处理，仅保留AB两列数据
wb = openpyxl.load_workbook(excel_file)   #加载已知excel文件
# 使用ExcelWriter() 对象调用to_excel()方法进行保存，这样原文件其他Sheet内容不变
writer = pd.ExcelWriter(excel_file) 
writer.book = wb
df.to_excel(writer,sheet_name='Sheet1',index=False)

writer.save()
writer.close()