views:

887

answers:

3

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.

+1  A: 

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).

Jim Anderson
A: 

you might also try this (old, but I think still relevant) http://msdn.microsoft.com/en-us/library/aa140059(office.10).aspx

Having worked at Reuters for years in the real-time data world, I must say that I haven't looked at DDE in over a decade. I assume it still sees use, but it is really old and has been replaced by lots of stuff. Mostly though I have been working with desktop apps that talk to the real-time APIs.

Some other links http://www.windowsdevcenter.com/pub/a/windows/2005/02/08/xcel_mm.html

http://www.add-in-express.com/add-in-delphi/excel-rtd-servers.php

http://www.codeguru.com/vb/gen/vb_general/ideincludingvisualstudionet/article.php/c6075

Tim
+2  A: 

I can recommend reading this page. It talks about almost every aspect of DDE:

http://www.angelfire.com/biz/rhaminisys/ddeinfo.html

Wouter van Nifterick