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

Question

Bajdar Nour 2018-8-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415923-how-to-convert-this-mat-file-to-xls-or-dat-file

评论： Bajdar Nour 2018-8-23

采纳的回答： Stephen23

20-8-2018.mat

here is my dataset of a 3X2 array

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2018-8-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415923-how-to-convert-this-mat-file-to-xls-or-dat-file#answer_333812

编辑：Stephen23 2018-8-23

在 MATLAB Online 中打开

20-8-2018.mat

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

3 个评论
显示 1更早的评论隐藏 1更早的评论

Stephen23 2018-8-23

编辑：Stephen23 2018-8-23

在 MATLAB Online 中打开

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

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

Bajdar Nour 2018-8-23

Thanks I got it

请先登录，再进行评论。

Answer 2

KALYAN ACHARJYA 2018-8-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415923-how-to-convert-this-mat-file-to-xls-or-dat-file#answer_333805

编辑：KALYAN ACHARJYA 2018-8-23

在 MATLAB Online 中打开

%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

2 个评论
显示无隐藏无

Bajdar Nour 2018-8-23

编辑：Bajdar Nour 2018-8-23

在 MATLAB Online 中打开

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 2018-8-23

编辑：Stephen23 2018-8-23

@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.

请先登录，再进行评论。