I have 12 columns in excel that I want to import using one command.
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Declan Simons
am 25 Aug. 2016
Beantwortet: Adam
am 25 Aug. 2016
I am trying to import Columns B,C,F,G,J,K,N,O,R,S,X,Y with the range required of row 10 to 360010 and was looking to see if i could do this via a for loop.
0 Kommentare
Akzeptierte Antwort
Adam
am 25 Aug. 2016
If it fits in memory you may be best loading in full range using e.g.
filename = 'someFile.xlsx';
xlRange = 'B10:Y360010';
res = xlsread( filename, xlRange );
since the help states that 'xlsread does not support non-contiguous ranges.' Then just delete those columns you don't want afterwards.
Otherwise as you say, it may be better to just load in only those columns you need using multiple xlsread instructions for any contiguous blocks you have.
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!