Skip to main content

Excel

Excel

DUELink allows support on many systems, and Microsoft Excel is one the supported options! Yes, you can access devices right from spreadsheets! Combine that with VB macros and you have unlimited options.

This is experimental support and only shows a very basic use for advanced users that understand DUELink Scripts.

Setup​

The access to the device is done though Excel Data Streamer plug-in.

Enabling the streamer is simple as it is already built in Excel:

  1. Go to File > Options
  2. In the Excel Options dialog click Add-ins
  3. At the bottom of the dialog under Manage: drop-down select COM Add-ins and click Go
  4. Check the box for Microsoft Data Streamer for Excel

You should now see the Data Streamer tab in the Excel ribbon.

Data Streamer Link

Connect the correct COM port and you will be presented with 4 new tabs (Data In, Data Out, Settings, and Manifest).

Blinky!​

Our first program will blink the on-board status LED, on for 200ms then it shuts off for 800ms, and does this 3 times.

Go to Settings and change the Data Channels to 1

Data Channels

Go to the Data Out tab and enter the following text right under CH1 column statled(200, 800, 3)

Data Out

The LED should be blinking now.