reading excel data, without knowing range

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');

Answer 1

[Ora Zyto]

John, Does reading from the entire worksheet satisfy your requirements?

B = xlsread('myExample.xls', 'MySheet')

Answer 2

[Aldin]

[~,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 :)

[Mohammed NACIRI]

Hey

could you please share with me the NEDC excel data

[Walter Roberson]

https://www.researchgate.net/post/Nedc_Wltp_cycle_tables