VSTO vs excel的旧式COM加载项 [英] VSTO vs old fashioned COM add-in for excel

问题描述

你好！

这是对这篇文章的跟进：

在excel中使用C＃库的最佳方式 [ ^ ]



这个回复很受欢迎，现在我可能有一个自然的跟进问题......人们对通过VSTO创建Excel工作簿的看法是什么？即一个excel工作簿视觉工作室解决方案与C＃烘烤？在某种方式看起来相当光滑，但我听说它很慢，在某种程度上它不太容易访问，因为它需要一个奇特的VS版本。感谢任何意见。

干杯

Hello!
This is in a way a follow up to this post:
Best way to use a C# library in excel[^]

This response was appreciated and now I have perhaps a natural follow up question... what are peoples opinions about creating an Excel workbook via VSTO? i.e. an excel workbook visual studio solution with C# baked in? In a way that seems quite slick but I hear that it is slow and in a way it's less accessable because it requires a fancy version of VS. Any opinions are appreciated.
Cheers

推荐答案

在工作中我们有一个完整的字母打印系统，通过VSTO使用Word来使用户能够设计从我们的数据库中填写的个人信息（如生日祝福和邀请）。我们还有一个excel迷你系统数据库，使用户能够将动态数据导出到Excel工作簿 - 也基于VSTO ...

这些解决方案可以处理数十万最终用户 - 大多数他们通过互联网 - 没有任何问题，所以你可以放弃'VSTO很慢'部分......

至于'花式VS'？你的意思是你不得不做任何事情，因为VS内置了Office项目模板，所以你的工作要比使用COM接口的任何以前的开发环境容易吗？

所以去吧..你会喜欢......

At work we have a full letter-printing system that uses Word via VSTO to enable users design letters that filled from our database with personal info (like birthday greetings and invitations). We also have a database to excel mini-system, that enables users to export dynamic data to Excel workbooks - also based on VSTO...
These solutions are handle hundred of thousands of end users - most of them via internet - without any problem, so you can drop the 'VSTO is slow' part...
As for 'fancy VS'? Do you mean that you have to do nothing because VS comes built in with Office project templates, so your work is much easier than with any previous development environment that uses COM interfaces?
So go for it...You will enjoy...

这篇关于VSTO vs excel的旧式COM加载项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！