How to convert a .mat file into a .csv file?
1.740 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
hello_world
el 30 de Mzo. de 2015
Editada: Image Analyst
el 25 de Jul. de 2024
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 comentarios
Image Analyst
el 1 de Mzo. de 2023
@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.
Respuesta aceptada
Jan
el 30 de Mzo. de 2015
FileData = load('FileName.mat');
csvwrite('FileName.csv', FileData.M);
17 comentarios
Stephen23
el 25 de Jul. de 2024
mydata = load('wind.mat');
csvwrite('mydata.csv', mydata);
% not in general it doesn't ;)
Image Analyst
el 25 de Jul. de 2024
Editada: Image Analyst
el 25 de Jul. de 2024
@Parisa, your mydata is a structure so you'd have to extract the matrix from the structure first since csvwrite does not take structures as inputs. Something like
% Read variables into fields of a structure.
storedStructure = load('FileName.mat');
% Extract matrix called Data from the structure:
myMatrix = storedStructure.Data; % Change names to whatever you actually have.
% Write the extracted matrix out to a CSV file.
fullFileName = fullfile(pwd, 'MyData.csv'); % Get full path and name.
csvwrite(fullFileName, myMatrix); % Write matrix out to disk.
Más respuestas (3)
Ashlesh Sortee
el 4 de Jul. de 2017
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
2 comentarios
Image Analyst
el 22 de Jun. de 2024
@Ayman once you have the variable in MATLAB, then you can use writematrix to write it to a disk file, then use File/Open in Excel to read it into Excel.
Ashlesh Sortee
el 4 de Jul. de 2017
Editada: Ashlesh Sortee
el 4 de Jul. de 2017
FileData = load('FileName.mat'); csvwrite('FileName.csv', FileData.FileName);
- | | * This one worked for me||*
- Thanks Jan Simon
Image Analyst
el 30 de Mzo. de 2015
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 comentarios
Jan
el 30 de Mzo. de 2015
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
el 30 de Mzo. de 2015
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.
Ver también
Categorías
Más información sobre Text Files en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!