A Simple Solution for Saving data into Excel

The ARMmite or ARMexpress can generate data for use in Excel. The USB port can be used to send data back to a PC. There are a number of ways to capture that data, including MSCOMM or Tcl. This is an example that uses a Tcl utility to control the ARMmite, capture data and then write that data into an Excel .CSV file.

Tcl is a cross-platform language that makes it easy to develop a GUI for various utilities. This example is taken from TclTerm, and shows how to open a serial port, capture incoming data, display that data to a text window, and finally write that data to Excel. Find the attached source and a Windows executable version.

For a minimalist Tcl program to do the same, here is the source for that.

BASIC program to produce Excel comma seperated data

The simplest method to do this, is to use the BASIC PRINT statement, to send data to the PC and then seperate each value with a comma. This may also be done using printf in C.

Here is a simple example of a BASIC program to generate this data.