Mitsubishi Electric MELSEC iQ-R Series Programming Manual page 611

Ex.
When "Reading data after converted to CSV format" (Decimal (16-bit data)) is specified and the number of columns is set to 0
[Data created in Excel]
[Data saved in CSV format]
Main/sub item , , Measured value
Length , 1 , 3 CR LF
Temperature , -21 , CR LF
[Data to be loaded to the device]
SP.FREAD U0 K2 D10 "ABCDE" D99
[Control data]
D10 0100H
-
D11
D12 K9
D13 K0
D14 K0
D15 K0
D16 K0
D17 K0
[Loaded data]
D99
K9
D100 K0
D101 K0
D102
K0
D103 K0
D104 K1
D105
K3
D106 K0
D107 K-21
D108 K0
CR LF
(1) Loaded data
(2) File name
(3) Control data
M0
(1)
(2)
(3)
D10: Execution/completion type
D11: Completion status
D12: Number of read-target data
D13: Maximum number of read data
D14, D15: File position
D16: Number of columns
D17: Data type specification
D99: Number of data actually read
D100: Since "Main/sub item" is not a numerical value, the conversion data, 0, is stored.
D101: Since " " is not a numerical value, the conversion data, 0, is stored.
D102: Since "Measured value" is not a numerical value, the conversion data, 0, is
stored.
D103: Since "Length" is not a numerical value, the conversion data, 0, is stored.
D104: Since "1" is a numerical value, it is converted to a binary value.
D105: Since "3" is a numerical value, it is converted to a binary value.
D106: Since "Temperature" is not a numerical value, the conversion data, 0, is stored.
D107: Since "-21" is a numerical value, it is converted to a binary value.
D108: Since " " is not a numerical value, the conversion data, 0, is stored.
7 APPLICATION INSTRUCTIONS
7.6 Reading/Writing Data Instructions
7
609