MATLAB: Avoid overwriting value of variable

overwriting variable

I am having following code:
Source_files = [specified directory]
len = length(Source_files);
for j = 1 : len
    [status,sheets] = xlsfinfo(Source_files)
    sheetIndex = find(strncmp(sheets, '#', 1));
end
sheetIndex variable's value gets overwritten on every iteration. I want to have a variable wanted_sheets constituting names of all the sheets starting with '#' from all the files.

Best Answer

Use indexing:
Source_files = [specified directory]
N = numel(Source_files);
C = cell(1,N);
for k = 1:N
    [status,sheets] = xlsfinfo(Source_files{k});
    C{k} = find(strncmp(sheets, '#', 1));
end
Related Question