Opta and Excel Data streamer

Using Arduino Interfacing w/ Software on the Computer
1

What I want to do: I want to read 16 analog values when a button is pushed and send them to Excel so data directly can be visualised and evaluated for product quality control.

I'm trying to read data from a Opta AFX00002 into Excel via Data streamer. Anyone knows if this is possible?
I did a test by sending 2 comma seperated values to serial monitor (loop with delay 1000ms) with an arduino Uno which works. Now I use the same program with the Opta but Excel doesn't show any values nor timestamps.

Serial monitor in Arduino IDE do show the values.

Both baudrates are set to 9600 and I also tried 38400. I also already restarted my PC to be sure there was no other connection running before connecting to Excel.
I also managed to download the program via Arduino PLC IDE but no luck either to visualise in Excel.

Here what is send to serial Monitor in the loop:

Serial.print(i);
Serial.print(",");
Serial.println(voltage_T_1,3);
delay(100);
2

I'm pretty sure problem is related to Excel and how it tries to read the serial port. I tried whole day some stuff.

3

The problem is more likely to be pilot error. You might find it easier if you use PLX v2, which is well-supported on this forum.

4

Thanks, with PLX v2 I'm able to read the data from Arduino Opta. Probably still lot to do but now I can start from something.

I hoped also to be able to read the data from Mitutoyo U-Wave module with PLX v2 but this failed till now. I hoped the direct debug monitor should at least show something.
Putty serial monitor can read it so I suppose this also should be feasible by VBA.

5

I guess Mitutoyo is a data-sending device. If PLX can pass on data from something, it can pass on data from anything. I have never heard of VBA but I think all this is just a matter of serial data, and the serial monitor in the IDE should reveal all.

6

By VBA in meant visual basic for applications