擅长:python、mysql、java
<p>如果你不反对使用熊猫,这可能会有帮助</p>
<pre><code>import pandas as pd
#change xxx with the sheet name that includes the data
data = pd.read_excel(sourcefile, sheet_name="xxx")
#save it to the 'new_tab' in destfile
data.to_excel(destfile, sheet_name='new_tab')
</code></pre>
<p>希望有帮助</p>