Excel Add-in Setup

The Excel Add-in Setup simplifies the installation process by installing only the Excel and Office Add-ins1.

Standard Installation

There are three options for installing Excel Add-in:

  1. If you have a Jedox Cloud Trial, click the green button (indicated below) in your Cloud demo to get started. Depending on your Cloud Trial's instance, the file name trialxx.exe will be different.

  1. Download the Excel Add-in Setup from here or from the Cloud Console. Once the installation is complete, you need to connect to the Jedox OLAP server via the Jedox Wizard button.

  1. If no internet connection is available during the installation, you can install the Offline Binaries, which are available from the Software Download section of the Jedox Customer Portal. To install the binaries after downloading them, the Excel Setup must be executed from the command line with the following parameters: JedoxExcelSetup_22.3.exe /sourceexceladdin JedoxExcelAddin_22_3.zip /sourceofficeaddin JedoxOfficeAddin_22_3.zip. Note that the binaries must be in the same version as the Excel Setup, available from Jedox Version 2022.3.

Note that you must have administrative rights to the client system to perform the installation. The default installation path is C:/Program Files(86)/Jedox/Jedox Clients.

Silent Installation

For unattended/automatic installation, you can use a set of terminal commands and parameters.

  • trialxx.exe /silent
  • JedoxExcelSetup.exe /silent

Starts a silent installation where only the installation progress is shown. When the installation is finished, the Setup closes.
  • trialxx.exe /verysilent
  • JedoxExcelSetup.exe /verysilent

Starts a silent installation where no window is displayed. When the installation is finished, the Setup closes.
  • trialxx.exe /installationpath {PATH}
  • JedoxExcelSetup.exe /installationpath {PATH}

Allows you to change the installation directory. E.g:

JedoxExcelSetup.exe /silent /installationpath “C:/Program Files/Jedox”
  • /cert {PATH}

For Cloud Trial: rolls out the given client certificate to encrypt the connection to Jedox Web . E.g :

trialxx.exe /silent / cert client.pem

For Excel Add-in setup: changes the client certificate

Note: in Excel Add-in setup these options also work without using /silent or /verysilent installation.

For uninstalling Excel Add-in * you can also use the command-line parameters /silent, /verysilent and /wipe:

  • UninstallExcelAddin.exe /silent

Uninstalls Excel Add-in and only one window with the progress bar is shown.
  • UninstallExcelAddin.exe /verysilent

Uninstalls Excel Add-in without displaying anything.

  • UninstallExcelAddin.exe /wipe

Uninstalls Excel Add-in.

  • In addition, the following directories will be removed:
    Jedox Clients/.install
    Jedox Clients/excel-addin/cert
    %APPDATA%/Jedox/xlAddin

  • In addition, the following registry trees will be deleted:
    HKEY_USERS/.DEFAULT/Software/Jedox
    HKEY_CURRENT_USER/SOFTWARE/Jedox

Note: The parameter /wipe will delete all user data and certificates saved in Excel Add-in. There is no way to restore these deleted files. Furthermore no fallback to the Excel Add-in installation of an AIO Setup is possible.

 

Changing the default connections

By default, the Setup creates a connection file for the Excel Add-in. The file does not contain any data. You can change the connection file by using the following command:

Copy 
JedoxExcelSetup.exe /connectionspath {PATH/TO/CONNECTIONS.JSON}

The /connectionspath parameter can be used together with /silent or /verysilent.

The content of the connections.json file should look as follows:

Copy 
[{
 "Name":"localhost",
 "Address":"http://127.0.0.1",
 "Username":"admin",
 "Password":"s+y9vcd9SYJYF6mnKw1KXA==",
 "WebPort":80,
 "OlapPort":7777,
 "IsEnabled":true,
 "AuthenticationMode":0
}]
Parameter Description
Name The display name of the connection
Address The Domain or IP address of the server
Username Your Jedox Web username
Password Your Jedox Web password (encrypted using AES 256bit cbc)
WebPort The port of the Jedox Web server
OlapPort The port of the OLAP server
IsEnabled If true, the connection is made automatically upon login. If false, the connection must be manually enabled in the Connection Wizard
AuthenticationMode 0 = Username and password
1 = Windows authentication
2 = SAML authentication

* Notes:

  • When an Excel Add-in setup is installed over an existing AIO setup installation, the older version is not uninstalled. The older version's Add-in will be unregistered, and the Excel Add-in setup is registered. The Desktop, and Start Menu shortcuts are also updated with the new version.
  • When the Excel Add-in setup is uninstalled, the previous version is automatically re-registered, and the Desktop and Start Menu shortcuts will return to their previous state.
  • Excel Add-in setup requires .Net Framework 4.6.1 or higher.

Updated February 13, 2023