MATLAB Answers

cswwrite not in one column

조회 수: 1(최근 30일)
TheDice
TheDice 2021년 8월 2일
편집: Rik 2021년 8월 2일
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

답변(1개)

Rik
Rik 2021년 8월 2일
편집: Rik 2021년 8월 2일
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