25.11.4.1 CSV File Format
You can edit a CSV file saved on a CF Card/USB storage device
using general spreadsheet software (such as Excel) on a
computer.
The sampling data (SA****.csv) saved to CF Card/USB Storage
(SA*****.csv) is not the same as the [Display/Save in CSV]
settings. A portion of the format is fixed.
-
Regardless of the settings, the calculation rows
will not be output as CSV. Only the Item Name row and data display
rows will be outputted.
-
One Date column and one Time column will be
displayed in a fixed position. The date is output in the format
selected in the [CSV Date Format] list box. The time format is
fixed to hh:mm:ss. When the [Sampling Frequency] is set in
milliseconds, the time format is fixed to hh:mm:ss.000.
-
The Date/Time column item names are fixed as
"Date" and "Time". In Custom Settings, the Item Name row is not set
and will appear in the first row. In that case, the data column
item name will be blank.
-
Even if you set a Text row or Text column in the
Custom Settings, they will not be outputted in the CSV file.
-
If [Add Time Data] is not defined as the Action,
the Date column and Time column will be blank and only the item
name will be displayed.
-
In Custom Settings, if the Item Name column is
not set, the far left is the Date column, the 2nd is the Time
column, and the 3rd and other columns are the Data columns. The
order of the data columns will follow the order set in the Custom
Settings.
-
When multiple blocks are set, a space is inserted
between blocks.
-
Character codes in the CSV file only uses the
native code. Use Shift-JIS for Japanese. Western European languages
display using CodePage 1252. If you use text that does not exist in
CodePage 1252, it will be replaced by a single space.
-
For a read error, data is output as [****].
-
Even if the [Display Color], [Background
Color], [Text Color], [Numeral Value Color], or [Blink] color is
set, the color will not be output to the CSV file.
When a sampling data CSV file is opened in
Excel
Excel Display Example for Basic Settings
The following example shows how data is saved to the CF Card
with custom settings (CSV save), and how the CSV file looks in
Excel.
Mode
Display/Save in CSV Settings
Excel Display
Excel Display Example for Basic Settings
The following will introduce an example for when data is saved
to the CF Card with custom settings (CSV save) and the CSV file is
then opened in Excel.
Display/Save in CSV Settings
Excel Display
Display/Save in CSV Settings
Excel Display
|
