Microsoft Excel provides a worksheet function, RTD, that allows you to call a Component Object Model (COM) Automation server for the purpose of retrieving data real-time. This article describes how to use Visual C# to create a RealTimeData Server for use with Excel’s RTD function. The RTD Server technology is used to provide the end user with a flow of changing data such as stock quotes, currency exchange rates etc.
To Create RealTimeData server for Excel, Download Add-in Express for .Net ( Download Link )
Download and extract Add-in Express and Install it on your system.
After installation of plugin ADX RTD Server option will present in extensibility. Create new project of ADX RTD Server.
In RTD server Design module add RTD Topic.
Select property of ADX RTD topic property.
Now you can see all RTD topic for input and output, here we can define parameters.
To view and change in code right click on RTD topic and select View code.
Add adxrtdTopic_refreshdata event and write your logic or service to get the data, here we are using random data function.
Set refresh time interval in adxrtd topic property to get data and update it in real time
Build the project and right click on project and register the ADX project
Its take very less time to register
Its give you a successful registration message in popup.
Open any excel file and use RTD function with Server & module name with parameters go get data.
Data will update in specified time interval
You can also select that data to real time create chart.