Excel RTD Server Sample

The RTDServerSample class should be registered in the system using Server Manager application. In case with RTD server such registration is required so that Excel will connect to the server by its ProgID and COM will be able to map ProgID of your RTD server to its CLSID.

Therefore, the registration of the RTD server will include following steps:

  1. Create a JAR with the RTD server class and necessary classes and wrappers for COM classes and interfaces. The class path in the manifest file of this JAR should include all necessary libraries, such as jniwrap-3.x.jar, winpack-3.x.jar, comfyj-2.x.jar, slf4j-api-1.5.8.jar, slf4j-simple-1.5.8.jar, and a JAR file that contains native libraries and license.

  2. Register this JAR with the Server Manager application. The registration procedure is described in Guide: http://www.teamdev.com/downloads/comfyj/docs/ComfyJ-PGuide.html#AEN654. You don't need to include the necessary libraries to the class path in the Server Manager, because they are included in the class path of the manifest.

After the registration, you can try to connect to the RTD server from MS Excel. The example of RTD function call is given in the sample.

The complete IntelliJ Idea project (RTDServer.zip) that should demonstrate how to get this RTD server running is attached to the article. In this sample project the RTDSererRegistration.java sample demonstrates how to perform static and dynamic registrations of the server in a system.