python往excel特定单元格中写入文本_将值写入python中pandas中工作表中的特定单元格...

UPDATE2：将数据附加到现有Excel工作表,保留其他(旧)工作表：

import pandas as pd

from openpyxl import load_workbook

fn = r'C:\Temp\.data\doc.xlsx'

df = pd.read_excel(fn, header=None)

df2 = pd.DataFrame({'Data': [13, 24, 35, 46]})

writer = pd.ExcelWriter(fn, engine='openpyxl')

book = load_workbook(fn)

writer.book = book

writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

df.to_excel(writer, sheet_name='Sheet1', header=None, index=False)

df2.to_excel(writer, sheet_name='Sheet1', header=None, index=False,

startcol=7,startrow=6)

writer.save()

更新：您的Excel文件没有标题,因此您应该相应地处理它：

In [57]: df = pd.read_excel(fn, header=None)

In [58]: df

Out[58]:

0 1

0 abc def