Reading multiple number of an EXCEL file without knowing number of rows and columns
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello, In code below i have to specify the range for columns but i have 100 set of excel files in that with different column length so how to specify in that case
[~,~,raw]=xlsread(fullFileName,'Results','B:B'); % reads all rows in Column B
raw(any(cellfun(@(x) any(isnan(x)),raw),2),:) = []; % removes all NaN entries#
data = reshape([raw{:}],size(raw));
Blob = data(:,1);
Area = data(:,2);
clearvars data raw;
h=bar(Area);
After then I would like to plot them I am getting error
0 commentaires
Réponses (1)
Azzi Abdelmalek
le 3 Avr 2014
To read all the rows just write
[a,b,c]=xlsread('filename.xls')
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!