save matrix in excel and keeping the configuration (. and ,)
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Emmanuel J Rodriguez
il 11 Lug 2022
Hi! I'd like to take a closer look and see if I may be of help. Can you share the code?
Stephen23
il 11 Lug 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.
Risposte (1)
Amanjeet Pani
il 13 Lug 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 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!