擅长:python、mysql、java
<p>将整个工作表从工作簿复制粘贴到另一个工作簿。</p>
<pre><code>import pandas as pd
#change NameOfTheSheet with the sheet name that includes the data
data = pd.read_excel(path1, sheet_name="NameOfTheSheet")
#save it to the 'NewSheet' in destfile
data.to_excel(path2, sheet_name='NewSheet')
</code></pre>