How to convert a .mat file into a .csv file?

2,139 次查看（过去 30 天）
hello_world
hello_world 2015-3-30
评论： Rik 2023-4-25
Hello Friends,
I have a .mat file loaded in workspace. I want to convert it into .csv file. It has real entries. I used to convert it before using the following commands without any problem:
M = dlmread('FileName.mat', '\t', 1, 0);
csvwrite('FileName.csv', M)
But now something is wrong with MATLAB. My dataset is the same. Nothing has changed, but now it gives the following error:
Error using dlmread (line 139)
Mismatch between file and format string.
Trouble reading number from file (row 1u, field 1u) ==>
}Ûa&Ír!ÃþxbSoÈñæo8k:¬i’³*Y#~!IjË9B¯ÝWG~
¬zN=å0ÉÀo8Ó'Rå@õR[iãY>,xÊ8UrVÀ9ó";~~ÀOWAe$Æ\:xfnFVAÿñϼÓЪÍðaþ\n
I wonder if MATLAB changed something with dlmwrite function! Please advise.
  4 个评论
显示 2更早的评论
Jose Ocampo
Jose Ocampo 2023-3-1
how I can said the link where will be created the file
Image Analyst
Image Analyst 2023-3-1
@Jose Ocampo I don't know what you mean. When you do
csvwrite('FileName.csv', M)
the file is created in the current directory -- what you see in the directory/address field in MATLAB.

请先登录，再进行评论。

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

采纳的回答

Jan
Jan 2015-3-30
FileData = load('FileName.mat');
csvwrite('FileName.csv', FileData.M);
  14 个评论
显示 12更早的评论
Rik
Rik 2023-4-25
@Yassine, if you want help, you will have to provide more details. We can't read your mind or your screen.

请先登录，再进行评论。

更多回答（3 个）

Ashlesh Sortee
Ashlesh Sortee 2017-7-4
simply you can copy and paste the matrix you want in excel
  • all you have to do is open .mat file in matlab , press 'ctr+A' & 'ctr+C' in the variable tab and paste it in new excel sheet
Ashlesh Sortee
Ashlesh Sortee 2017-7-4
编辑：Ashlesh Sortee 2017-7-4
FileData = load('FileName.mat'); csvwrite('FileName.csv', FileData.FileName);
  • | | * This one worked for me||*
  • Thanks Jan Simon
Image Analyst
Image Analyst 2015-3-30
You're trying to save the variable called FileName20.mat in dlmwrite(). If that's the variable, then you have a dot in the name which means that FileName20 must be a structure, and mat must be a field/member of the structure. It's clearly not - you don't have any structure variable in your program called FileName20. You probably need to pass in M instead of FileName20.
  2 个评论
Jan
Jan 2015-3-30
I do not believe that this has worked before. You cannot read a MAT file by dlmread. MAT files are imported by load.
Image Analyst
Image Analyst 2015-3-30
I totally agree with Jan. See Jan's answer, then "Accept" it. It loads your file into a structure called FileData. The "M" array that you stored in the mat file will be a "field" of FileData. Then he writes out only that field to your new csv file.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by