Skip to main content

Install the Jet Excel add-in via the command-line

Expert

Overview

The Jet installer has two installers, one installer specifically for Excel Add-In and one installer for Jet Hub, Jet Service Tier, and Jet Admin Console.

Following are the steps (both required and optional) to install the Jet Excel add-in using the MSI installer.

MSI Installation Considerations

  1. Download

    Download Jet Reports Excel Add-in Setup and extract the contents.

  2. System Platform

    Choose either a 32-bit or 64-bit installer based on your Excel edition. The choice is determined by Excel's bit-level, not Windows version.

    For our customers using Excel 2010 or higher with Microsoft Dynamics NAV 2009 R2 or earlier, Jet Reports recommends the 32-bit editions of MS Office.

     If you have 64-bit Excel, use the 64-bit installer (Jet.Setup.ExcelAddin_x64.msi).

  3. Silent Installation

    Silent installation is a feature that installs the Jet Excel add-in with no user interaction at all. This feature is primarily useful when creating automated installation scripts.

    In order to perform a silent installation of the Jet Excel add-in, you must use the Windows Installer database file Jet.Setup.ExcelAddin_x86.msi with the /qn command-line option: 

    									
          C:\>
										Jet.Setup.ExcelAddin_x86.msi /qn

  4. Language

    The language of the installer is automatically set based on the Operating System languages, determining the language of the Start Menu shortcuts. However, the Jet Excel add-in will support all currently available languages.

Command-Line Properties

Properties can be set on the command-line to be passed to the MSI. These are specified using the following syntax: 

						
      C:\>
							Jet.Setup.ExcelAddin_x86.msi PROPERTYNAME=PropertyValue

The name of the property is case-sensitive and must be in all CAPS.  Below is a list of the supported properties and their functions:

  1. ACTIVATIONCODE

    									
          C:\>
										Jet.Setup.ExcelAddin_x86.msi ACTIVATIONCODE=ABCDEF01-2345-6789-ABCD-EF0123456789

    The ACTIVATIONCODE property specifies the activation code that will be used to activate the Jet license the first time the Jet add-In is enabled in Excel.

    NOTE: The activation code is not validated at the time of installation.  If the activation code is invalid for any reason, each individual user will still be prompted to activate.

  2. SERVICEHOST and SERVICEPORT

    The SERVICEHOST property specifies the host name of the Jet Service Tier.

    The SERVICEPORT property specifies the port on which the Jet Service Tier is listening. 

    									
          C:\>
										Jet.Setup.ExcelAddin_x86.msi SERVICEHOST=MyServer SERVICEPORT=7090

    When specified, the Jet add-in will attempt to connect to this server/port in order to receive shared data source and license activation information from the Jet Service Tier.

  3. JET_HUB_URL

    The JET_HUB_URL property specifies the URL for the Jet Hub. Note: The Jet Hub URL should end with "/" 

    									
          C:\>
										Jet.Setup.ExcelAddin_x86.msi JET_HUB_URL=https://myserver.mydomain.com/

  4. EXCELPLATFORM

    The EXCELPLATFORM property specifies the platform of Microsoft Excel.

    The Jet add-in MSI will attempt to automatically detect the platform of Excel, and perform a validation check that it matches the platform of the current installation.  In some cases the platform of Excel cannot be detected, in that case specifying this property will override the validation check and allow the installation to continue.

    Note: The use of this property is not recommended unless the Excel platform cannot be detected automatically.

  5. AUTHENTICATION_TYPE

    The AUTHENTICATION_TYPE property specifies way the Jet Excel Add-In can connect to the Jet Service Tier and Jet Hub. 

    									
          C:\>
										Jet.Setup.ExcelAddin_x86.msi AUTHENTICATION_TYPE=Microsoft 365

    Supported properties: Windows, Microsoft 365, Jet

    • Windows : Used for Active Directory or Active Directory+Single Sign-On authentication

    • Microsoft 365 : Used for Microsoft Entra ID authentication

    • Jet : Used for Basic authentication

    Note: These options are case sensitive.

    Sample command-line:

    C:\>
								Jet.Setup.ExcelAddIn_x86.msi AUTHENTICATION_TYPE=Microsoft 365 JET_HUB_URL=https://jetserver.mydomain.com/ EXCELPLATFORM=x86 SERVICEHOST=jetserver.mydomain.com SERVICEPORT=7090 ACTIVATIONCODE=ABCDEF01-2345-6789-ABCD-EF0123456789

    Note: Jet Reports technical support staff is happy to help you with the installation Jet Reports using the previously mentioned methods. Our analysts are not familiar with all forms of MSI installers or your organization's specific internal processes. The Jet MSI installers and the information in this article are provided to assist our customers who are already familiar with using MSI installers in their organization.

  6. PLATFORM

    The PLATFORM property determines if the Jet Excel Add-In should be installed using platform settings, enabling customers to log in to their Platform account. This property ensures that the MSI installer installs the correct version for Platform account users, rather than the trial version of Jet.

    When the PLATFORM property is set to “TRUE,” the installer uses platform settings and overrides the activation code if present. If set to “FALSE,” the installer performs a standard installation without enabling platform login.

    

			C:\> Jet.Setup.ExcelAddIn_x64.msi PLATFORM=TRUE EXCELPLATFORM=x64

Was this article helpful?

We're sorry to hear that.