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
data
Data
created
by
E
XC
EL
Data
sa
v
ed
i
n
the
CSV
format
Ma
i
n
/
sub
i
tem
,
,
Measured
v
a
l
ue CR
LF
L
ength
,
1 ,
3 CR
LF
T
emperature ,
-
21
, CR
LF
Data
to
be
read
i
nto
de
vi
ces
SP
.F
R
E
AD
D10
K
2
U
0
D20 D99 M0
Data
that
w
as
read
Fil
e
name
Contro
l
data
Contro
l
data
L
oaded
data
Stores
the
number
of
read
data
H
0100
D10
D11
D12
D13
D1
4
D15
D16
D17
D20
D21
D22
D099
D100
D101
D102
D103
D10
4
D105
D106
-
K
9
-
K
0
K
0
K
0
K
0
H4
2
4
1
H444
3
H
00
4
5
K
9
K
0
K
0
K
0
K
0
K
1
K
3
K
0
E
xecut
i
on
/
comp
l
et
i
on
type
N
ot
used
N
o
.
of
request
read
data
N
o
.
of
co
l
umns
des
i
gnat
i
on
Data
type
spec
i
f
i
cat
i
on
Fil
e
name
"
ABCD
E"
Read
i
ng
resu
l
t
(
N
o
.
of
read
data)
N
ot
used
Fil
e
pos
i
t
i
on
Measured
v
a
l
ue
L
ength
1
3
T
emperature
-
21
Ma
i
n
/
sub
i
tem
K-
21
K
0
D107
D108
Data
bet
w
een
,
and
,
Data
bet
w
een
,
and
CR
S
i
nce
"
1
" i
s
a
numer
i
c
v
a
l
ue,
i
t
i
s
con
v
erted
to
a
b
i
nary
v
a
l
ue
.
S
i
nce
"
3
" i
s
a
numer
i
c
v
a
l
ue,
i
t
i
s
con
v
erted
to
a
b
i
nary
v
a
l
ue
.
S
i
nce
" -
21
" i
s
a
numer
i
c
v
a
l
ue,
i
t
i
s
con
v
erted
to
a
b
i
nary
v
a
l
ue
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
" " i
s
nonnumer
i
c
data
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
" " i
s
nonnumer
i
c
data
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
"L
ength
" i
s
nonnumer
i
c
data
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
"
Measured
v
a
l
ue
" i
s
nonnumer
i
c
data
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
"
Ma
i
n
/
sub
i
tem
" i
s
nonnumer
i
c
data
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
"T
emperature
" i
s
nonnumer
i
c
data
.
Ma
i
n
/
sub
i
tem
Measured
v
a
l
ue
L
ength
T
emperature