How do I use sprintf for files numbered from 0 till 15?
2 visualizzazioni (ultimi 30 giorni)
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);
Thanks in advance!
Greig il 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"