Excel和Silverlight之间的通信 [英] Communication between excel and silverlight

问题描述

我正在开发一个应用程序，我需要将数据从excel获取到我的silverlight oob应用程序，并在操纵后将其发送回excel.

I am developing an application where i need to get data from excel to my silverlight oob application and after manuplation send it back to excel.

我可以与com自动化工厂类一起使用.但是问题是我们已经开发了一些逻辑来从wcf和odbc抓取数据，因此我们想通过WCF服务跟踪更改.
要求是:如果我使用WCF服务将数据更改为将反映到Silverlight的excel中，并且将数据更改为需要反射到excel中的Silverlight，则将其转换为Silverlight.

I am able to do this using with com automation factory classes. But the problem is we have already developed some logics for grabing data from wcf and odbc so we want to track changes by WCF service.
The requirement is: if i changes data into excel that will be reflected into silverlight and if I change data into silverlight that need to be reflected into excel, using an WCF Service.

是否可以通过WCF服务将 Excel与Silverlight通信，反之亦然?

Is it possible to communicate Excel to Silverlight or vice versa with WCF service ?

推荐答案

我很难理解要实现的目标，但是我将尝试按原样回答问题.

I'm having a hard time understanding what you want to accompish, but I'll try to answer the question as is.

可以从SL和Excel .NET应用程序(COM加载项或VSTO)中调用WCF服务.也可以直接在Excel .NET应用程序中托管WCF服务(至少应该是:您可以在控制台应用程序中进行操作，所以为什么不这样做呢?).因此，基本上，您可以使用WCF在SL OOB和Excel .NET应用程序之间进行通信.但是问题是:为什么要这样做呢?我感觉只需重写逻辑即可更快，更安全，因此您根本不需要WCF ...

It's possible to call a WCF service from both SL and an Excel .NET application (COM Add-in or VSTO). It's also possible to host a WCF service right in Excel .NET app (at least, should be: you can do it in a console app, so why not?). So basically you can use WCF to communicate between SL OOB and Excel .NET app. But the question is: why do it that way? I have a feeling that it's much faster and safer to just rewrite your logic so you won't need WCF at all...

这篇关于Excel和Silverlight之间的通信的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！