Baud rate of 460800 in excel data streamer

Question

Hi, I am trying to acquire data from RPLIDAR C1 in excel data streamer, but the baud rate to make it work needs to be 460800. When I try to change it in excel data streamer it does not offer that speed and when i type it it does not seem to keep it. It's back to 9600 as soon as i close the advanced window. any suggestion?

nikolinode · Answer

Excel Data Streamer’s interface doesn’t allow setting arbitrary baud rates directly, and typing 460800 doesn’t persist because it’s not recognized as a valid option.

The easiest approach is usually to capture the data with another tool that supports your baud rate, then feed the data into Excel in a compatible way.

A workaround/suggestion:

Use a virtual COM port emulator or baud rate converter:

Use a software tool (like com0com or similar) to create a virtual COM port pair.
Connect your RPLIDAR device at 460800 baud to one virtual port.
Configure Excel Data Streamer to connect to the other virtual COM port but at a supported baud rate (e.g., 115200 or 230400).
The virtual port software will handle the baud rate translation between the device and Excel Data Streamer.

Or…

Check for Excel Data Streamer updates or alternative tools:

Microsoft may update the Data Streamer add-in with more baud rate options in the future.

Alternatively, consider dedicated serial-to-Excel tools that allow custom baud rates.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.