Continue to Site

Welcome to EDAboard.com

Welcome to our site! EDAboard.com is an international Electronics Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.

Export data from EXCEL to UART

Status
Not open for further replies.

anboli

Full Member level 2
Joined
Mar 9, 2012
Messages
144
Helped
4
Reputation
8
Reaction score
4
Trophy points
1,298
Activity points
2,512
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.
 

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
 

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.
 

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.
 

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
 

Status
Not open for further replies.

Part and Inventory Search

Welcome to EDABoard.com

Sponsor

Back
Top