Transferring data (many decimals) from Matlab to excel

2 views (last 30 days)
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 Comment
Stephen23
Stephen23 on 24 May 2024
"Does anyone have an idea on how to fix this problem?"
Do not copy-and-paste table/numeric data. Export using WRITETABLE.

Sign in to comment.

Answers (1)

Harald
Harald on 24 May 2024
Edited: Harald on 24 May 2024
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

Tags

Products


Release

R2024a

Community Treasure Hunt

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

Start Hunting!