8.4 Reading Data from Specified File
8-25
8
QCPU
INS
T
R
UCTIONS
SP
_FREAD
SP_FREAD
(e) When the specified number of columns is 0, the data are read by ignoring the rows in
CSV format file.
When data are read after CSV format conversion and the specified number
of columns is 0.
If the number of columns varies in each row, the data are also read by ignoring the rows.
Example
D
ata to
b
e read into devices
S
P_F
R
E
AD(
T
R
UE
,
2
,
Var_
D
20
,
Var_
D
10
,
Var_
D99,
Var_M0
);
D
ata t
h
at
w
as read
C
ontrol data
File name
D
ata created
by
E
XC
EL
D
ata saved in t
h
e
CS
V
f
ormat
Main / s
ub
item
Lengt
h
Temperat
u
re
,
,
,
,
1
-21
Meas
u
red val
u
e
, 3
,
CR
CR
LF
CR
LF
LF
A
1
2
3
Main / s
ub
item
Meas
u
red val
u
e
Lengt
h
Temperat
u
re
1
3
-21
4
B
C
R
ead
data
C
ontrol data
0100
H
Var_
D
10
Var_
D
20
Var_
D99
-
K
9
-
K0
K0
K0
K0
4241
H
444
3
H
004
5
H
K
9
K0
K0
K0
K0
K1
K
3
K0
Exec
u
tion/completion t
y
pe
N
u
m
b
er o
f
u
n
u
sed read data
R
e
qu
est
S
peci
f
ication o
f
t
h
e n
u
m
b
er o
f
col
u
mns
D
ata t
y
pe speci
f
ication
File name
"
A
B
CD
E"
N
u
m
b
er o
f
read res
u
lt data
Not
u
sed
Meas
u
red val
u
e
Lengt
h
1
3
Temperat
u
re
K-21
Main/s
ub
item
K-21
K0
D
ata
b
et
w
een
,
and
,
D
ata
b
et
w
een
,
and
CR
"Main/s
ub
item"
S
ince t
h
is is not n
u
meric val
u
e data
,
conversion data
(
0
)
is stored.
" "
S
ince t
h
is is not n
u
meric val
u
e data
,
conversion data
(
0
)
is stored.
"Meas
u
red val
u
e"
S
ince t
h
is is not n
u
meric val
u
e data
,
conversion data
(
0
)
is stored.
"Lengt
h
"
S
ince t
h
is is not n
u
meric val
u
e data
,
conversion data
(
0
)
is stored.
1
S
ince t
h
is is n
u
meric val
u
e data
,
it is converted to
b
inar
y
data.
3
S
ince t
h
is is n
u
meric val
u
e data
,
it is converted to
b
inar
y
data.
"Temperat
u
re"
S
ince t
h
is is not n
u
meric val
u
e data
,
conversion data
(
0
)
is stored.
-21
S
ince t
h
is is n
u
meric val
u
e data
,
it is converted to
b
inar
y
data.
" "
S
ince t
h
is is not n
u
meric val
u
e data
,
conversion data
(
0
)
is stored.
S
tores t
h
e n
u
m
b
er
o
f
read data
Summary of Contents for MELSEC Q Series
Page 1: ...Structured Programming Manual Mitsubishi Programmable Controller QCPU Common Instructions ...
Page 2: ......
Page 14: ...A 12 MEMO ...
Page 340: ...6 178 MEMO MTR ...
Page 708: ...7 368 MEMO ...
Page 776: ...8 68 MEMO ...
Page 796: ...9 20 MEMO ...
Page 804: ...App 8 MEMO ...
Page 812: ...Index 8 MEMO ...
Page 815: ......