Uno R4 WiFi Not working with Excel Data Streamer

[jordan14484]

Hello, I have a new Arduino Uno R4 WiFi that I am trying to use to stream data from a couple of sensors back to Excel using Excel's built in data streaming tool. I have used this tool with an older R3 Uno and it has worked flawlessly. I am able to connect to the R4 Uno in excel but when I click on start data nothing starts coming through. I've triple checked all of my baud rates to make sure they match, I've made sure to close the serial monitor in the IDE, and made sure nothing else on my machine is trying to connect to the Uno. The output shows up just fine on the IDE serial monitor I am not sure what is going wrong here. I've tried my code on a R3 Uno and have been successful in getting it to stream data to Excel. The only difference I have noted is that when the R3 is connected to Excel recognizes it as an Arduino Uno on COM5 but when the R4 is plugged in Excel sees it as a USB Serial Device on COM3, see attached photos. Is there something I am missing here? It seems like it could be a driver issue but I have uninstalled and re-installed the driver for my R4 and it has not helped.

[sebajost]

Hi,

some microcontrollers with built-in USB, like the Arduino UNO R4 or Leonardo require enabling the DATA TERMINAL READY (DTR) pin. You can try the Handshake settings, but I'm not sure there is the right setting for this.

In my app LOGGBOK it is this setting:

[JohnLincoln]

Hello jordan14484,

I just tried my Arduino Uno R4 Wifi with Excel Data Streamer.

I had no problems, it worked just as it did with Uno R3.
Like yours, Uno R4 WiFi just appears as a USB Serial Device, whilst an Uno R4 appears as Arduino Uno.

[terje567]

Hi.
I have the same problem you have jordan.
I have used the data streamer with R3 for a long time, no trouble.
Now I try the R4 WiFi and Minima. They do not send any data to Exel data streamer.
I have tried the same Arduino program and the same Exel program on four different Arduinos.
The old Uno R3, no problem, Mega 2560 R3, no problem. R4 Minima and R4 WiFi, no data to Exel.
It seems that the datastream wont start with the new R4.
Does anyone have a suggestion?

[briannn99]

hi Jordan, have you managed to solve this issue? I just received my r4 wifi board and im trying to use data streamer for it but i still cant manage to get it working

[marvin_01]

Hi, has anyone here solved the problem?
I have the same, with same code on UNO R3 it works, but with UNO R4 Wifi it doesn't show anything. I can connect the Arduino to Excel, but no data comes in after "start data".
Or for those where it works, maybe you have some tips for the settings.
I have already set every baudrate to 9600 and after two days of trying I think I have tried nearly every other setting, but feel free to suggest anything.
Thanks in advance

[diguana]

After running into this problem myself, I stumbled upon the solution from this post: Different serial communication with R4 - #12 by terje567

I tried it with my Arduino UNO R4 Minima, and it worked like a charm.

[marvin_01]

Okay Thank you,
I tried that but after including the HID library, I have got some Problems with the uploading. Or does that work without the HID library? But I will try again tomorrow when I got my Arduino on hand. Otherwise I have to try that with Serial1 and a TTL to USB converter. But big thanks for answering!

[diguana]

Here's an example that you should be able to copy and paste to get Excel Data Streamer working:

int a = 5;
float b = 3.14;

void setup() {
  // put your setup code here, to run once:
  Serial.begin(9600);  // set-up baud rate
  Serial.dtr();        // Data Terminal Ready
}

void loop() {
  // put your main code here, to run repeatedly:
  Serial.print(a); // column 1
  Serial.print(",");
  Serial.print(b); // column 2
  Serial.println();
  delay(2000);
}

Make sure you don't have the serial monitor open in any other IDEs as this may prevent the data streamer from being able to read the data coming from the Arduino.

[marvin_01]

Hi, thanks,
I get the Error: "Compilation error: 'class UART' has no member named 'dtr'"
After including <HID.h> I can compile the Code and upload it. Then data streamer reads the data successfully.
But only once, but that is an common issue as I have seen in this forum I will have to live with and reset the Arduino a few times.
So all in all it works, big Thanks for taking the time for me.
I thought I have tested it a bunch of times before but I think I have made some mistakes there, but now it works so that's great enough This saves me to buy two more Arduino R3's