cswwrite not in one column

1 visualizzazione (ultimi 30 giorni)
TheDice
TheDice il 2 Ago 2021
Modificato: Rik il 2 Ago 2021
Hello I would like to export a matrix I created myself as a csv file. I would like to open this file later with Excel.
When I use csvwrite all entries are in one field. How do I get each value to have its own field?
a = [1 2 4]
csvwrite('abcd.csv',a)
This is what it looks like so far:
this is how it should look:
Best regards
Fabian

Risposte (1)

Rik
Rik il 2 Ago 2021
Modificato: Rik il 2 Ago 2021
This issue is an Excel issue, not a Matlab one.
You need to use the 'convert data to columns' option in Excel.
You might try to write a tab separated file instead, which is more often detected correctly by Excel.
a = [1 2 4];
writematrix(a,'abcd.csv','Delimiter','tab')
%technically you should use .tsv instead, but hardly anyone does that

Community Treasure Hunt

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

Start Hunting!

Translated by