简单介绍
有时会遇到只需将爬取的数据填入指定的单元格,而不需要更改Excel格式的情况,或是将一个Excel指定单元格内容复制后插入另一个Excel的单元格。
完整代码
import pandas as pdfrom openpyxl import load_workbookpath=r'D:\sample.xlsx'#原文件路径#读取Excel第7行第5列的值data = pd.read_excel(path)data_1 = data.iloc[6,4]#在另一Excel的第4行第2列插入数据book=load_workbook(r'D:\sample_1.xlsx')writer = pd.ExcelWriter(r'D:\sample_1.xlsx',engine='openpyxl')writer.book = bookwriter.sheets = dict((ws.title, ws) for ws in book.worksheets)data_1.to_excel(writer, sheet_name='sample_sheet',startcol=1,startrow=3, index=False, header=False)#去除索引列和表头名称writer.save()#保存