Mitsubishi MELSEC-Q/L User Manual

642
SP.FREAD
(e) When the designated number of columns is 0, the data is read by ignoring the rows in CSV format file.
When data is read after CSV format conversion and the designated No. of columns is 0:
Example
Read
d
ata
Data created by EXCEL
Data saved in the CSV format
Main / sub item , , Measured value
CR
LF
Length
,1,3CRLF
Temperature
, -21 , CR LF
Data to be read into devices
SP.FREAD
D10
K2
U0 D20 D99
M0
Data that was read
File name
Control data
Control data
Loaded data
Stores the number of read data
H0100D10
D11
D12
D13
D14
D15
D16
D17
D20
D21
D22
D099
D100
D101
D102
D103
D104
D105
D106
-
K9
-
K0
K0
K0
K0
H4241
H4443
H0045
K9
K0
K0
K0
K0
K1
K3
K0
Execution/completion type
Not used
No. of request read data
No. of columns designation
Data type specification
File name
"ABCDE"
Reading result (No. of read data)
Not used
File position
Measured value
Length
1
3
Temperature
-21
Main/sub item
K-21
K0
D107
D108
Data between , and ,
Data between , and CR
Since " 1 " is a numeric value, it is converted to a binary value.
Since " 3 " is a numeric value, it is converted to a binary value.
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 " " is nonnumeric data.
Conversion data (0) is stored since "Length" 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.
Conversion data (0) is stored since "Temperature" is nonnumeric data.
Main / sub item
Measured value
Length
Temperature

Mitsubishi MELSEC-Q/L Specifications

General

Brand	Mitsubishi
Model	MELSEC-Q/L
Category	Controller
Language	English