Advanced Serial Data Logger

For Windows 2000 - Windows 8.1 (2012) (incl. Server, x86 and x64). Latest version: 4.1.7 build 1209. .

Trust In Confidence!

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

Software Configuration and Integration Service

If you have encountered problems with configuration or need a custom solution try our Software Configuration and Integration Service. It's free, fast (usually the same day) and efficient! Submit your case here or email to support _at_ aggsoft.com and receive a customized solution!

Problem scenario:

I would to receive my data from a RS232 (COM) port and send this data to Microsoft Excel for further processing and analyzing.

Requirements:

It is assumed that:

You've configured communication parameters (baud rate, 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 help of the Local database plug-in

Advantages:

  • Doesn't require to install Excel on the production PC;
  • Can create Excel files in background.

Disadvantages:

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

Read the tutorial about this method.

Link RS232 to Excel with help of the Direct Excel connection plug-in

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.

Disadvantages:

  • Requires Excel on the production PC, if you'll add charts and formulas to an Excel files, then this link will be very slow.

Read the tutorial about this method.

Send data from RS232 to Excel with 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 to use the data logger on a remote PC (DDE over network is used in this case);
  • Allows you to process data from RS232 in Excel with help of VBA code.

Disadvantages:

  • Requires Excel on the production PC, if you'll add charts and formulas to an Excel files, then this link will be very slow;
  • Requires small VBA knowledge.

Read the tutorial about this method.

Receive data from RS232 to Excel with help of our ActiveX control

Advantages:

  • Allows you to process data as you want;
  • Allows 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
  • Allows you to process data from RS232 in Excel with help of VBA code.

Disadvantages:

  • Requires Excel on the production PC;
  • Requires deep VBA knowledge;
  • ActiveX control isn't free and requires an additional license.

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

Related articles: