Could we add variable in folder directory ??

I want to access several sequenced folders

Example :

[ndata, text, alldata] = xlsread('D:\folder\1\file');
[ndata, text, alldata] = xlsread('D:\folder\2\file');
[ndata, text, alldata] = xlsread('D:\folder\3\file');
[ndata, text, alldata] = xlsread('D:\folder\4\file');

Could I replace 1,2,3and 4 by variable i .. How could the directory be written here ?!!

Answer 1

[Jason Ross]

Use something like this:

http://www.mathworks.com/help/techdoc/import_export/br5wz4t.html#br7q_u6

[Jan]

Or explicitely:

for k = 1:4; xlsread(['D:\folder\', sprintf('%d', k). '\file']); end