file extraction...error.

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 [.

[Walter Roberson]

http://www.mathworks.com/matlabcentral/answers/13205-tutorial-how-to-format-your-question-with-markup

Answer 1

[Walter Roberson]

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);

[karan]

Yes does not work on matlab 2009a but works on matlab 2010a.

Thank you.