cswwrite not in one column
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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
0 Kommentare
Antworten (1)
Rik
am 2 Aug. 2021
Bearbeitet: Rik
am 2 Aug. 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
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!