Use the File > Import Table... command to import curve data from any ASCII tables. Some additional entries are necessary for this.
Time Axis
Select whether the first column of the table contains the values for the time axis, or if the values for the time axis should be calculated based on a fixed interval.
Time Unit
Select the time unit for the sampling interval or for the values for the time axis in the first column of the table. Choose the setting "<other>" if time points are irrelevant for the curve. In this case the X axis has no dimension.
Column Separator Character
Enter the character used to separate the columns.
Hex Numbers
Select this check box if the values are hexadecimal numbers.
The following rules apply to the importing of text tables:
- Text files can contain an introduction as a comment or as a column title. The introduction ends with the first line that begins with a number.
- The introduction is assumed as a comment until the penultimate line.
- The last line of the introduction is the column header. The curve names are determined from this. The names of the curves must be separated by the given separator.
- The physical unit can follow the curve name in square brackets (for example: Temperature [degrees]).
- The measured data are read in line-by-line, and is assigned to the curves. The measured data must be separated by the given separator or by a blank space.
- Floating-point numbers can use a period or comma as the decimal character. This character may then not be used as the column separator.
- The first column can contain the common time axis.
- Columns that only contain "0" or "1" are displayed as PLC logic channels.
Imported text tables are treated as oscilloscope files, and can be saved as *.sco files or printed.
If you want to import a table from Excel, then first save the table in Excel as a *.csv file. The first row before the measured data should contain the curve names, and, if desired, the physical units in square brackets. Any number of comment lines can be above this row. CSV files are text tables whose columns are generally separated by semicolons ‘;’.