开发者

Automation of excel 2010 5 times slower than before

开发者 https://www.devze.com 2023-02-06 05:41 出处:网络
We have several programs generating excel documents via com automation, some written in VB6, some in python. Regardless of the programming 开发者_C百科language those programs run 5 times slower than w

We have several programs generating excel documents via com automation, some written in VB6, some in python. Regardless of the programming 开发者_C百科language those programs run 5 times slower than with older excel versions. Profiling the python version shows that the additional run time is spent mostly in low level com functionality (built-in methods Bind and Invoke), so every single com call is slowed down.

Any tips, how we can speed this up, maybe a (security?) setting in excel 2010?

Thanks, Thomas


I cannot answer for Python, but for VBA/VB6 a significant number of changes were made in XL 2010 to improve performance rather than make it slower, see:
http://blogs.office.com/b/microsoft-excel/archive/2009/09/03/performance-improvements-in-excel-2010.aspx
Could you give a VB example of something that is 5 times slower in 2010?

0

精彩评论

暂无评论...
验证码 换一张
取 消