Mitsubishi Electric MELSEC-Q/L - Page 796

794
7 APPLICATION INSTRUCTIONS
7.19 Other Instructions
• If the number of columns varies in each row, the data is also read by ignoring the rows.
Such file cannot be created using EXCEL. This happens when CSV file is modified by a user.
Ex.
If the number of columns varies in each row when the data is read:
SP.FREAD D10K2U0 D20 D99 M0
H0100D10
D11
D12
D13
D14
D15
D16
D17
D20
D21
D22
D099
D100
D101
D106
-
K7
-
K0
K0
K0
K0
H4241
H4443
H0000
K7
K0
K0
K0
K0
K-21
K0
K0
D105
D103
D102
D104
, , CR LF
CR LF
, -21 , CR LF
,
K-21
Data to be read into devices
Data that was read
File name
Control data
Control data
Execution/completion type
Not used
Number of request read data
Number of columns designation
Data type specification
File name
"ABCD"
Not used
Main/sub item
Data between , and ,
Read
data
Temperature
Measured value
Length
Excess
Loaded data
Stores the number of read data
Reading result (Number of read data)
Since " -21 " is a numeric value, it is converted to a binary value.
Conversion data (0) is stored since " " is nonnumeric data.
Conversion data (0) is stored since "Length" is nonnumeric data.
Conversion data (0) is stored since "Temperature" is nonnumeric data.
Conversion data (0) is stored since "Excess" is nonnumeric data.
Conversion data (0) is stored since "Measured value" is nonnumeric data.
Conversion data (0) is stored since "Main/sub item" is nonnumeric data.
File position
Main / sub item Measured value Excess
Length
Temperature
Data saved as a CSV file