How to create and name several excel files in a loop?

Hi,

I need to save outputs of my code into excel files. As I need to do it for about 120 cases and may need to repeat it later, I was wondering how I can do this in a loop over the 120 cases saving the result for each case in a seperate excel file. I know that xlswrite creates file, but don't know how to automate it.

Any help is appreciated Jamal

Answer 1

[Thorsten]

Just create a new filename in each loop and write to this file:

filename = sprintf('data%03d.xls', i);

[Jamal]

Dear Thorsten,

Thank you very much for your swift reply. I am still struggling how to use the new filename in xlswrite('Path\filename',header4,sheet,xlRange); for example. how could be a variable thing in this command?

Cheers, Jamal

[Thorsten]

xlswrite(fullfile('your_path_here', filename), header4, sheet, xlRange),

[Jamal]

Dear Thorsten, Thank you very much for your help; both worked. I also need to save the 120 experiment in one file in different sheets; any idea how to name sheets based on the experiments name which are integer numbers but not ordinal. the name are those given to the files created as above. Hope this is my last question :)

Yours, Jamal

[Jamal]

Dear Thorsten,

I just tried sprintf and it worked for naming sheets in a file.

Many thanks, Jamal

Answer 2

[Image Analyst]

Jamal, did you see this in the FAQ:

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

[Jamal]

Image Analyst,

Thanks for the link. looks very useful.

Jamal