reading excel data, without knowing range
14 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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');
0 Commenti
Risposte (2)
Ora Zyto
il 16 Dic 2011
John, Does reading from the entire worksheet satisfy your requirements?
B = xlsread('myExample.xls', 'MySheet')
0 Commenti
Aldin
il 16 Dic 2011
Modificato: Walter Roberson
il 4 Mag 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 :)
2 Commenti
Mohammed NACIRI
il 4 Mag 2020
Modificato: Mohammed NACIRI
il 4 Mag 2020
Hey
could you please share with me the NEDC excel data
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!