擅长:python、mysql、java
<p>使用熊猫数据帧!</p>
<pre><code>import pandas as pd
array = [['a1', 'a2', 'a3'],
['a4', 'a5', 'a6'],
['a7', 'a8', 'a9'],
['a10', 'a11', 'a12', 'a13', 'a14']]
df = pd.DataFrame(array).T
df.to_excel(excel_writer = "C:/Users/Jing Li/Desktop/test.xlsx")
</code></pre>
<p>excel_writer是str或现有ExcelWriter对象中的文件路径。</p>