Cannot save a matrix into a csv file correctly

So I have a matrix with doubles inside like this

0.001　　9.86543...

0.002　　5.26811...

0.003　　4.91702...

and so on.

Using writematrix saves all column into a single column. Changing the delimiter option didn't change the result. It only changed how the numbers are separated, but they are still bunched up into a single column when I open the csv file.

How do I fix this?

[Ramtej]

Hi Hayao,

Can you share how your matrix looks like? "writematrix" should work fine in your case.

[Dyuman Joshi]

The code below works fine on my R2021a, see the attach csv file for reference.

Please share the matrix you have, with the call to writematrix() you are using to save the data in csv file.

y = reshape(magic(6), [], 2);
disp(y)

    35    26
     3    21
    31    22
     8    17
    30    12
     4    13
     1    19
    32    23
     9    27
    28    10
     5    14
    36    18
     6    24
     7    25
     2    20
    33    15
    34    16
    29    11

writematrix(y, 'File.csv')

Answer 1

[Chunru]

A = [0.001 9.86543
    0.002 5.26811
    0.003 4.9170]

A = 3×2

0.0010 9.8654 0.0020 5.2681 0.0030 4.9170

writematrix(A, "matrixA.txt");

type matrixA.txt

0.001,9.86543
0.002,5.26811
0.003,4.917