Home |
Search |
Today's Posts |
#1
|
|||
|
|||
RTD server : Updatenotify does not return and Excel not calling refreshData method
Hi,
I have implemented an RTD server in c# Its working fine in 2003 but when I use excel 2007 the cell values stop updating after while. Here is my logic for refreshdata and update notify I have used alreadyNotified flag to make sure that there are no excessive updatenotify calls which might make excel unresponsive public System.Array RefreshData(ref int TopicCount){ Console.WriteLine("entering RefreshData " + Thread.CurrentContext.ContextID); alreadyNotified = false; // Logic to update the excel sheet cells Console.WriteLine("already notified set to FALSE"); Console.WriteLine("exiting refresh data " + Thread.CurrentContext.ContextID); return obs; } // This is called when we receive new values private void notifyExcel(){ Console.WriteLine(" ------- ENTERING NOTIFY EXCEL -----------"); Console.WriteLine("already notified flag is : " + alreadyNotified); if (m_xlRTDUpdate != null && !alreadyNotified) { alreadyNotified = true; Console.WriteLine("already notified set to TRUE"); Console.WriteLine("before update notify"); m_xlRTDUpdate.UpdateNotify(); Console.WriteLine("after update notify"); } Console.WriteLine(" ******** EXITING NOTIFY EXCEL *************"); } when I have debugged it for a while, the values stopped streaming and my logs showed the following: 09/07/2012 19:16:47 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:47 already notified flag is : False 09/07/2012 19:16:47 already notified set to TRUE 09/07/2012 19:16:47 before update notify 09/07/2012 19:16:47 after update notify 09/07/2012 19:16:47 ******** EXITING NOTIFY EXCEL ************* 09/07/2012 19:16:47 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:47 already notified flag is : True 09/07/2012 19:16:47 ******** EXITING NOTIFY EXCEL ************* 09/07/2012 19:16:47 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:47 already notified flag is : True 09/07/2012 19:16:47 already notified set to TRUE 09/07/2012 19:16:47 before update notify 09/07/2012 19:16:47 exiting refresh data 0 09/07/2012 19:16:48 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:48 already notified flag is : True 09/07/2012 19:16:48 ******** EXITING NOTIFY EXCEL ************* 09/07/2012 19:16:48 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:48 already notified flag is : True 09/07/2012 19:16:48 ******** EXITING NOTIFY EXCEL ************* 09/07/2012 19:16:48 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:48 already notified flag is : True 09/07/2012 19:16:48 ******** EXITING NOTIFY EXCEL ************* 09/07/2012 19:16:48 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:48 already notified flag is : True 09/07/2012 19:16:48 ******** EXITING NOTIFY EXCEL ************* 09/07/2012 19:16:48 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:48 already notified flag is : True 09/07/2012 19:16:48 ******** EXITING NOTIFY EXCEL ************* 09/07/2012 19:16:48 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:48 already notified flag is : True 09/07/2012 19:16:48 ******** EXITING NOTIFY EXCEL ************* 09/07/2012 19:16:49 ------- ENTERING NOTIFY EXCEL ----------- 09/07/2012 19:16:49 already notified flag is : True The logs show that last update notity method does not return at all I am not sure how do it solve this problem and this is happening every time Can some one please point me in right direction in solving this Thanks, kams.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RTD server : Updatenotify does not return and Excel not calling refreshData method
kamesh wrote:
I have implemented an RTD server in c# Its working fine in 2003 but when I use excel 2007 the cell values stop updating after while. Here is my logic for refreshdata and update notify I have used alreadyNotified flag to make sure that there are no excessive updatenotify calls which might make excel unresponsive [snip] The logs show that last update notity method does not return at all I am not sure how do it solve this problem and this is happening every time Can some one please point me in right direction in solving this I'd suggest asking in the group comp.os.ms-windows.programmer.win32. -- If voting changed anything, they'd make it illegal. |
#3
|
|||
|
|||
Thanks
I have found the problem, excel 2007 throws an exception when ever it is busy and not ready to handle the request. Solved the issue by catching the exception and added a timer to notify again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel creates massive files on calling vba workbook.save method | Excel Programming | |||
Calling Excel/Opentext method via ActiveX in a service application | Excel Programming | |||
GetObject method from excel to other application from remote server | Excel Programming | |||
RefreshData Method in RTD Server | Excel Programming | |||
calling a stored procedure on MS SQL Server within MS Excel 2000 | Excel Programming |