Pandas 和 xlsxwriter:如何在不导出数据帧的情况下创建新工作表? [英] Pandas and xlsxwriter: how to create a new sheet without exporting a dataframe?

问题描述

如果我直接调用 xlsxwriter 模块，很容易在新文件中创建一个新工作表，并写入其单元格，例如:

If I call the xlsxwriter module directly, it is very easy to create a new sheet in a new file, and write to its cells, e.g.:

import xlsxwriter
workbook = xlsxwriter.Workbook('test 1.xlsx')
wks1=workbook.add_worksheet('Test sheet')
wks1.write(0,0,'some random text')
workbook.close()

Howeer，我的问题是:如何使用 Pandas.ExcelWriter 对象创建新工作表?该对象可以在导出数据框时创建新工作表，但是如果我不这样做怎么办没有要导出的数据框?

Howeer, my question is: how can I create a new sheet using a Pandas.ExcelWriter object? The object can create a new sheet when exporting a dataframe, but what if I don't have any dataframes to export?

例如假设我已将 4 个数据帧导出到 4 个单独的工作表，现在我只想在新工作表中写入一些文本.我找到的唯一解决方案是创建一个空数据框，导出它(创建新工作表)，然后写入工作表:

E.g. say I have exported 4 dataframes to 4 separate sheets, and now I just want to write some text to a new sheet. The only solution I have found is to create an empty dataframe, export that (which creates the new sheet), then write to the sheet:

import pandas as pd
writer = pd.ExcelWriter('test 2 .xlsx',  engine='xlsxwriter')
df=pd.DataFrame()
df.to_excel(writer, 'new sheet', index=False, startrow=0,startcol=0)
writer.sheets['new sheet'].write(0,0,'some random text')
writer.close()

还有别的办法吗?add_worksheet() 似乎只是工作簿类的方法，而不是 ExcelWriter

Is there another way? add_worksheet() seems to be a method of the workbook class only, not of ExcelWriter

推荐答案

我认为您的操作方式没有任何问题，但您也可以使用 ExcelWriter 中的 XlsxWriter 工作簿对象，如下所示:

I don't see anything wrong with the way you are doing it but you could also use the XlsxWriter workbook object from the ExcelWriter as follows:

writer = pd.ExcelWriter('test 2 .xlsx', engine='xlsxwriter')

workbook = writer.book
worksheet = workbook.add_worksheet('new sheet')
worksheet.write(0, 0, 'some random text')

这篇关于Pandas 和 xlsxwriter:如何在不导出数据帧的情况下创建新工作表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！