Export data from EXCEL to UART

[anboli]

Hi all,
i have to create a tabular column with 10rows and 6columns in excel.
This tabular column data has to sent out through UART.
is is possible to sent out the data from excel to UART communication?
if it is so, please guide me.

 

[KlausST]

Hi,

several ways:

* generate a text file and send this vial UART.
* use a VBA script and send the data via MSCOMM

but in any case you need to know what UART parameters to use, data format and protocol.

Klaus

 

[anboli]

Thanks for the reply,

I need to sent it in RS232 protocal.

i just sharing the sample data excel sheet,

Name Age Place Degree
ABC 18 ZYX BE
DEF 20 YJK BE
JKL 45 WER MSc

those data has to send out through USB to RS232 converter. by selecting the com port.
what shall i have to do. please explain me step by step. so that i could try it in system.

 

[andre_luis]

Another simple way to send the content of an excel compatible file through serial port is by saving the file with CSV formatting, which is nothing more a text format separated by ';' delimiters, but in order to make the communication to be a bit robust you must add in the first and last line extra characters meaning start and end of transmission. It would also be prudent to add optionally on the penultimate line an extra field containing the checksum of the previous lines, something extremely easy to do with the Excel's builtin math functions.

 

[KlausST]

Hi,

RS232 is an hardware interface standard, it is no protocol.

you at least need to define:
* character set (It seems you purely use ASCII strings)
* column delimiter
* row delimiter
* end of file delimiter

****
* save excel file as your_text_file.
* open a dos window
* MODE COMx: your_port_parameter
* COPY your_text_file COMx

Klaus

 

[aarmalo]

The easy way is just to convert to CSV as the previous posts, but there are out there libraries that can help you to read the EXCEL files

As example in python you can use the next lib

https://openpyxl.readthedocs.io/en/default/