Skip to content

Corporate deployment of SQL Spreads

← Installation and setup


Prerequisites

The default SQL Spreads Excel Add-In is installed per-user and can be installed without Administrative rights. 

The installer will check for missing prerequisites and install them if necessary. The prerequisites will require Administrative rights to be installed.

The following are the prerequisites that need to be installed:
  1. .NET Framework 4 Client Profile
  2. VSTO 2010 Runtime - this should be included in the Office installation for Office 2013 and later. In some cases, a custom Office installation may do not include the VSTO Runtime, so check that your clients have it installed. In Control Panel > Program and features it is installed as “Microsoft Visual Studio 2010 Tools for Office Runtime”

The Visual Studio 2010 Tools for Office Runtime installer can be downloaded from
https://www.microsoft.com/sv-se/download/details.aspx?id=48217

MSI installer

To obtain the MSI installer for creating a deployment package, please send an email to support@sqlspreads.com 

To use an MSI property to pass the license key during an unattended installation, use the property LICENSEKEY_PROPERTY
msiexec /i "SQLSpreadsSetup.msi" LICENSEKEY_PROPERTY=E07Q1-11E0D-EA001-91301-02014-03040-05060E

Silent installation
To install SQL Spreads silently, download the MSI installer and run it from the command line using msiexec with the /quiet option:
msiexec /i SQLSpreadsSetup.msi /quiet

If you are doing a silent per-machine installation, you will have to also specify if the version of Excel on the machine
 is 32-bit or 64-bit. You do that by adding the property IS64BITEXCEL which can be set to either 0 or 1. 

For 32-bit Excel use: 
msiexec /i SQLSpreadsSetup.msi IS64BITEXCEL=0 /quiet  

For 64-bit Excel use:
msiexec /i SQLSpreadsSetup.msi IS64BITEXCEL=1 /quiet    

Per-machine installer
The default SQL Spreads installer is installed per-user, but there is also a per-machine installer available. 

Please contact support@sqlspreads.com to get the per-machine installer.

Setting registry keys to load the SQL Spreads Excel Add-In
Office uses a few registry keys to detect if an Excel Add-In is installed. If the Excel Add-In does not loads, please ensure that these registry keys are set during a custom installation. 

The keys should be set under:
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\SQL Spreads

There are four key that should be in the registry:
Key 1:
Name: Description
Type: REG_SZ
Data: SQL Spreads

  Key 2:  
Name: FriendlyName
Type: REG_SZ
Data: SQL Spreads Add-In

  Key 3:  
Name: LoadBehavior
Type: REG_DWORD
Data: 0x3

  Key 4:  
Name: Manifest
Type: REG_SZ
Data: file:///C:\Users\[USER NAME]\AppData\Local\Obnex Technologies AB\SQL Spreads Desktop\SQL Spreads.vsto|vstolocal


Installing on Remote Desktop Services/Citrix/Terminal Server

To install SQL Spreads on Terminal Server, you need to use the per-machine installation package. Please contact support@sqlspreads.com to get the per-machine installer.
  1. On Terminal Server, open control panel and start the “Install Applications on Remote Desktop Server”.
  2. Select the SQL Spreads per-machine installer and follow the steps. 
This will install the AddIn for all users, please see the section below for how to load the Add-In only for specific users. 

Only load the SQL Spreads Excel Add-In for specific users on Terminal Server
To prevent the Add-In to load for every Excel user on the Terminal Server, follow these steps:
  1. Install the SQL Spreads per-machine installation as above.

  2. To prevent the AddIn to load for all users, remove the keys in the following registry paths:
    32-bit Excel: ”HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins\SQL Spreads”
    64-bit Excel: ”HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\SQL Spreads”

  3. Open Excel from a user and verify that the SQL Spreads Add-In is not loading.

  4. For every user that should have SQL Spreads add the following keys to the HKCU. (Do not add the keys under Wow6432):
    [HKEY_USERS\S-1-5-xxx-1112\Software\Microsoft\Office\Excel\Addins\SQL Spreads]
    "Description"="SQL Spreads"
    "FriendlyName"="SQL Spreads Add-In"
    "LoadBehavior"=dword:00000003
    "Manifest"="file:///C:\\Program Files (x86)\\Obnex Technologies\\SQL Spreads Desktop\\SQL Spreads.vsto|vstolocal"
You can automate this process either by using a group policy registry preference or a logon script.

Feedback and Knowledge Base

(thinking…)