xlsread for many distinct columns that aren't side-by-side in the SS
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
Jan
2014-2-26
编辑:Jan
2014-2-26
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.
回答(4 个)
Jan
2014-2-26
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 个评论
Image Analyst
2014-2-27
Does your xlsread call specify a range? You might have to process your data in smaller chunks.
Image Analyst
2014-2-26
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().
Sean de Wolski
2014-2-27
Use an automation server to read in only the chunks you need:
3 个评论
Sean de Wolski
2014-2-27
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
2014-10-3
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 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!