擅长:python、mysql、java
<pre><code>import xlsxwriter
import numpy as np
workbook = xlsxwriter.Workbook('test.xlsx')
worksheet = workbook.add_worksheet('Sheet3')
worksheet.write_column('E10', np.array([1, 2, 3, 4, 5]))
workbook.close()
</code></pre>
<p>要编辑现有文件,请使用以下代码</p>
<pre><code>import openpyxl
import numpy as np
wb = openpyxl.load_workbook("test.xlsx")
sheet = wb["Sheet3"]
arr = np.array([1, 2, 3, 4, 5])
r = 10
for i in range(len(arr)):
sheet.cell(row = r + i, column = 5).value = arr[i]
wb.save("test.xlsx")
</code></pre>