My team is working on a finance excel add-in , I was asked to publish real-time data to clients. luckily, Excel has RTD function for this need. one of the crucial problems come to me is getting data immediately when client log in with other component , i have to catch this login events , and notify RTD to refresh data.
After Google , I get two ways —-Call Back Interface and Connection Point .
1. Call Back Interface
I hope you know Chinese, Ha-ha, Link: http://www.vckbase.com/document/viewdoc/?id=1526 . Its easy to understand , declare a base interface in base component , add a method for calling back , then implements the interface for a sub class ,add response code in call-back function. Create a sub class type object , cast to interface type , set to base components object for calling back, this the call back object.
2.Connection Point.
It’s complex , but useful , Link:http://www.vckbase.com/document/viewdoc/?id=1538 .
Which way to select is the much more complex problem, After drill down , I select the second way . Why ? because , the login component is out-of-process , the first way does not work after finishing all job as the link’s guide, you have to mash the interface when set to an out-of-process component. I selected the second way ,it worked well.
Enjoy it. Ha-ha , I like Ha-ha , then when Chinese A share market end lower on this Wednesday.
