RS232 to Excel. Four methods to send data from RS232 to Excel

RS232 TO EXCEL. FOUR METHODS TO SEND DATA FROM RS232 TO EXCEL

Problem scenario:

I want to receive my data from an RS232 (COM) port and send it to Microsoft Excel to further process and analyze.

Requirements:

• Several plugins for this software.

It is assumed that:

You’ve configured communication parameters (baud rate, the number of data bits, flow control, etc.) in the data logger and can receive any data without communication errors.

Solution:

Our software allows you to send your data from RS232 (COM port) to Excel in followings ways:

CONNECT RS232 TO EXCEL WITH THE HELP OF THE LOCAL DATABASE PLUGIN.

Advantages:

• Doesn’t require installing Excel on a production computer;
• Possibility to create Excel files in the background.

Disadvantages:

• Re-creates an Excel file every time and therefore requires rather more computer’s resources if your data flow is fast;
• Unable to export data from several RS232 ports to one file.

Read the tutorialabout this method.

LINK RS232 TO EXCEL WITH THE HELP OF THE DIRECT EXCEL CONNECTION PLUGIN.

Advantages:

• Allows you to place parsed data to any columns and rows;
• It is handy if you want to watch your RS232 data in a real-time environment.

Disadvantages:

• Requires Excel on the production computer, if you add charts and formulas to Excel files, this link will be very slow.

Read the tutorialabout this method.

SEND DATA FROM RS232 TO EXCEL WITH THE HELP OF THE DDE INTERFACE.

Advantages:

• Allows you to place parsed data to any columns and rows;
• Is very useful if you want to watch your RS232 data in a real-time environment;
• Excel automatically starts the data logger software;
• Allows you to use the data logger on a remote computer (in this case, DDE works over a network);
• It will enable you to process data from RS232 in Excel with the help of a VBA code.

Disadvantages:

• Requires Excel on a production computer, if you add charts and formulas to Excel files, this link become slower;
• This way requires some VBA knowledge.

Read the tutorialabout this method.

RECEIVE DATA FROM RS232 TO EXCEL WITH THE HELP OF OUR ACTIVEX CONTROL.

Advantages:

• Allows you to process data as you want;
• Will enable you to receive unparsed binary RAW data from RS232 to Excel;
• Allows you to receive notifications about program events;
• Allows you to send data from Excel to RS232;
• Excel automatically starts the data logger software;
• Is very useful if you want to watch your RS232 data in a real-time environment
• It allows you to process data from RS232 in Excel with the help of a VBA code.

Disadvantages:

• Requires Excel on a production computer;
• Requires in-depth VBA knowledge;
• ActiveXcontrol isn’t free and requires an additional license.

Downloadthe necessary ActiveX control from our site. An example and the help file will be installed with the ActiveX control.

RELATED ARTICLES: RS232 TO EXCEL. FOUR METHODS TO SEND DATA FROM RS232 TO EXCEL

• Write data to a CSV text file
• Write data to an XLS file without Microsoft Excel installed
• Send data to Excel through the DDE interface