How can I use xlswrite in a for loop without overwriting?

I'm trying to generate 31 excel files with a for loop:

days=31;
for i = 1:1:days
  dataday = frequency(1,((i-1)*(size(frequency,2)/days)+1):(size(frequency,2)/days)*i);
  xlswrite('frequency.xlsx',dataday');
end

Why I can not obtain 31 Excel files? Thanks in Advance!

[Paolo]

You are writing to the same sheet of the same Excel file for every iteration of the loop. Do you wish to create 31 files, or do you want to have the data in 31 sheets of the same file? The documentation page will be of help: xlswrite.

[Marina Gil]

Hi Paolo, I wish to create 31 Excel files (one per day).

I already checked xlswrite page but it doesn't say anything aboy excels and loops.

[Paolo]

Do you require a particular format for the filename? Because you could simply change the fourth line to the following:

 xlswrite(strcat('frequency',num2str(i)),dataday');

The names of the files will be 'frequency1','frequency2', and so on...

[Marina Gil]

Paolo, you just saved my thesis from having 31 loops (well, in reality 365 since it is for a whole year problem simulation)!!!

I'm crying of happiness... thank you very much, really!

[Ameer Hamza]

@Paolo consider adding your comment as an answer and @Marina please accept it, as it will help in marking this question as solved.

[Paolo]

@Marina You are welcome, happy to help. I wrote an answer for the question. As @Ameer pointed out, selecting the answer as accepted will mark the question as solved and will help other users in the future.

Answer 1

[Paolo]

If you wish to create a new Excel file for every iteration of the loop, you can use:

 xlswrite(strcat('frequency',num2str(i)),dataday');

The term 'frequency' is concatenated with the iteration number.

The data for every iteration will be written to the first sheet of every file. The files will be saved in the current directory and will be named:

'frequency1.xls','frequency2.xls' ... 'frequency31.xls'

Answer 2

[Roozbeh Yousefnejad]

I believe you can add "i" to xlswrite('frequency.xlsx',dataday') like xlswrite('frequency.xlsx',dataday',i) to change the excel sheet everytime, so at the end you will end up with one excel file and in each sheet you have your data

[Paolo]

She specified she requires data in different files, not different sheets.

Answer 3

[Prinson Chandy]

Question: what we have to do when we need to crate notepad file instead of excel file

[Paolo]

Do you mean a text file? You can apply the same logic but obviously can't use xlswrite as you are not working with an Excel spreadsheet. What's the format of your data?

[Prinson Chandy]

for each iteration of for loop, i need to write matrix in .txt file