擅长:python、mysql、java
<p>没错,openpyxl不能读写VBA代码。</p>
<p>根据<a href="https://groups.google.com/forum/#!topic/openpyxl-users/2PKhuWTm1ME" rel="nofollow">this thread</a>:</p>
<blockquote>
<p>I think you should not give the xlsM extension, because the file will
contain no VBA code. openpyxl is used to build xlsX files only.</p>
</blockquote>
<p>改为尝试<a href="https://bitbucket.org/amorris/openpyxl/overview" rel="nofollow">this fork</a>:如果您将<code>keep_vba=True</code>参数传递给<code>load_workbook</code>,它就应该完成这项工作。</p>
<p>希望能有所帮助。</p>