Excel Data Streamer output to LCD screen attached to Arduino

Information about how to output excel data to an LCD live using Microsoft Excel Data Streamer.
Illustrates the format of the transferred data (comma separated).
Learn about a quirk in Microsoft Excel Data Streamer output function.

Website link for LCD example with arduino:

Website link for another video on how to enable Excel Data Streamer for sending.

Arduino code:

00:00 Introduction
00:20 How to link and LCD to an Arduino
00:35 Code modifications to receive and display serial data transmitted to the Arduino over USB
01:00 Testing with Arduino serial monitor
01:15 Testing with Microsoft Excel
02:01 Strange behaviour of Excel Data Streamer

[esqmshx]

Thanks for the great tutorial!

Is it possible to only send data written into the cells when e.g. a button is pressed or does it always send data whenever the value of one cell is changed?

[abelet]

hi, can we do that on proteus software

[emmamutua]

What data do i need to collect in traffic light project with Arduino and LEDs

[aryawezard]

How to program it the other way? What’s on the screen will show in the excel?!

[qualitycraft]

Hi is it possible to use a proximity sensor on and arduino and change a specific cell on excell or google sheets to a 1 or 0 based on when the sensor is activiated?

[salesinducomp]

is it also possible to convert the values ​​in exel to variables in arduino? I'm making a cutting list for a machine

[faitholuwaremi]

It doesn't work with the serial monitor, it prints the default Hello world but doesn't seem to be recieving in put. I am using an arduino MegaADK and a Grove LCD with RBG Backlight I don't know if this could be what's causing the issue?

[wesm]

My Data In sheet contains commands to fetch from Sheet1 (ie. =Sheet1!A1). My Data Out has a command like ='Data In'!B5 that returns the command =Sheet1!A1. So I want my lcd to display the contents of Sheet1's A1 cell. Instead, it just outputs the Data In command "=Sheet1!A1". How do I work around this so that my lcd displays Sheet1's A1 cell and not the command =Sheet1!A1?