Forum Discussion
Excel Data Streamer
MicrosoftESBlan Couple of questions:
What microprocessor are you using?
Is the format of the data following the data format listed here https://docs.microsoft.com/en-us/microsoft-365/education/data-streamer/connecting-serial-devices
- May I suggest that the Data Streamer also have the option of changing the terminator character from a comma, to a <CR>. This will allow it more versatility to talk to other systems, where the terminator cannot be changed from a <CR><LF>.
Leif, thank you for your interest.
I am using the Parallax Propeller 1 microprocessor.
The serial stream format is exactly as per the Arduino example; data separated by commas and carriage return (ASCII 13) at the end of line.
I know the serial stream is valid because I was able to observe it on the PC using two terminal programs; Parallax Serial Terminal and Bray Terminal.
Excel Data Streamer displays the serial stream port as "USB Port 5", but when I click on it and start the data steam there is no action.
I have even tried with csv text data and it does not recognize that.
- Leif Brenne
ESBlan Thanks for getting back to me. We have not tested Data Streamer with Parallax Propeller ( we have been testing this with Arduino, Microbit, Circuit Playground, ESP32.
We had a similar issue to what you are experiencing below with ESP32. This was caused by not using the default handshake command for RTS. The fix for ESP32 is coming out in the next release of Office ( 1911) and it might help out on your issue as well.
- data streamer - capture code
Hi Leif Brenne ,
I want to capture the data received from the data streamer to different workbook and fill it by incrementing row index so . as to store the data permanently in different sheet/workbook . I tried ways by linking the cells B5 from streamer to the other workbook but the data was not stored permanently there .so can any one help me in this regard .
can you help with writing macro for the same
Thanks in advance
