擅长:python、mysql、java
<p>而不是:</p>
<pre><code>ws.Range('a1:k%s' % row).select
ws.Range('a1:k%s' % row).cut
ws.Range('a7').select
ws.paste
</code></pre>
<p>我做到了:</p>
<pre><code>ws.Range("A1:K5").Copy(ws.Range("A7:K11"))
</code></pre>
<p>根据<a href="http://msdn.microsoft.com/en-us/library/bb178833%28v=office.12%29.aspx" rel="noreferrer">MSDN: Excel Object Model Reference</a></p>