Mitsubishi MELSEC-Q/L User Manual

643
SP.FREAD
1
2
3
4
4
6
7
8
7.18 Other instructions 7.18.13 SP.FREAD
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.
If the number of columns varies in each row when the data is read:
Example
-21
Data to be read into devices
SP.FREAD
D10K2U0 D20 D99
M0
Data that was read
File name
Control data
Control data
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
Execution/completion type
Not used
No. of request read data
No.
of columns designation
Data type specification
File name
"ABCD"
Not used
Main/sub item
Data between , and ,
Read
data
Main / sub item , , Measured value Excess CR LF
Length
CR LF
Temperature
, -21 , CR LF
,
K0
K0
Temperature
D105
D103
Measured value
D102
Length
D104
Excess
Loaded data
Stores the number of read data
Reading result (No. 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 val
ue" is nonnumeric data.
Conversion data (0) is stored since "Main/sub item" is nonnumeric data.
File position

Mitsubishi MELSEC-Q/L Specifications

General

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