清空筛选条件
清空筛选条件

save matrix in excel and keeping the configuration (. and ,)

2 次查看（过去 30 天）
Mohamed Abushaqra
Mohamed Abushaqra 2022-7-11
回答： Amanjeet Pani 2022-7-13
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 个评论
Emmanuel J Rodriguez
Emmanuel J Rodriguez 2022-7-11
Hi! I'd like to take a closer look and see if I may be of help. Can you share the code?
Stephen23
Stephen23 2022-7-11
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.

请先登录，再进行评论。

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

回答（1 个）

Amanjeet Pani
Amanjeet Pani 2022-7-13
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.

类别

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

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by