Creating an Excel spreadsheet

The simplest way to create an Excel spreadsheet is to create a file in the .CSV format. An example is available.

On Microsoft Windows, you can create an Excel file directly by making ActiveX calls. No ActiveX capabilities are accessible on Linux.

ActiveX programming requires a strong programming background. However, unlike a .CSV file, ActiveX allows complete control over the content and style of your Excel file.

Example (this script can be downloaded at the bottom of this page):

This script asks the user for datasets on disk. Then, it opens Excel and creates one workbook with the path of each file selected, as well as the number of traces for each one of these files. The header names are in bold, and each column is sized appropriately. Here is an example of output:

ActiveX capabilities in INTViewer rely internally on the Jacob library. More information about Jacob is available at http://danadler.com/jacob/

More information about the Excel object model is available at https://msdn.microsoft.com/en-us/library/ff194068.aspx

A similar example is available for PowerPoint presentations.