xlsread for many distinct columns that aren't side-by-side in the SS
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi,
I know this is probably simple, but I'm not finding what I need when searching here.
I want to use xlsread to import many distinct columns that are not side-by-side in the spreadsheet. How can I do that? What am I missing? :)
My normal use of xlsread would be like this if I need columns A-D:
[File,Path] = uigetfile(blah, blah, blah);
File = strcat(Path,File);
DataVariable = xlsread(File,1,A:A:D:D);
How would I change this if I wanted, say, columns A and columns D-F? I've tried many different things, but have suffered death by commas, semicolons, and error messages.
Any help is appreciated.
2 commentaires
Jan
le 26 Fév 2014
Modifié(e) : Jan
le 26 Fév 2014
Please, John, do not bump your question after a few hours without addibng new information. The voluntary helpers post answers whene ever they have them and find the time to help. Reading a question again is a waste of time then.
The posted code is not working. Did you forget the quotes around A:A:D:D? But even then this is not correct.
Réponses (4)
Jan
le 26 Fév 2014
Import the block at first:
[File,Path] = uigetfile(blah, blah, blah);
File = fullfile(Path,File); % Smarter than STRCAT
DataVariable = xlsread(File,1,'A1:F231');
Now remove the not needed data from the output DataVariable.
This is not nice, but it works reliably.
2 commentaires
Image Analyst
le 27 Fév 2014
Does your xlsread call specify a range? You might have to process your data in smaller chunks.
Image Analyst
le 26 Fév 2014
Have you tried readtable() - it's new in R2013b and reads the Excel workbook into a table which is a lot more convenient than that mess of cell arrays xlsread() spits out. I've kissed xlsread() goodbye. You will too after you use readtable().
4 commentaires
Sean de Wolski
le 27 Fév 2014
Use an automation server to read in only the chunks you need:
3 commentaires
Sean de Wolski
le 27 Fév 2014
If you contact our customer service department they can straighten that out.
Otherwise just search for "Excel Automation" in the MATLAB doc; it should be the first result.
Nick Haddad
le 3 Oct 2014
This issue is a known bug in MATLAB and has been addressed in the following bug report:
The bug report has a workaround which you can install for MATLAB R2013a through R2014b.
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!