Opto 22's website will be unavailable for scheduled maintenance on Thursday February 29, 2024 at 10:00PM PST for an estimated 4 hours. We apologize for any inconvenience this may cause.

SNAP PAC RESTful API to Excel Spreadsheet Technical Note

Documents - 2203
File Size: 3772 KB
Updated: 09/11/2017

This technical note describes how to read from and write to an Opto 22 SNAP PAC programmable automation controller via the PAC’s RESTful API, using Visual Basic for Applications (VBA) with Microsoft Excel. In this way you can securely share I/O point and variable data in your SNAP PAC controller with an Excel spreadsheet.

This tech note accompanies the sample spreadsheets in the SNAP PAC RESTful API to Excel Spreadsheet Example. Also, see the SNAP PAC RESTful API to Excel video.