How to convert this .mat file to .xls or.dat file?

here is my dataset of a 3X2 array

Answer 1

[Stephen23]

Your .mat file contains a 3x2 cell array, each cell of which contains a 1x9 numeric array: this data cannot be saved in a 2D array file format such as a text file or an Excel file. To save in a 2D array file format (i.e. a text file or Excel file) you will need to have a cell array containing scalar values, or use a numeric array, or use some format that encodes nested data (this is not trivial). Here I used cell2mat to form one 3x18 numeric array, which can easily be saved in a text file or an Excel file:

>> S = load('20-8-2018.mat');
>> M = cell2mat(S.feature_vec);
>> csvwrite('output.dat',M) % to make a text file
>> xlswrite('output.xls',M) % to make an Excel file

[Bajdar Nour]

Dear @Stephen Cobeldick. thanks, And how write if I have 3x1 cell array, each cell of which contains a 1x9 numeric array and arrange as I have indicated above

[Stephen23]

This converts the cell array of numeric vectors to a 6x9 numeric matrix:

M = vertcat(S.feature_vec{:});

[Bajdar Nour]

Thanks I got it

Answer 2

[KALYAN ACHARJYA]

%Rename the mat file to some simple name say file1.mat (Not Mandatory)
mat_file=load('file1.mat');
f=fieldnames(mat_file);
for i=1:size(f,1)
   xlswrite('mat_2_excel.xlsx',mat_file.(f{i}),f{i})
end

Such questions answer is already available in forum here

[Bajdar Nour]

Thank u @ KALYAN ACHARJYA for reply and help..but the file gives me

    Error using xlswrite (line 165)
Input data must be a numeric, cell, or logical array.
Error in converts (line 5)
   xlswrite('mat_2_excel.xlsx',mat_file.(f{i}),f{i})

[Stephen23]

@Bajdar Nour: that error message is a bit misleading. The xlswrite documentation states that each cell of the cell array must contain a scalar numeric, or text. However each cell of your cell array contains a 1x9 numeric. See my answer for one solution to this.