Opto 22

43044 Business Park Drive, Temecula, CA 92590 USA
Local & outside the USA:(951) 695-3000
Toll-Free within the USA:(800) 321-6786
Fax: (951) 695-3095
Email: sales@opto22.com

OptoTutorial: Using the SNAP PAC REST API with Excel

Filename: 2229_OptoTutorial_SNAP_PAC_Excel.zip
File Size: 5141 KB
Version: 1.0
Last Update: 8/24/2017


A great advantage to getting data from a PAC controller into a Microsoft® Excel® worksheet is that you can use Excel’s features to analyze the data.

This tutorial walks you from the beginning—setting up the Web server in a SNAP PAC controller—all the way through creating an Excel worksheet with Visual Basic® for Applications (VBA) macros that:
• Read and write to input and output points
• 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).
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:
• Microsoft Excel 2007 (or higher) and a basic understanding of how to create, open, and close worksheets, select cells, and resize columns
• A SNAP PAC Learning Center (or your own SNAP PAC R- or S-series controller and I/O modules)
PAC Project™ Basic (included with the Learning Center and also available to download for free from the Opto 22 website) and a good understanding of PAC Manager and PAC Control
• The files in this tutorial’s download file


All Opto22

Request Information
  • FREE Product Brochure
  • Product Demonstration
  • PreSales Engineering Assistance

Opto 22 Product Support

Opto 22 Product Support is FREE Monday through Friday 7 a.m. to 5 p.m. Pacific Time

Product Support Numbers:

Local: (951) 695-3080
Toll-Free: (800) 835-6786
Fax: (951) 695-3017