擅长:python、mysql、java
<p>谢谢斯科利,我能走上正轨。以下是对我有用的,希望对你有所帮助:</p>
<pre><code>for sheet in xlwb.Worksheets:
xlApp = win32com.client.Dispatch("Excel.Application")
nwb = xlApp.WorkbookAdd()
sheet.Copy(Before=nwb.Sheet(1))
nwb.SaveAs("C:\Users\user\AppData\Local\Temp\\" +sheet.Name+ ".xlsx")
nwb.Close(True)
</code></pre>
<p>谢谢大家。尤其是斯科利让我走上正轨。也谢谢TankorSmash的回答。</p>