您可以使用python-docx库将表直接写入.docx文件.
如果您使用Conda或使用Anaconda安装Python,则可以从命令行运行命令:
conda install python-docx --channel conda-forge
或者从命令行pip install:
pip install python-docx
安装完成后,我们可以使用它打开文件,添加表格,然后用数据框数据填充表格的单元格文本.
import docx
import pandas as pd
# i am not sure how you are getting your data, but you said it is a
# pandas data frame
df = pd.DataFrame(data)
# open an existing document
doc = docx.Document('./test.docx')
# add a table to the end and create a reference variable
# extra row is so we can add the header row
t = doc.add_table(df.shape[0]+1, df.shape[1])
# add the header rows.
for j in range(df.shape[-1]):
t.cell(0,j).text = df.columns[j]
# add the rest of the data frame
for i in range(df.shape[0]):
for j in range(df.shape[-1]):
t.cell(i+1,j).text = str(df.values[i,j])
# save the doc
doc.save('./test.docx')