How do I use sprintf for files numbered from 0 till 15?

Hi,

I try to use the function sprintf in order to import data in a certain folder. The workbooks are numbered as "Experiment_A_0", "Experiment_A_1", ..., "Experiment_A_15".

Unfortunately only the workbooks 1-15 are imported now, while I also need workbook 0.

My code now is:

for fileNum = 1:numFiles
    fileName = sprintf('Experiment_A_%1d.xls',fileNum);           %%Define file-name
    [A(:,fileNum),B(:,fileNum),C(:,fileNum),D(:,fileNum),E(:,fileNum),F(:,fileNum)] = importfile(fileName,sheet,range);
end

Thanks in advance!

Eveline

Answer 1

[Greig]

The first value of fileNum is 1, so the first file is "Experiment_A_1", and "Experiment_A_0" is never reached in the loop. Update the fileName line to ....

fileName = sprintf('Experiment_A_%1d.xls',fileNum-1);

This will start at "Experiment_A_0"

[Eveline]

Thanks a lot!!