Excel Data Streamer

%3CLINGO-SUB%20id%3D%22lingo-sub-994518%22%20slang%3D%22en-US%22%3EExcel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-994518%22%20slang%3D%22en-US%22%3E%3CP%3E1)%20I%20included%20Data%20Streamer%20as%20an%20Excel%20add-in%20as%20per%20Microsoft%20Help%3C%2FP%3E%3CP%3E2)%20I%20am%20quite%20an%20experienced%20user.%20I%20set%20up%20a%20USB%20csv%20serial%20data%20stream%20from%20my%20microprocessor.%20I%20know%20that%20it%20is%20a%20valid%20csv%20serial%20data%20stream%20on%20USB%20port%205%20because%20I%20was%20able%20to%20view%20it%20on%20two%20different%20serial%20terminal%20programs%3C%2FP%3E%3CP%3E3)%20I%20set%20up%20all%20the%20correct%20parameters%20for%20the%20serial%20data%20stream.%20When%20I%20entered%20%22Data%20Streamer%20-%26gt%3B%20Connect%20a%20device%22%20I%20was%20able%20to%20connect%20to%20USB%20Port%205%3C%2FP%3E%3CP%3E4)%20However%20when%20I%20clicked%20%22Start%20Data%22%2C%20%26nbsp%3B%20no%20data%20stream%20was%20captured%20into%20excel.%3C%2FP%3E%3CP%3E5)%20So%20Excel%20Data%20Streamer%20is%20not%20receiving%20a%20valid%20csv%20data%20stream!%3C%2FP%3E%3CP%3EAny%20ideas%20on%20how%20to%20progress%20this%20issue.%20It%20is%20very%20frustrating%20because%20I%20know%20the%20valid%20stream%20is%20there%20-%20I%20can%20see%20it%20on%20Two%20serial%20terminal%20programs!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-994518%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995929%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F451530%22%20target%3D%22_blank%22%3E%40ESBlan%3C%2FA%3E%26nbsp%3BI've%20reached%20out%20the%20Data%20Streamer%20team%20to%20see%20if%20they%20can%20take%20a%20look%20at%20your%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995958%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F451530%22%20target%3D%22_blank%22%3E%40ESBlan%3C%2FA%3E%26nbsp%3BCouple%20of%20questions%3A%3C%2FP%3E%0A%3CP%3EWhat%20microprocessor%20are%20you%20using%3F%3C%2FP%3E%0A%3CP%3EIs%20the%20format%20of%20the%20data%20following%20the%20data%20format%20listed%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Feducation%2Fdata-streamer%2Fconnecting-serial-devices%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Feducation%2Fdata-streamer%2Fconnecting-serial-devices%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-996308%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-996308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11689%22%20target%3D%22_blank%22%3E%40Leif%20Brenne%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELeif%2C%20thank%20you%20for%20your%20interest.%3C%2FP%3E%3CP%3EI%20am%20using%20the%20Parallax%20Propeller%201%20microprocessor.%3C%2FP%3E%3CP%3EThe%20serial%20stream%20format%20is%20exactly%20as%20per%20the%20Arduino%20example%3B%20data%20separated%20by%20commas%20and%20carriage%20return%20(ASCII%2013)%20at%20the%20end%20of%20line.%3C%2FP%3E%3CP%3EI%20know%20the%20serial%20stream%20is%20valid%20because%20I%20was%20able%20to%20observe%20it%20on%20the%20PC%20using%20two%20terminal%20programs%3B%20Parallax%20Serial%20Terminal%20and%20Bray%20Terminal.%3C%2FP%3E%3CP%3EExcel%20Data%20Streamer%20displays%20the%20serial%20stream%20port%20as%20%22USB%20Port%205%22%2C%20but%20when%20I%20click%20on%20it%20and%20start%20the%20data%20steam%20there%20is%20no%20action.%3C%2FP%3E%3CP%3EI%20have%20even%20tried%20with%20csv%20text%20data%20and%20it%20does%20not%20recognize%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1003374%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1003374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F451530%22%20target%3D%22_blank%22%3E%40ESBlan%3C%2FA%3E%26nbsp%3BThanks%20for%20getting%20back%20to%20me.%26nbsp%3B%20We%20have%20not%20tested%20Data%20Streamer%20with%26nbsp%3B%3CSPAN%3EParallax%20Propeller%20(%20we%20have%20been%20testing%20this%20with%20Arduino%2C%20Microbit%2C%20Circuit%20Playground%2C%20ESP32.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWe%20had%20a%20similar%20issue%20to%20what%20you%20are%20experiencing%20below%20with%20ESP32.%26nbsp%3B%20This%20was%20caused%20by%20not%20using%20the%20default%20handshake%20command%20for%20RTS.%20The%20fix%20for%20ESP32%20is%20coming%20out%20in%20the%20next%20release%20of%20Office%20(%201911)%20and%20it%20might%20help%20out%20on%20your%20issue%20as%20well.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1004348%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1004348%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11689%22%20target%3D%22_blank%22%3E%40Leif%20Brenne%3C%2FA%3E%2C%3C%2FP%3E%3CP%3ELeif%2C%20thanks%20for%20your%20response.%3C%2FP%3E%3CP%3EThe%20Parallax%20modules%20mostly%20use%20the%20FTDI%20USB%20interface%2C%20so%20out%20of%20frustration%20with%20the%20Microsoft%20Data%20Streamer%2C%20the%20Parallax%20community%20has%20devised%20their%20own%20open%20Excel%20Data%20Streamer%20using%20FTD2XX.DLL%20with%20VBA.%20Read%20this%20thread%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fforums.parallax.com%2Fdiscussion%2F170735%2Fexcel-ftdi-serial-data-logger%23latest%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fforums.parallax.com%2Fdiscussion%2F170735%2Fexcel-ftdi-serial-data-logger%23latest%3C%2FA%3E%3C%2FP%3E%3CP%3EThis%20community%20Excel%20Data%20Streamer%20streamer%20is%20very%20robust%2C%20and%20as%20one%20poster%20comments%20%22The%20FTDI%20DLL%20works%20well%20because%20it%20totally%20bypasses%20Windows%22.%3C%2FP%3E%3CP%3EYou%20should%20sort%20out%20the%20Microsoft%20Data%20Streamer%20interface%20to%20the%20Parallax%20modules%20because%20Parallax%20is%20heavily%20involved%20in%20STEM%20education%20at%20all%20levels%20-%20see%20this%20website%3B%20%3CA%20href%3D%22https%3A%2F%2Fwww.parallax.com%2Feducation%2Fteach%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.parallax.com%2Feducation%2Fteach%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1034652%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1034652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F451530%22%20target%3D%22_blank%22%3E%40ESBlan%3C%2FA%3E%26nbsp%3BThanks%20again%20for%20the%20additional%20information.%20We%20did%20get%20a%20Parallax%20board%20in-house%20to%20try%20this%20out.%20We%20did%20replicate%20the%20same%20issue%20you%20where%20seeing%2C%20but%20we%20were%20able%20to%20get%20this%20working%20correctly%20when%20we%20changed%20the%20baud%20rate.%20Data%20Streamer%20is%20set%20to%20using%20the%20baud%20rate%209600%20by%20default.%20You%20can%20change%20this%20in%20Data%20Streamer%20by%20going%20to%20Advanced%20Settings%20and%20Settings%20tab.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159042iB6D35857FC037A88%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBy%20setting%20the%20baud%20rate%20to%20115200%2C%20we%20received%20data%20correctly%20in%20Data%20Streamer.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1396183%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1396183%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11689%22%20target%3D%22_blank%22%3E%40Leif%20Brenne%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20a%20similar%20issue%20where%20no%20data%20is%20received%20by%20excel.%26nbsp%3B%20I%20am%20using%20an%20%3CA%20href%3D%22https%3A%2F%2Fwww.adafruit.com%2Fproduct%2F3857%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EAdafruit%20Feather%20M4%20express%3C%2FA%3E.%20This%20board%20is%20a%20bit%20different%20from%20the%20typical%20Arduino%20because%20it%20doesn't%20use%20a%20usb%20to%20serial%20chip%20but%20has%20USB%20support%20on%20the%20microcontroller%20itself.%20Maybe%20this%20is%20related%20to%20the%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20verified%20data%20is%20being%20sent%20using%20the%20proper%20format%20using%20the%20Arduino%20serial%20monitor.%26nbsp%3B%20Is%20there%20any%20additional%20debugging%20menus%20that%20could%20be%20added%3F%26nbsp%3B%20It%20is%20concerning%20that%20there%20is%20absolutely%20no%20indication%20of%20any%20information%20being%20received%2C%20there%20is%20no%20feedback%20and%20no%20errors%20are%20reported.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20there%20is%20any%20way%20I%20can%20collect%20debug%20information%20from%20excel%20to%20help%20diagnose%20the%20root%20cause%20of%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2580278%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580278%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F451530%22%20target%3D%22_blank%22%3E%40ESBlan%3C%2FA%3E%26nbsp%3BCan%20you%20tell%20me%20how%20you%20added%20Data%20Streamer%2C%20I%20just%20can't%20find%20it%20anywhere.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2580572%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580572%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111126%22%20target%3D%22_blank%22%3E%40rubayet_alam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20on%20Excel%20365%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

1) I included Data Streamer as an Excel add-in as per Microsoft Help

2) 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 programs

3) 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 5

4) 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!

9 Replies

@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.

 

@Leif Brenne,

Leif, thanks for your response.

The Parallax modules mostly use the FTDI USB interface, so out of frustration with the Microsoft Data Streamer, the Parallax community has devised their own open Excel Data Streamer using FTD2XX.DLL with VBA. Read this thread;

http://forums.parallax.com/discussion/170735/excel-ftdi-serial-data-logger#latest

This community Excel Data Streamer streamer is very robust, and as one poster comments "The FTDI DLL works well because it totally bypasses Windows".

You should sort out the Microsoft Data Streamer interface to the Parallax modules because Parallax is heavily involved in STEM education at all levels - see this website; https://www.parallax.com/education/teach

 

@ESBlan Thanks again for the additional information. We did get a Parallax board in-house to try this out. We did replicate the same issue you where seeing, but we were able to get this working correctly when we changed the baud rate. Data Streamer is set to using the baud rate 9600 by default. You can change this in Data Streamer by going to Advanced Settings and Settings tab.

clipboard_image_0.png

 

By setting the baud rate to 115200, we received data correctly in Data Streamer. 

@Leif Brenne 

I am having a similar issue where no data is received by excel.  I am using an Adafruit Feather M4 express. This board is a bit different from the typical Arduino because it doesn't use a usb to serial chip but has USB support on the microcontroller itself. Maybe this is related to the issue?

 

I have verified data is being sent using the proper format using the Arduino serial monitor.  Is there any additional debugging menus that could be added?  It is concerning that there is absolutely no indication of any information being received, there is no feedback and no errors are reported.

 

Please let me know if there is any way I can collect debug information from excel to help diagnose the root cause of this issue.

 

Thanks!

@ESBlan Can you tell me how you added Data Streamer, I just can't find it anywhere.

@rubayet_alam 

Are you on Excel 365?