file extraction...error.

2 views (last 30 days)
karan
karan on 15 Dec 2011
hi i am running this code and getting this error for some reason.can anybody help why???
d = dir('*.xls'); N_File = numel(d); % no of files present in the folder for same class
for num = 1:N_File
k = fullfile(d(num).name);
[~,~,dat] = xlsread(d(num).name);
C = [C;num2cell(num*ones(size(dat,1),1)),dat];
end
??? [~,~,dat] = xlsread(d(num).name); | Error: Expression or statement is incorrect--possibly unbalanced (, {, or [.
  1 Comment
Walter Roberson
Walter Roberson on 15 Dec 2011
http://www.mathworks.com/matlabcentral/answers/13205-tutorial-how-to-format-your-question-with-markup

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 15 Dec 2011
Your version of MATLAB is probably too old to support using ~ in assignments.
Change
[~,~,dat] = xlsread(d(num).name);
to
[unneeded1,unneeded2,dat] = xlsread(d(num).name);
  1 Comment
karan
karan on 15 Dec 2011
Yes does not work on matlab 2009a but works on matlab 2010a.
Thank you.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!