Mitsubishi Electric MELSEC iQ-R Series Programming Manual page 612

• When the number of columns differs in each row, the data are also read by ignoring the rows.
Ex.
When the number of columns differs in each row
[Data saved in CSV format]
Main/sub item ,
Length CR LF
Temperature , -21
[Data to be loaded to the device]
SP.FREAD U0
[Control data]
D10 0100H
D11 -
D12 K7
D13 K0
D14 K0
D15 K0
D16 K0
D17 K0
[Loaded data]
D99 K7
K0
D100
D101
K0
D102 K0
D103 K0
D104
K0
D105
K0
D106 K-21
This type of file in which the number of columns vary with individual rows cannot be created by Excel. It is
created when the CSV file is modified by a user.
7 APPLICATION INSTRUCTIONS
610
7.6 Reading/Writing Data Instructions
, Measured value , Excess
, CR LF
M0
K2 D10 "ABCD" D99
(1)
(2)
(3)
CR LF
(1) Loaded data
(2) File name
(3) Control data
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 "Excess" is not a numerical value, the conversion data, 0, is stored.
D104: Since "Length" is not a numerical value, the conversion data, 0, is stored.
D105: Since "Temperature" is not a numerical value, the conversion data, 0, is stored.
D106: Since "-21" is a numerical value, it is converted to a binary value.