xlsread: to read the first column

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

xlsread: to read the first column

LucaLuca
This post was updated on .
hi,
i want to read all column "A"

A1
A2
A3
A4

all column A if there are any values

[NUMARR, TXTARR, RAWARR, LIMITS] = xlsread (percorsoNomeFile,'A1:A20')

here i read column until A20..but i don't want this

i want to read infinite cell



--
Sent from: http://octave.1599824.n4.nabble.com/Octave-General-f1599825.html


Reply | Threaded
Open this post in threaded view
|

Re: xlsread: to read the first column

PhilipNienhuis
LucaLuca wrote

> hi,
> i want to read all column "A"
>
> A1
> A2
> A3
> A4
>
> all column A if there are any values
>
> [NUMARR, TXTARR, RAWARR, LIMITS] = xlsread (percorsoNomeFile,'A1:A20')
>
> here i read column until A20..but i don't want this
>
> i want to read infinite cell

Just specify the max admissible row nr in the range
('A1:A<verylargenumber>'). You can find on the web what that max nr
(<verylargenumber>) is for specific spreadsheet file types.  IIRC for .xlsx
it's about 10^6 but better check that out yourself.

Philip




--
Sent from: http://octave.1599824.n4.nabble.com/Octave-General-f1599825.html