MATLAB Central Newsreader - run code on multiple xls files

run code on multiple xls files

A Ram — Sun, 04 Oct 2009 13:27:01 -0400

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 !

Re: run code on multiple xls files

Rune Allnor — Sun, 04 Oct 2009 13:37:12 -0400

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

Re: run code on multiple xls files

Brian Borchers — Sun, 04 Oct 2009 13:41:48 -0400

>
> 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.

Re: run code on multiple xls files

ImageAnalyst — Sun, 04 Oct 2009 14:22:03 -0400

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