有没有人有控制从.net应用程序中多个Excel实例的一个很好的例子？ [英] Does anyone have a good example of controlling multiple Excel instances from a .Net app?
问题描述
我们有一个Excel 2002 / XP的应用程序与SQL 2000/5交互处理相当复杂的精算。该应用程序执行其功能良好，但它很难管理。
We have an Excel 2002/XP based application that interacts with SQL 2000/5 to process fairly complex actuarial calculations. The application performs its function well, but it's difficult to manage.
我们正在努力建立一个控制器的应用程序或服务，它可以管理和监控的Excel这些不同的情况下（启动/停止/程序命令等），但它是一个有点互操作的噩梦不幸。
We're trying to create a "controller" application or service that can manage and monitor these various instances of Excel (start/stop/process commands etc) but it's a bit of an InterOp nightmare unfortunately.
有没有人有一个很好的（即工作）为例做这样的事情在VB.Net或C＃的？
Does anyone have a good (i.e. working) example of doing something like this in VB.Net or C#?
推荐答案
不要做了！
我们尝试了几个星期得到类似的东西来工作，它只是不表现为标榜。甚至不要开始 - ！马上放弃
We tried for weeks to get something like that to work and it simply does not behave as advertised. Don't even start - give up immediately!
这是你真的有唯一的选择是一个沉重的服务器端MOSS化实施 - Excel文件（网页）服务（他们称之为类似的东西）。基于Windows的COM互操作的Excel是pretty的太多死亡，将被青苔被替换。
The only options that you really have is a heavy server-side MOSS based implementation - Excel (Web) services (they call it something like that). Windows based COM Excel interop is pretty much dead and will be replaced by MOSS.
另一种选择是将S preadsheetGear。它实际上是一个很棒的产品
The other option is to use SpreadsheetGear. It is actually a fantastic product
- 这是lightlingly快
- 发动机是独立于用户界面，所以你可以用它做的东西的Excel服务器端（有没有办公室安装）
- 在相当便宜
- 具有类似于现有的Excel COM API，以便在整个移动code的API是比较容易
这一切都取决于你需要在您的S preadsheet的公式。看一看公式列表对于s preadsheet齿轮，如果有一场比赛去了。
It all depends on the formulas that you need in your spreadsheet. Have a look at the formula list for Spreadsheet Gear and if there is a match go for it.
这篇关于有没有人有控制从.net应用程序中多个Excel实例的一个很好的例子？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
