Excel Add-in for Data Retrieval

The VTScada data retrieval add-in for Microsoft Excel® puts VTScada query tools directly into your worksheets. Create multiple queries that you can update on demand, then use Excel's features to analyze and present the information.

The VTScada toolbar within Excel

Preparation

The use of a secured connection (X.509 certificate) is mandatory. The VTScada Excel add-in will not connect to an unsecured server.
You can use a self-signed certificate, provided that you add a local loop-back exemption if both Excel and VTScada are running on the same workstation. Refer to Microsoft's trouble-shooting instructions. (Link opens in a new tab or window.)

The instructions for creating a self-signed certificate are well outside the scope of this documentation. There are many references available on the Internet, as well as many guides to the risks and benefits. Ensure that you take all necessary security precautions.

The connection uses the VTScada Internet Server. Follow the instructions within Configure a VTScada Thin Client Server and Configure a Realm.

Your VTScada license must include the Remote Data Access feature.

To prevent free browsing of the main history tables, consider using one or more of the SQL View Tag, each of which can be assigned a custom privilege. In addition, deny access to the Remote Tag Value / History Retrieve privilege so that accounts with Remote Data Access can view only their assigned SQL views.

The add-in will work best with the 1.4 version of the Excel API. It is compatible with the 1.1 API version, but may not perform as well.

In terms of Excel version, the add-in is compatible with Office 2016 build 16.0.4390.1000 or higher and any version of Office Online.
An uncommon configuration requirement is to allow for Domain Aliases (CORS).

Following installation, your next steps will be to Create and Manage Connections, then Create Queries.
You may also wish to adjust the Settings for the Excel Add-in.

Installation of the add-in

  1. In Excel, open the Insert ribbon.
  2. Select Get Add-ins.
  3. Select the Store option.
  4. Use the Search tool to find and select VTScada.
  5. Select the Add button.

Getting the add-in from the Office store.