Excel¶
SIMION can output data to Excel in a few ways:
- Writing a text file that can later be loaded into Excel.
This is most convenient if written in a comma-separated value (CSV)
format with extension “.csv”, which can be opened into Excel just
by dobule clicking without the Excel Text Import Wizard.
You can do this from various functions including
- Data Recording (Exporting “data recording” results to text file),
- a Lua user program. Some examples of that type of thing: Loading/saving array from a text file.
- SL Tools.
- ION File particle definitions are essentially a CSV file but with an .ion extension.
- Use the COM interface, which allows real-time control of the Excel window from Lua (e.g. points incrementally added to an Excel plot as the simulation progresses). See SIMION Example: excel for details. This approach only works on Windows platforms, but a similar approach is available with gnuplot (see SIMION Example: gnuplot), or you can use the first approach with Excel or an Excel-like program (OpenOffice, Google Spreadsheets, etc.)