How to save obtained information from matlab in Excel

Hello.

I want to create some random matrices and compute some features like determinant, trace, etc., for them and then save them in a row for each matrix like this

I know how to create random matrices with rand(A) and how to compute their features by matlab but my question is that how can I save my obtained information in Excel.

I was wondering if someone could help me about my problem.

Thanks in advance.

Answer 1

[Benjamin Kraus]

See if this doc page helps: Write Data to Excel Spreadsheets

[Mojtaba Mohareri]

Thank you very much for the link. Sorry, there is the following error in the code

[Benjamin Kraus]

The writematrix command was introduced in R2019a. If you are using an older release, you can try xlswrite instead.

[Mojtaba Mohareri]

Thanks a lot. It works properly. Sorry, for the last question: I've cretaed 10 random matrics and computed 5 features of them within in a "For loop". So the "For loop" gives me 5 numbers every step. For example, I've written A=rand(5), B(1)=norm(A,'fro'), B(2)=norm(A,'inf'), B(3)=cond(A), B(4)=det(A) and B(5)=trace(A) within a For loop for n=10. But now, how can I save them in rows 1,2,3,4,5 in the Excel?

[Benjamin Kraus]

If I understand correctly, you want to write the 5 elements of B into the first 5 rows of a spreadsheet?

xlswrite('spreadsheet.xlsx', B')

Note that I transposed B into a column vector (using the single quote), so that when written to the spreadsheet each element was on a separate row.

[Mojtaba Mohareri]

Sorry, no. I mean I want to save obtained information from each loop in a new row like this (for matrices A1, A2, ..., A10)

[Walter Roberson]

Gather all of the information into one 2D array first, and write it all out afterwards.

The logic for "appending" to a .xls or .xlsx file is not worth the trouble.

(The logic for appending purely numeric rows to a .csv file is much easier than for .xls or .xlsx files.)

[Mojtaba Mohareri]

All right. Understood completely. Thank you so much for devoting your time to answering my questions and helping me to increase my knowledge on this matter.

[Mojtaba Mohareri]

Dear Mr. Kraus, I could write the following code thanks to you:

clear all;
clc;
N=20; % the number of matrices
m=5; % the dimension of matrices
filename = 'Langari.xlsx';
for n=2:N+1
bounds = [-2,4]; 
A = rand(m,m) * range(bounds) + bounds(1) % creating a matirx with entries in range of [-15,10]
B(n,2)=nnz(A)/numel(A);  %the sparsity rate
B(n,3)=nnz(tril(A))/numel(A); % the lower nozero rate
B(n,4)=nnz(diag(A))/numel(A); % the diagonal nozero rate
B(n,5)=nnz(triu(A))/numel(A); % the upper nozero rate
B(n,6)=norm(A,1); % the one norm 
B(n,7)=norm(A,'inf');% the infinity norm 
B(n,8)=norm(A,'fro'); % the Frobenius norm 
B(n,9)=min(sum(A,1));
B(n,10)=min(sum(A,2));
B(n,11)=mean(nonzeros(A));
B(n,12)=cond(A);
end
for t=2:11 
B(1,t)=t; 
end
xlswrite(filename,B)

The only thing remained to me is that I want to change some names of entries like this

How can I do that? I was wondering if you could help me about my problem.