问题描述
我正在为Excel客户端实现DDE服务器,为他们提供股票市场实时数据。
我使用了Ndde.Dll并创建了一个继承自NddeServer的类,我在其中覆盖以下方法和事件
I’m Implementing DDE Server for Excel Clients to provide them with stock market real time data.
I used Ndde.Dll and created a class that inherits from NddeServer where I override the following methods and events
OnBeforeConnect()
OnAfterConnect()
OnDisconnect()
OnStartAdvise()
OnStopAdvise()
OnExecute()
OnPoke()
OnRequest()
OnAdvise()
Advise()
- 何时应用程序启动我注册服务器,然后当有任何更新时,我调用serverObj.Advice(主题,项目)。例如serverObj.Advice(主题,item~Id)。
- 客户从他需要的数据网格视图中选择一些数据并复制它们然后打开Excel工作表并粘贴所选数据项
- 每个单元格的公式看起来像'ServerName | TopicName!'ItemName~Id'。
我 ssue是在系统中更新数据项时他们没有在Excel工作表中
- 你能帮助我,我该如何解决这个问题???
- 是否有其他方法可以使用DDE或错过的步骤?
-When application starts up I register the server and then when there is any updates I call the serverObj.Advice(Topic, Item). e.g serverObj.Advice("Topic", "item~Id").
-Client select some data from data grid view he needs and copy them then opens excel sheet and paste the selected data items
-The formula of each cell looks like ‘ServerName|TopicName!’ItemName~Id’.
Issue is when data items updated in system they didn’t in Excel sheet
-Could you help me, how can I fix this???
- Is there alternative methods for using DDE or missed steps to do??
推荐答案
这篇关于如何使DDE Server更新Excel客户端?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!