xlswrite output numbered files

1 view (last 30 days)
Silver on 6 Sep 2018
Commented: Silver on 6 Sep 2018
I have 20 csv files named differet names, I want to make a program to rename them so they will be numbered this way :
  • M_1_1
  • M_1_2
  • M_1_3
  • And so on ...
When I use this code :
filename_M_1 = strcat('M_1_%g.xlsx'); % g is the number of files in the directory, I put on the top of the program for g=3:length(Folders) to run the list of files in the directory
xlswrite(filename_M_1,D,1,'A1') %D is the matrix
I have a result like this :
Any ideas ? thanks for help

Accepted Answer

Geoff Hayes
Geoff Hayes on 6 Sep 2018
Silver - try using sprintf to create your file name
for k = 1:20
filename = sprintf('M_1_%d.xlsx', k);
% create new file
% your code here
  1 Comment
Silver on 6 Sep 2018
It works ! Thank you so much !!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!