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 an experimenter 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:
- Go to File > Options
- In the Excel Options dialog click Add-ins
- At the bottom of the dialog under Manage: drop-down select COM Add-ins and click Go
- Check the box for Microsoft Data Streamer for Excel
You should now see the Data Streamer tab in the Excel ribbon.
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 on for 200ms then it shuts off for 800ms, and does this 20 times..
Go to Settings and change the Data Channels to 1
Go to the Data Out tab and enter the following text right under CH1 column Led(200, 800, 20)
The LED should be blinking now.