We are currently experiencing technical issues with our website, and some pages may not load properly. We respectfully request your patience as our developers work toward a resolution.

Using the SNAP PAC REST API with Excel

Documents - 2229
File Size: 6551 KB
Updated: 08/24/2017

This document (included in OptoTutorial 2229) provides the instructions to create a Microsoft Excel® worksheet with Visual Basic® for Applications (VBA) macros that:

  • Read and write to input and output points via the SNAP PAC REST API
  • Parse JSON text strings
  • Check for input and return errors
  • Collect data on an automated interval and display it in an Excel chart
For more tips, help, and code samples, visit the Opto 22 Developer’s portal at http://developer.opto22.com.

This tutorial is based on the hardware and software that come with a SNAP PAC Learning Center (part number SNAP-PACLC). NOTE: Due to the unavailability of essential parts, the SNAP-PACLC is obsolete as of April 2022. This document will remain available on our website for customers who already own a SNAP PAC Learning Center.

If you don’t have a Learning Center but you’re comfortable using PAC Manager™ and PAC Control™, you can modify the instructions to work with your own Opto 22 devices.

You’ll need: