擅长:python、mysql、java
<p>你可以用<a href="https://openpyxl.readthedocs.io/en/default/" rel="nofollow noreferrer" title="openpyxl">openpyxl</a>。下面是代码的草图:</p>
<pre><code>from openpyxl import load_workbook
compiled_wb = load_workbook(filename = 'yourfile1.xlsx')
compiled_ws = compiled['Output']
for i in range(1, 30):
wb = load_workbook(filename = 'yourfile{}.xlsx'.format(i))
ws = wb['Output']
compiled_ws.append(ws.rows()[1:]) # ignore row 0
compiled_wb.save('compiled.xlsx')
</code></pre>