<p>我见过的用Python编写excel电子表格的最常见方法是使用<a href="https://openpyxl.readthedocs.org/en/latest/index.html" rel="nofollow">OpenPyXL</a>,这是Python的非本机库。另一个我听说偶尔使用的是<a href="https://xlsxwriter.readthedocs.org/introduction.html" rel="nofollow">XlsxWriter</a>,不过,它也是非本地的。这两个站点都有关于如何最好地使用库的优秀文档,但下面是我为演示<a href="https://openpyxl.readthedocs.org/en/latest/index.html" rel="nofollow">OpenPyXL</a>而编写的一些简单代码:</p>
<pre><code>from openpyxl import workbook
from openpyxl.cell import get_column_letter
workbook = Workbook() # the master workbook
output_file_name = "outfile.xlsx" # what "workbook" will be saved as
worksheet = workbook.active() # all workbooks have one worksheet already selected as the default
worksheet.title = "foo"
worksheet['A3'] = "=SUM(A1, A2)" # set up basic formula
wb.save(output_file_name)
</code></pre>
<p><strong>编辑:</strong>例如,您的请求可以这样写:</p>
<pre><code>## imports and stuff ##
array = [ [a1,a2,a3], [a4,a5,a6], [a7,a8,a9], [a10, a11, a12, a13, a14]]
workbook = Workbook()
worksheet = workbook.active()
numrows = len(array)
letter = 'A'
for r in range(0, numrows):
if r == 0: letter = 'A'
if r == 1: letter = 'B'
if r == 2: letter = 'C'
...
numcols = len(array[r])
for c in range(0, numcols):
worksheet[letter.join(c)] = array[r][c]
</code></pre>
<p>老实说,这可能不起作用,但我太累了,无法测试。我想你已经明白了。</p>