Problem writing in data into a csv using fprintf

I have a csv file I have written using csvwrite which already contains 3 lines of strings:

fid=fopen('test.csv','wt');
fprintf(fid,'abs 3.1 \n');
fprintf(fid,'This is a line \n');
fprintf(fid,'ID Date lat lon val \n');

Now I am trying to fill in data under each column with data in m which is a 10 by 4 marix. Column 1 are ids (5 digits), col.2 are dates (I want is to be in yyyymmddhhmm format but currently is in scientific notation in the table), cols. 3 and 4 are coordinates (e.g. 43.45 & -114.53), and col.5 are some values (e.g. 1.2345).

I have a hard time writing data in the csv. I am currently trying the following piece of code, but data fills in not the way it should be. Data are not stored under each header correctly.

for r=1:size(m,1)
     fprintf(fid,'%5.1f',m(r,:));
     if r~=size(m,1)
         fprintf(fid,'\n');
     end
 end

Any thoughts is greatly appreciated.

Kian

[Walter Roberson]

Isn't this resolved by http://uk.mathworks.com/matlabcentral/answers/233130-how-to-avoid-dates-being-writen-in-scientific-notation ?

Answer 1

[Muthu Annamalai]

Have you tried csvwrite or dlmwrite ?

doc csvwrite
doc dlmwrite

[Kian]

Thank you for the hints.

I tried:

dlmwrite('test.csv', m, '-append', 'delimiter', '\t');

It writes data into table now in order. But cause the headers to all go into the first top left cell.

[Walter Roberson]

dlmwrite('test.csv', m, '-append', 'delimiter', '\t', 'precision', '%g');

[Kian]

Thank you, but didn't work.