Thread Subject: run code on multiple xls files

Hi,

I currently developed a code that takes in only 1 .xls file and runs an analysis. I was wondering if there is a simple way to change the code to take each .xls file in the current dir at a time, run the current code, and save the outputs for each analysis of the respective .xls file.

Thanks !

On 4 Okt, 15:27, "A Ram" <shal....@gmail.com> wrote:
> Hi,
>
> I currently developed a code that takes in only 1 .xls file and runs an analysis. I was wondering if there is a simple way to change the code to take each .xls file in the current dir at a time, run the current code, and save the outputs for each analysis of the respective .xls file.

Yes:

1) Refactor the present code such that it takes two arguments,
   the names of the input file and the output file
2) Write a loop that calls the '1-file code' and calls it
   with each of the input/output pairs of file names.

Rune

>
> 1) Refactor the present code such that it takes two arguments,
>    the names of the input file and the output file
> 2) Write a loop that calls the '1-file code' and calls it
>    with each of the input/output pairs of file names.
>
> Rune

The "dir" command would be useful in finding all of the .xls files in
the current directory.

Section 4.12 of the FAQ may be useful here:
http://matlabwiki.mathworks.com/MATLAB_FAQ#How_can_I_process_a_sequence_of_files.3F

Alternate versions of xlswrite will speed things up:
http://www.mathworks.com/matlabcentral/fileexchange/?term=xlswrite1