擅长:python、mysql、java
<p>我同意上面的说法,因为窍门是用熊猫。下面的例子展示了如何在不同的工作表中创建一个excel文件。在</p>
<pre><code>import numpy as np
import pandas as pd
# create two 1 D arrays
A1d1 = np.full((5),fill_value=1)
B1d2 = np.full((5),fill_value=2)
# create one 2 D array
C2d3 = np.full((5,5),fill_value=3)
# convert to pandas DataFrames
A1d1_df = pd.DataFrame(A1d1)
B1d2_df = pd.DataFrame(B1d2)
C2d3_df = pd.DataFrame(C2d3)
# Use pandas Excel Writer to create one Excel file with
# a sheet for each array
with pd.ExcelWriter('yourexcelfile.xlsx') as writer:
A1d1_df.to_excel(writer, sheet_name='A1d1')
B1d2_df.to_excel(writer, sheet_name='B1d2')
C2d3_df.to_excel(writer, sheet_name='C2d3')
</code></pre>