Transferring data (many decimals) from Matlab to excel

Question

Camilla 2024-5-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2122321-transferring-data-many-decimals-from-matlab-to-excel

评论： Stephen23 2024-5-24

Hello everybody, I have a question regarding transfer of data from matlab to an excel sheet.

I have many tables with a huge amount of data consisting of numbers with many decimals. I want to transfer those to excel. If I copy paste it, excel puts a . every 3 decimals instead of where the , should actually be.

Example: 1.510035138631854 gets converted to --> 151.003.513.863.185 in excel, where it should be 1,510035138631854

Does anyone have an idea on how to fix this problem? I am working on a Mac and with MatlabR2024a.

Thanks so much in advance :)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2024-5-24

"Does anyone have an idea on how to fix this problem?"

Do not copy-and-paste table/numeric data. Export using WRITETABLE.

请先登录，再进行评论。

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

Answer 1

Harald 2024-5-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2122321-transferring-data-many-decimals-from-matlab-to-excel#answer_1463041

编辑：Harald 2024-5-24

Hi Camilla,

instead of interactive copy-pasting, I would consider commands like writetable or writematrix. This may also help you to automate working with lots of tables and data.

Best wishes,

Harald