Posts Tagged ‘RTD servers’
Building a Real Time Data for Excel: How RTD servers work, part 3
Maurice Calvert | January 14th, 2011
There are plenty of articles on Excel RTD programming, but I've yet to see one that correctly addresses the issues of multi-tasking. All the examples rely on a toy timer-driven application, which is not how real-world applications work
... Read the rest of this entry →
Building a Real Time Data server for Excel: Avoiding VSTO, part 2
Maurice Calvert | January 13th, 2011
When I first started programming addins for MS Office, I took the obvious road of installing Visual Studio Tools for Office (VSTO). It all seemed rather easy and I had a toy excel addin completed in the first evening. My enthusiasm was quickly doused when I tried to deploy the addin. ... Read the rest of this entry →
Building a Real-Time Data server for Excel, part 1
Maurice Calvert | January 12th, 2011
In my series of posts I will describes the techniques necessary to build a Real Time Data (RTD) server for Microsoft Excel. It is based on what I learned whilst coding GeodesiX, an Excel addin that uses the GoogleMaps APIs to provide Excel formulas to fulfil these functions
... Read the rest of this entry →
RTD Servers and Add-in Express 2010
Pieter van der Westhuizen | July 5th, 2010
Real-time data (RTD) is data that updates on its own schedule. The most common example is stock quotes, warehouse activities and web server loads. In this post, Northwind Traders has requested a sales dashboard in Excel that updates sales figures and targets dynamically by reading order information from their sales database... Read the rest of this entry →
HowTo: Create a COM add-in, XLL UDF and RTD server in one assembly
Andrei Smolin | March 24th, 2010
You know, a pessimist differs from an optimist by his attitude to a glass: the former thinks the glass is half empty, while the latter considers it's half full. When I was contemplating on the circumstances that made me write this post, I worked out another definition... Read the rest of this entry →