擅长:python、mysql、java
<p>我也推荐熊猫,但是如果你想用XlsxWriter来做,你可以这样做:</p>
<pre><code>import xlsxwriter
# Some sample data.
dataset = [[11, 12, 13, 14],
[21, 22, 23, 24],
[31, 32, 33, 34]]
column_sum = dataset
row_sum = dataset
xbook = xlsxwriter.Workbook('abcd.xlsx')
xsheet1 = xbook.add_worksheet('img_reshape')
xsheet2 = xbook.add_worksheet('column_sum')
xsheet3 = xbook.add_worksheet('row_sum')
mappings = [(dataset, xsheet1),
(column_sum, xsheet2),
(row_sum, xsheet3)]
for dataset, worksheet in mappings:
for row_num, row_data in enumerate(dataset):
for col_num, cell_data in enumerate(row_data):
worksheet.write(row_num, col_num, cell_data)
xbook.close()
</code></pre>
<p>或者对于内部循环,您可以这样做:</p>
^{pr2}$