Reading multiple number of an EXCEL file without knowing number of rows and columns
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Yogesh Babu
il 2 Apr 2014
Commentato: Jeff Johnson
il 4 Apr 2014
Hello, in the 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','B3:1000');
0 Commenti
Risposta accettata
Jeff Johnson
il 2 Apr 2014
Assuming the data you are interested in is always in column B:
[~,~,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
This code will leave you with a cell array with the raw data for all non-empty cells in column B. As written it will read all of the rows (65,536 of them!) in each file. If you know the maximum number of non-empty rows in all files (say 1500), you could speed this up by replacing 'B:B' with 'B1:B1500'.
This thread contains more information about deleting rows with NaN entires.
3 Commenti
Jeff Johnson
il 4 Apr 2014
Hi Yogesh,
What is the data variable you are referencing? Can you also include the error message returned when you try to plot these data?
Più risposte (0)
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!