Your concerns are dead on. I have not run any time tests using Automation in .Net, but using VB 6.0, I have found automation to run at least 50x slower than VBA running in behind Excel. Using .Net working through the COM Interop, I would think, would be just as bad or possibly worse. (Can’t see how it could be better!)
I would have a read here to get a sense of the issue: Performance of Excel macros vs. VB 6.0
引文来源 Performance problems with .NET/Excel COM Interop – Xtreme Visual Basic Talk
==========================================================================
遇到“死结”了？？