XLSX Excel files

PrestoPlot can open simple XLSX format Excel files (extension .xlsx). The files should contain columns of data using the same rules as for Generic Multicolumn files, excluding the Encoding comment, this is handled automatically.

The data should be present in the first rows and columns of the file, where saving the file as a TAB separated CSV file should produce the same results.

If a date is present it must be the first column in the file. Excel formatted dates are imported as ISO8601 format dates.

Tip

To add milliseconds values, use a custom format with hh:mm:ss.000.

The Description and Labels comments can be added and then » indicates a change of column. E.G. # Description : in the first column, PARAM in the second and the text of the description in the third.

# Description : » DEFICIT » Charge deficit

If the file contains multiple sheets then PrestoPlot will ask which sheets to load (from the command line -load will load every sheet unless specific sheets are specified).

Tip

Double clicking on one of the sheet names will load that sheet.

Selecting any sheet names and pressing enter will load the selected sheets.

The set of Generic CSV preferences will be used, except the Field Separator and Force Multi Space which are automatic.