Microsoft Excel with Data Streamer add-in (Microsoft 365)
Problem Description:
I'm trying to stream sensor data (digital status from pin 3 and analog value from A0) from my Arduino UNO R4 Miniboard to Excel using the Data Streamer add-in. The Arduino sends data correctly (visible in the Serial Monitor), but no data appears in Excel, except for "TBL_CURTIME" in the time column. I need help to resolve this issue.
What I've Tried:
Confirmed port (COM6) and baud rate (9600) match in Arduino IDE and Excel.
Closed the Serial Monitor before starting the stream in Excel.
Adjusted the code: Changed headers to "TIME,CH1,CH2", removed "DATA," prefix, increased delay to 2000 ms.
Pressed the reset button and reconnected the USB cable.
Checked the "Serial Data Console" in Data Streamer – no raw data received.
Tested with PuTTY (COM6, 9600 baud) – data is received correctly.
Current Code:
cpp
void setup() {
Serial.begin(9600);
while (!Serial) { }
pinMode(3, INPUT_PULLUP);
Serial.println("TIME,CH1,CH2");
delay(2000);
}
void loop() {
unsigned long currentTime = millis();
int digitalState = digitalRead(3);
int analogValue = analogRead(A0);
Serial.print(currentTime);
Serial.print(",");
Serial.print(digitalState);
Serial.print(",");
Serial.println(analogValue);
delay(2000);
}
Questions:
Is there a known compatibility issue with the UNO R4 and Excel Data Streamer?
Do I need to adjust the code or Excel settings further?
Are there alternative methods to get data from the UNO R4 into Excel?
Additional Information:
I’ve reinstalled the Data Streamer add-in in Excel, but the issue persists.
The Arduino works fine with other serial tools (e.g., PuTTY), so the hardware seems okay.
I’m using Windows Windows 11 with the latest updates.
Help Request:
I’d really appreciate any advice or suggestions from the community! If you need more details (e.g., screenshots or logs), please let me know. Thank you in advance for your support!
I wanted your code, because I wanted to see how the data was formulated. Looks okay.
So if you use Serial Monitor, you see the data correctly, but Excel isn't displaying it as you expect? Sounds like a misconfiguration at the Excel end, but I don't use that tool so I can't help. Certainly, I don't see a problem with your code.
At least good news for the code
Thank you very much. Yess, there are no values in the Excel. I tried a lot with the settings in Excel, also with AI. It doesn't matter what i try, it doesn't work.
Everyone start as a beginner. Go for a more simple version. I have no such but there are projects done communicating with Excel found by the “Search Forum” tab, up to the right in this window.
Step down and go for learning coding, communication etc. By now You know it’s not easy what You aim for.
void setup() {
Serial.begin(9600); // Startet die Verbindung
}
void loop() {
Serial.println("1,"); // Sendet '1,' und eine neue Zeile
delay(1000); // Wartet eine Sekunde
}
