Writing into excel sheet from matlab

I would like to write a matrix (1xn ) generated during each iteration of for loop into an excel sheet. during the first iteration the matrix should be entered into row 1, second iteration should update row2 and so on... using writematrix function in matlab. Please help me with a solution.

[Dyuman Joshi]

Store the values in an array and use writematrix.

What seems to be the problem?

[RENJI]

Got it now...Thank you very much for your response.

Answer 1

[Binaya]

Hi

You can directly use "writematrix" or use convert the matrix into a table and use "writetable" functions to write into an excel sheet.

Regards

Binaya

Answer 2

[KSSV]

N = 10 ; 
iwant = zeros(N,1) ; 
for i = 1:N
    iwant(i) = i ; 
end
T = table(iwant) ; 
writetable(T,'Test.xlsx')

[Dyuman Joshi]

Why convert to a table when one can directly save the array via readmatrix?