reading excel data, without knowing range

23 views (last 30 days)
John
John on 16 Dec 2011
Commented: Walter Roberson on 4 May 2020
Hi,
I have a line of code that reads in files from excel for a specific range. However, I don't know the last row of data in every file. Could somebody advise me on how to read in the data without knowing the number of the last row of data in advance.
May thanks
sch_cycle=xlsread('C:\Autonomie drive cycles\NEDC.xlsx','Sheet1','A2:B20');

Answers (2)

Ora Zyto
Ora Zyto on 16 Dec 2011
John, Does reading from the entire worksheet satisfy your requirements?
B = xlsread('myExample.xls', 'MySheet')

Aldin
Aldin on 16 Dec 2011
Edited: Walter Roberson on 4 May 2020
[~,leng] = xlsread('NEDC.xls','Sheet1', 'A:A'); %column in array
l = length(leng); %length of column
length_string = num2str(l+1);
num = ['A',length_string]; % A1 or A2 or A3 it depends of length
xlswrite('NEDC.xls','Jhon','Sheet1',num);
That's my algorithm :)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!