如何在 Excel 中进行分布式计算
几年前，我实现了一个异步点对点面向消息的中间件，它在 Excel VBA 中使用起来非常友好，我发现自己再次需要进行大量计算，这些计算可以是微不足道的分布式计算，如果我有机制。
我可以重新实现 MOM 层，但我更愿意使用第三方产品（如果存在）。
我的要求是：
- 能够轻松地从Excel VBA和VB6发送消息，
- 有一个资源发现机制来查找计算服务，
- 有异步消息发送（我不想在计算时锁定Excel）已完成），
- 提供排队机制，以便我可以让多个服务器轻松完成工作，
- 设置的管理权限较低
有人可以提出任何建议吗？
非常感谢
——DM
A number of years ago I implemented an asynchronous peer-to-peer Message-Oriented-Middle-ware that was very friendly to use in Excel VBA, and I find myself again needing to do lots of calculations which could be trivially distributed, if I had the mechanism.
I could re-implement the MOM layer, but I'd prefer to use a third party product if one existed.
My requirements are these:
- to be able to send messages easily from Excel VBA and VB6,
- to have a resource discovery mechanism to find the calculation services,
- to have asynchronous message sends (I don't want to lock up Excel while the calculation is being done),
- to provide a queuing mechanism so I can have multiple servers doing the work easily,
- to have low admin for setup
Can anyone suggest anything?
Many thx
-- DM
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Microsoft Windows Server 2008 HPC 版本的下一个版本包括名为“Excel Runner”的功能，它是专门为处理您所描述的问题而设计的。
The next release of Microsoft Windows Server 2008 HPC edition includes something called "Excel Runner" which is specifically designed to deal with the kind of problem you are describing.
RESTFul Web 服务很容易通过 Excel VBA 使用。您可以使用对 MSXML2 或 WinHttp 的引用 - 听起来您想在异步模式下使用，以免阻塞 Excel UI。
从简单的事情开始：
很高兴对等待结果的细胞有视觉指示。
这些链接可能会对您有所帮助。
使用 WCF 和 .NET Framework 3.5 进行对等编程
点对点编程
MPAPI - 并行和分布式应用程序框架
RESTFul Web Services are easy to use from Excel VBA. You can use a reference to MSXML2 or WinHttp - Sounds like you want to use in Async mode so as not to block the Excel UI.
Start with something simple:
Nice to have visual indication on cells pending results.
These links may help you.
Peer-to-Peer Programming with WCF and .NET Framework 3.5
Peer-to-Peer Programming
MPAPI - Parallel and Distributed Applications Framework