Data Streamer for Excel not working

Hi guys. I am trying to read the values coming from the serial monitor in Excel using the Data Streamer Add in. However, nothing happens when I click Start Data. I am using the code shown below in the Arduino IDE. The Arduino is connected to a potentiometer and the relevant values are displayed in the Serial Monitor.

void setup() {
  // initialize serial communication at 9600 bits per second:
  Serial.begin(9600);
}

// the loop routine runs over and over again forever:
void loop() {
  // read the input on analog pin 0:
  float sensorValue = analogRead(A0);
  // print out the value you read:
  Serial.println(sensorValue);
  delay(1000);        // delay in between reads for stability
}

Whenever I run this code and click Start Data, nothing happens. I select the same COM PORT that is shown in the Arduino IDE.

Hello @harveyspec33 ,
If your data is correctly displayed in Serial Monitor, then your problem isn´t related to your code.
I have some clues, both of them as generic as the problem:

Data Streamer also needs to be configured to 9600 baud rate. Did you do it?

Also, Streamer will not work if the the serial monitor is turned on. Shut off the Serial Monitor and try again.

I had set the baud rate as 9600 in both Data Streamer, the code and in the serial monitor.
So I saw the serial monitor statement somewhere before so I would run the code and then hit Start Data without opening the serial monitor. But it wasn't working as well.

Would I need to use

#include <databot.h>

in the code?

Well, I didn´t and it worked even though. Data Streamer should be showing a timestamp in the first column and your "sensorValue" in the second...

One last guess: are you using Excel for Mac? (Excel version for Macs doesn´t support data streamer).

Hello harveyspec33,

I tried your sketch with the Data Streamer plug-in for Excel, and everything worked as expected.

All I had to do was select the correct serial port, and data started streaming.
The default settings were used, and I just added the graph.

1 Like

Can I see your settings in your Settings sheet and your advanced settings?