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

1 view (last 30 days)
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

Accepted Answer

Greig
Greig on 11 Mar 2015
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"

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!