1) I included Data Streamer as an Excel add-in as per Microsoft Help2) I am quite an experienced user. I set up a USB csv serial data stream from my microprocessor. I know that it is a valid csv serial data stream on USB port 5 because I was able to view it on two different serial terminal programs3) I set up all the correct parameters for the serial data stream. When I entered "Data Streamer -> Connect a device" I was able to connect to USB Port 54) However when I clicked "Start Data", no data stream was captured into excel.5) So Excel Data Streamer is not receiving a valid csv data stream!Any ideas on how to progress this issue. It is very frustrating because I know the valid stream is there - I can see it on Two serial terminal programs!

SergeiBaklan : Thank Sergei Baklan so much for taking the time to guide me.

ESBlan I've reached out the Data Streamer team to see if they can take a look at your issue.

ESBlan 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

Leif Brenne 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.

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.

Excel Data Streamer | Microsoft Community Hub

Smitty Smith
Microsoft
Nov 08, 2019
ESBlan I've reached out the Data Streamer team to see if they can take a look at your issue.
- Rieungsit
  Copper Contributor
  Feb 14, 2023
  Smitty Smith:
  Now, I could Excel data streamer. I need advice that using the Excel data streamer for a job I'm interested in. What I need is a case of receiving data of 32 modbus RTU devices where each device sends 9 data to the Excel data stream via MCU Arduino. I want to extract the data of 9 data of each device with each Excel sheet. , Device number 1 to Sheet1, Device number2 to Sheet2, Device number3 to Sheet3 ... Device number 32 to Sheet32 How do I use an Arduino to communicate with the Excel data streamer?
Leif Brenne
Microsoft
Nov 08, 2019
ESBlan 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
- ESBlan
  Copper Contributor
  Nov 09, 2019
  Leif Brenne
  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
    Microsoft
    Nov 12, 2019
    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.
- Cam_Jackson_2490
  Copper Contributor
  Oct 25, 2023
  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>.
rubayet_alam
Copper Contributor
Jul 23, 2021
ESBlan Can you tell me how you added Data Streamer, I just can't find it anywhere.
- SergeiBaklan
  MVP
  Jul 23, 2021
  rubayet_alam
  
  Are you on Excel 365?
  - Rieungsit
    Copper Contributor
    Feb 09, 2023
    SergeiBaklan : Thank you so much, Yes I use MS Office 365. But AddIns on PopUp doesn't have Data streamer module. recommend my to fix this problem yet.

Forum Discussion

Excel Data Streamer

Share

Resources