Putting the content of an array cell into an xlsread command.

I am trying to create a 'for loop' to cycle through all of the worksheets in an excel workbook. I created a column array with the exact names of all of the worksheets.

Here is my attempt to do this:

worksheets = {'Aaa'; 'Bbbbbbbbbb'; 'Ccccccc'...etc}

for i=1:10

    WSName = worksheets(i,1)
    Matrix = xlsread('C:\documents\workbook', sprintf('%s', WSName))

end

Can anyone tell me how to fix this to make it work? Is it possible?

Answer 1

[Oleg Komarov]

Two things, once you created a cellstring with the wks names, you don't need to recreate it inside the loop and always specify the file extension:

worksheets = {'Aaa'; 'Bbbbbbbbbb'; 'Ccccccc'};

for i=1:10
    Matrix = xlsread('C:\documents\workbook.xls',worksheets{i});
end

Oleg

[David Ball]

Thanks Oleg. You solved my problem.