擅长:python、mysql、java
<p>有更简单的方法。xlsxwriter文档(链接<a href="http://xlsxwriter.readthedocs.io/working_with_pandas.html" rel="nofollow noreferrer" title="XlsxWriter working with pandas">here</a>)中提供了一个示例。<br/>
我在下面贴了一个很简单的例子。我还添加了三个示例数据帧,这样任何人都可以复制这个示例。还有一系列可选参数可用于dataframe.to\u excel你可能会感兴趣,这些在熊猫文档中有概述。(链接<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_excel.html" rel="nofollow noreferrer">here</a>)。在</p>
<pre><code>import pandas as pd
df_1 = pd.DataFrame({'Data_1': [10, 20, 30, ]})
df_2 = pd.DataFrame({'Data_2': [20, 30, 40]})
df_3 = pd.DataFrame({'Data_3': [30, 40, 50]})
# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('abcd.xlsx', engine='xlsxwriter')
# Convert the dataframe to an XlsxWriter Excel object.
df_1.to_excel(writer, sheet_name='img_reshape')
df_2.to_excel(writer, sheet_name='column_sum')
df_3.to_excel(writer, sheet_name='row_sum')
writer.save()
</code></pre>