DDE是否仍然重要？哪些是替代品？ [英] Does DDE still matter? Which are the alternatives?

问题描述

我正在一个证券交易所信息平台上工作，我们正在考虑在我们的平台和自制的Excel文件之间提供一个链接。金融市场仍然依赖于旧的DDE服务器方法，现在还是很重要吗？

哪些是在Excel文件上进行自动在线数据更新的替代方法数据库查询？我想知道有没有人在C＃和.NET中实现OLE DB提供程序的任何例子。

我们的API将完全在线和RESTful，有任何Web服务替代将此数据链接到Excel？我记得Excel 2003有一个Web服务工具包，但我找不到与Excel 2007中的任何东西。

解决方案

与Excel进行交互， OLE Automation / COM 替代了使用DDE。

您可能需要查看 VSTO （Visual Studio Tools for Office）。

I'm working on a stock exchange information platform and we are thinking in provide a link between our platform and home-made Excel files. The financial market is still bound to the old DDE server approach, now does it still matter today?

Which are the alternatives to make automatic online data updates on Excel files, OLE DB queries? I wonder if anyone has any example of implementing an OLE DB provider in C# and .NET.

Our API will be completely online and RESTful, there is any Web Services alternative to link this data to Excel? I remember Excel 2003 having a Web Services Toolkit but I can't find anything close to that in Excel 2007.

解决方案

In terms of interacting with Excel, OLE Automation/COM replaced the use of DDE.

You may want to take a look at VSTO (Visual Studio Tools for Office).

这篇关于DDE是否仍然重要？哪些是替代品？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！