In Excel only the root certificate is necessary to get access to the server.
Copy the root certificate and rename it to client.pem.
Paste the client.pem to <Install_path>\xladdin\cert\
When creating a connection, use the correct server address that matches the CN used in the server certificate.
The port is the HTTP Port.
When connecting, the server redirects the client to https. The client will use the “client.pem” in “<Install_path>\xladdin\cert\” to establish the connection.