How to use writetable command in a for loop

while using writetable command in a for loop i'm able to save the text file only for the last iteration value. Hoe can i save all the text files using this writetable command?

[Walter Roberson]

http://www.mathworks.co.uk/matlabcentral/answers/43073-a-guide-to-tags

Answer 1

[Taha]

for m=1:10
test = [m:m+20];
T=table(test);
writetable(T,['test' num2str(m) '.txt'],'Delimiter','\t');
end

here is the solution! this code generates text files with the names: test1.txt, test2.txt.... using the for loop in MATLAB

[Ellen Berry]

Do you know how to adjust this to export as an excel file? I'm getting an error saying the delimiter is an invalid parameter

[Dyuman Joshi]

@Ellen Berry Go through the documentation of writematrix to understand the proper syntax.

If your error still persists, ask a new question specifying the problem/error you are facing.

[Voss]

@Ellen Berry: For writing an Excel file (e.g., .xlsx), omit the 'Delimiter','\t' arguments. Delimiter is for text files only.

for m=1:10
    test = [m:m+20];
    T=table(test);
    writetable(T,['test' num2str(m) '.xlsx']);
end

Answer 2

[Walter Roberson]

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