How can I write both alphabets and numbers in .mat file on same cell?

I need to save the data in .mat file. But the data values has names such as a=0.3, b=9, alpha=-0.89. In the cell, both the name of the variable and the data value should be present. How can I do that? Also I tried to save the data in xls file but when I try to open, it says the file format and extension of the file don't match. The file could be corrupter or unsafe. How can I solve this problem also?

Answer 1

[Image Analyst]

You can list the variables you want to save as arguments in the save function

a=0.3
b=9;
alpha=-0.89
unUsedVariable = 345;
x = 40;
% Save a, b, and alpha ONLY in variables.mat
save('variables.mat', 'a', 'b', 'alpha');
% Save a, b, and alpha ONLY in variables.xlsx.  Save to a cell array first.
ca = {'a', a; 
	'b', b; 
	'alpha', alpha};
writecell(ca, 'variables.xlsx');
% Open in in Excel (if using Windows)
winopen('variables.xlsx')

Answer 2

[Voss]

If I understand the situtation, you have a mat file with some variables and you want to write those variables' names and values in the form "a=0.3", etc., to an xls file. If that's accurate, here's something that will work for scalar numeric variables, as given in the question. If you have other sizes/types, you'll need to do something more sophisticated

S = load('vars.mat')

S = struct with fields:
        a: 0.3000
    alpha: -0.8900
        b: 9

S_fields = fieldnames(S);
n_fields = numel(S_fields);

C = cell(n_fields,1);
for ii = 1:n_fields
    C{ii} = sprintf('%s=%g',S_fields{ii},S.(S_fields{ii}));
end
C

C = 3×1 cell array
    {'a=0.3'      }
    {'alpha=-0.89'}
    {'b=9'        }

writecell(C,'vars.xls')

[ANANTA BIJOY BHADRA]

I have the values on matlab wrokspace. But I need to have the values along with their names in the .mat file so that I can send it to anyone than they can undersatnd that which value indicates which one. For example, in .mat it should be like 'a=0.3' so one can undersatnd that 0.3 is the value of a.

[Voss]

OK. Just save the mat file like usual then:

% creating workspace variables
a = 0.3;
b = 9;
alpha = -0.89;

% save a mat file with all workspace variables:
save('vars.mat')

When the other person loads the mat file, they can see what the variables are:

S = load('vars.mat')

S = struct with fields:
         a: 0.3000
     alpha: -0.8900
         b: 9
    cmdout: '2b292f7c2184b62a1fdb1177ca9a1882↵'

(cmdout is an artifact from running here on Answers - it would not appear on your machine.)

[ANANTA BIJOY BHADRA]

Thank you for the answer. Also, what should be the format for excel file?

[Voss]

If you want the variable names and values to show up in the excel file like 'a=0.3', you can save the mat file first and then use the code in my answer.