Filter
Top Products
7-428
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
data
Data created by EXCEL
Data saved in the CSV format
Main / sub item , , Measured value
CR
LF
Length
, 1 , 3 CR LF
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
Contro
l 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
Number of unused read data
Request
Designation of the number of columns
Data type specification
File name
"ABCDE"
Number of read result data
Not used
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 va
lue" 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