Excel RTD server sourcing data from Kafka
-
Clone the repository and go to its folder.
-
Compile the code using Visual Studio, MSBuild or via this handy script file:
build.cmd
-
Register the COM server by running the following script in admin command prompt:
register.cmd
Once the RTD server has been installed, you can use it from Excel via the RTD macro. This is the syntax:
=RTD("kafka",, "HOST","TOPIC")
=RTD("kafka",, "HOST","TOPIC", "FIELD")
// For JSON data