Mitsubishi Electric MELSEC iQ-R Series - Page 613

7 APPLICATION INSTRUCTIONS
7.6 Reading/Writing Data Instructions
611
7
• When the specified number of columns is set to a value other than 0, a CSV format file is read as the table with the
specified number of columns. The elements outside the specified number of columns are ignored.
Ex.
When "Reading data after converted to CSV format" (Decimal (16-bit data)) is specified and the number of columns is set to a
value other than 0 ((d1)+6 is set to 2)
(1) Columns out of the specified range are ignored.
(2) Loaded data
(3) File name
(4) 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 "Length" is not a numerical value, the conversion data, 0, is stored.
D103: Since "1" is a numerical value, it is converted to a binary value.
D104: Since "Temperature" is not a numerical value, the conversion data, 0, is stored.
D105: Since "-21" is a numerical value, it is converted to a binary value.
[Data created in Excel]
, , CR LF
,,3CRLF
, -21 , CR LF
1
(1)
[Data saved in CSV format]
Main/sub item Measured value
Length
Temperature
SP.FREAD
D10
K2
U0 "ABCD" D99
M0
(2)
(3)
(4)
[Data to be loaded to the device]
0100HD10
D11
D12
D13
D14
D15
D16
D17
-
K6
K0
K0
K0
K2
K0
[Control data]
D99
D100
D101
D102
D103
D104
D105
K6
K0
K0
K0
K1
K0
K-21
[Loaded data]