save matrix in excel and keeping the configuration (. and ,)
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hello,
I am trying to save a matrix from MATLAB as CSV (or excel) however I am facing the following problem..
The number 0.98 (matlab matrix) is saved as 0.98 (CSV table) -> correct
The number 1.05 (matlab matrix) is saved as 105 (CSV table) -> Wrong
The number 1.08679 (matlab matrix) is saved as 108.679 (CSV table) -> Wrong
I am atatching the two imagens from MATLAB and CSV.
2 comentarios
Emmanuel J Rodriguez
el 11 de Jul. de 2022
Hi! I'd like to take a closer look and see if I may be of help. Can you share the code?
Stephen23
el 11 de Jul. de 2022
By default MS Excel aligns text of the left and aligns numbers on the right... which tell us that (if you haven't changed the alignment) something is really messed up with how MS Excel interprets that data file.
However because you did not upload your data (both MAT file and CSV file) by clicking the paperclip button there is not much we can do.
Respuestas (1)
Amanjeet Pani
el 13 de Jul. de 2022
you can run this command using matlab
writematrix(<matrix_name>,'filename.xls')
Aditionally you can go through this documentation page of writematrix() of matlab for more details if any.
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets 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!