Advanced Serial Data Logger

for Windows 9x/Me/NT/2000/XP x86,x64/2003 x86,x64/Vista x86,x64. Latest version: 3.6.1 build 1015. October 16, 2008.

Trust In Confidence!

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

Problem scenario:

I would to receive my data from a RS232 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 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.

Contact us and we'll send you this ActiveX control with an example.

Related articles:

Capture a serial data to a Microsoft Excel spreadsheet (features: ASCII data parser with regular expressions, Excel export);

GPS data logger (features: ASCII data parser, data at fixed positions);

Weight data logger to a Microsoft Access database (features: ASCII data parser, data filter, data at fixed positions, export to Microsoft Access via ODBC);

Barcode data logger. Capture a barcode data from a serial port (features: ASCII data parser, data at fixed positions, export to a CSV file);

Barcode data logger. Capture barcodes to a log file (features: ASCII data parser, splitting by timeout, date/time stamps, advanced log file hints);

PBX data logger. Capture a serial data from PBX systems (features: ASCII data parser, data at fixed positions, export to Microsoft SQLServer 2000 via ODBC);

Log weight from a scale to a Microsoft Excel spreadsheet (features: ASCII data parser, data filter, data is separated by comma, export to a Microsoft Excel file);

Pressure data logger. Log data from an intellectual pressure measuring device (features: data query, ASCII data parser, at fixed positions);

Serial data acquisition in the Checkweigher Management Information System (features: ASCII data parser with regular expressions);

Serial port data aggregation. Combine a data of two different com-ports to one MySQL table row (features: ASCII data parser, aggregation, MySQL);

Serial port data and Excel. Real time charting. (features: ASCII data parser with regular expressions, direct excel export, charting);

Send serial port data to Excel via DDE. (features: dde server, charting);

Aircraft engine monitor (example of an usage, custom data parser module is developed for a customer);

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