How can I realize?

Jun 12, 2013 at 9:31 AM
By using Excel-DNA, I want to realize winsock connection system.
like below,

Data-Send: Windows application
Date-Get:Excel application

In this case on Excel side, to get the real time data, I think Excel-side needs a socket structure and a threading structure.

Can I realize this scheme?
(I'm sorry I'm not good at English.)
Coordinator
Jun 12, 2013 at 10:46 PM
Hi,

For the Excel integration, you'd use the RTD (Real-Time Data) feature of Excel to push the data. The Excel-DNA library has some nice helpers to help create RTD servers - there is a thread safe base class called ExcelRtdServer, which allows you to safely push updates from any thread. More advanced is integration of the Reactive Extensions library, so if you are able to make your client-side into a Reactive Extensions IObservable, the Excel integration with Excel-DNA will be easy (see https://exceldna.codeplex.com/wikipage?title=Reactive%20Extensions%20for%20Excel).

I can't really give any advice on how you would do the networking part. I know some users have used WCF, and others use plain http calls. You might investigate some of the add-ins built on top of Excel-DNA - e.g. FinAnSu and Cubicle Tools - they might give you some ideas. There are links on the CodePlex home page.

Good luck,
Govert
Jun 13, 2013 at 1:27 AM
Hi,Govert

Thank you for your advice.
I'll try.

Regards
Nobuaki