Python Pandas:如何在将数据框导出到 Excel 时指定起始单元格位置 [英] Python Pandas: How to specify the starting cell position when exporting dataframe to Excel

问题描述

当使用 xlsxwriter 将数据框从 Pandas 导出到 Excel 时，它似乎默认将表格放在单元格 A1 处.

When a dataframe is exported from Pandas to Excel using xlsxwriter, it seems to put the table at cell A1 by default.

有没有办法改变这种情况?我不介意插入行和列以将表从 A1 移开，只要它是通过 Pandas 或 xlsxwriter 以编程方式完成的.

Is there a way to change this? I don't mind inserting rows and columns to move the table away from A1, as long as it's done programmatically via pandas or xlsxwriter.

如果有帮助，这是我的代码.

In case it helps, here is my code.

writer = pd.ExcelWriter(r'c:\file.xlsx', engine = 'xlsxwriter')
workbook - writer.book
df.to_excel(writer, index=True, sheet_name ='Sheet1')

我也找不到任何用于插入行和列的 XlsxWriter 方法.

I couldn't find any XlsxWriter method for inserting rows and columns either.

推荐答案

to_excel 接受 startrow 和 startcol 参数，它们是从零开始的数字(即 startrow=1 和 startcol=1 会将表格左上角的单元格放在单元格 B2 中).

to_excel accepts startrow and startcol arguments which are zero-based numbers (ie startrow=1 and startcol=1 will put the top left cell of the table in cell B2).

开始:左上角单元格行转储数据帧

startrow : upper left cell row to dump data frame

开始列:左上角单元格列转储数据框

startcol : upper left cell column to dump data frame

这篇关于Python Pandas:如何在将数据框导出到 Excel 时指定起始单元格位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！