How to write multiple input into one csv file
97 views (last 30 days)
Show older comments
Commented: Walter Roberson on 12 Mar 2020
Let say I have
I want to put this output value in matlab to a csv file in the order below.
I can use below, However, it will over-write the csv file.
>> csvwrite('1test.csv',b, 0,1)
>> csvwrite('1test.csv',c, 0,2)
>> csvwrite('1test.csv',d, 0,3)
Arvind Sathyanarayanan on 18 Feb 2019
Try using the dlmwrite command with '-append'. Syntax is as follows:
The other option is to store a,b,c,d in a array and then write that array to the csv file.
Mohammad Farhad Aryan on 12 Mar 2020
Use the following code:
a = 1;
b = 2;
c = 3;
d = 4;
Nums = [a, b, c, d];
Walter Roberson on 12 Mar 2020
The original poster wanted to be able to write incrementally, doing separate write operations each of which appended a column of data. writematrix() can only do that for "spreadsheet" (.xls, .xlsx) files and not for "text" files (such as .csv), and writematrix() needs to be told exactly where to write the data each time.
The only system of calls that comes close to providing an "append into next column" operation is directly using ActiveX to talk to Excel, in which case certain kinds of range selections automatically update to position themselves after data that is written. Otherwise your choices are the ones I described at https://www.mathworks.com/matlabcentral/answers/445664-how-to-write-multiple-input-into-one-csv-file#comment_672637
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!