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.
sch_cycle=xlsread('C:\Autonomie drive cycles\NEDC.xlsx','Sheet1','A2:B20');
No products are associated with this question.
John, Does reading from the entire worksheet satisfy your requirements?
B = xlsread('myExample.xls', 'MySheet')
[~,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
That's my algorithm :)
Play games and win prizes!Learn more