Excel（Office）和 C#
目前我必须维护一个Excel 应用程序，它由许多VBA 模块组成。 对我来说，它有一种像遗留系统一样的感觉，而 VBA 看起来像是最近的一种语言。考虑迁移到 C# 和基于 .NET 的 Office 应用程序是否有意义？ 一般来说，对于使用 .NET 的办公自动化来说，这种迁移分别有哪些优点和缺点？或者 VBA 仍然是开发 Office 应用程序和办公自动化的更好方法吗？顺便说一句，我是一名经验丰富的 .NET 开发人员。
At the moment I must maintain an Excel-Application, which consists of many VBA-Modules.
For me it has the touch like a legacy system and VBA looks like a language of recent days. Makes it sense to think about a migration to C# and a .NET based Office application?
What are the pros and cons for such a migration respectively for Office-automation with .NET in general? Or is VBA still the better way for developing Office-applications and Office-automation? By the way, I am an experienced .NET developer.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这只是一个意见，但我建议您坚持使用 VBA 来进行 Excel 的标准开发。使用 .NET 无疑是下一步，但它会让您的 Excel 开发变得更加困难。
使用 .NET 有很多优点，主要是在强类型方面，但在部署方面，VBA 比 .NET 具有巨大的优势。 VBA 也是一种更容易上手的语言，特别是对于使用 Excel 来说，因为 Excel 的许多成员没有强类型返回值。
总的来说，我建议您使用 VBA 进行日常开发，但同时学习 VB.NET 或 C#，以便您的编程技能可以在 Excel 领域之外得到发展。最终，您的 .NET 技能会变得足够强大，以至于您会更喜欢使用它而不是 VBA，但您必须在同一天变得非常擅长 .NET :)
无论如何，这里是 链接 祝
一切顺利！
This is just an opinion, but I would suggest that you stick with VBA for your standard development with Excel. Using .NET is definitely the next step, but it makes your Excel development much harder.
Using .NET has many advantages, mostly regarding strong-typing, but VBA has enormous advantages over .NET when it comes to deployment. VBA is also an easier language to start out with, especially for working with Excel, which has many members that do not have strong typed return values.
Overall, I would suggest that you use VBA for your day-to-day development, but learn VB.NET or C# on the side so that your programming skills can grow outside of the Excel arena. Eventually, your .NET skills can become strong enough so that you will prefer to use it over VBA, but you will have to become pretty good at .NET for the same day :)
Anyways here is the link needed for transformation
All the Best !!!
NET 开发人员，目前正在开发 VBA 应用程序。选择基于 .NET 的办公开发会对性能造成很大影响。但这并不是完整的故事。如果 .NET 代码和应用程序之间的交互很少，那么您可以选择基于 .NET 的实现。否则我会建议使用 VBA。它在语言和框架上并不是很难，并且可以在线获得帮助。
NET developer, currently working on a VBA application. There is a large performance hit on opting .NET based office development. But its not the complete story. If there are very few interaction between .NET code and the Application then you can go for .NET based implementation. Other wise i will suggest go with VBA. Its not very hard on language and framework and tones of help is available on line.