[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: xlsread: to read the first column
|
From: |
PhilipNienhuis |
|
Subject: |
Re: xlsread: to read the first column |
|
Date: |
Fri, 3 Aug 2018 08:05:05 -0500 (CDT) |
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