MATLAB Answers

0

How do I add text to the top of a CSV file?

Asked by David Coathup on 9 Sep 2019
Latest activity Commented on by David Coathup on 11 Sep 2019
I need to export a table as a CSV file, but I also need to add some text across several rows above the main table. Idealy, my output data should look like this:
string
string
string
NaN NaN NaN NaN NaN
NaN NaN NaN NaN NaN
NaN NaN NaN NaN NaN
I can get the tabelised data to be saved as .csv file, but I can't find away to get the text I need to also be inserted into the rows above the main text aswell. How do I do this?

  0 Comments

Sign in to comment.

Products


Release

R2016a

1 Answer

Answer by Bob Nbob
on 9 Sep 2019
Edited by Bob Nbob
on 9 Sep 2019
 Accepted Answer

The best way I have found to do this is with a combination of fprintf and dlmwrite. While csvwrite is nice for writing out the data, it does not work well with writing text.
The basic form of what you are trying to do should look something like the following:
fo = fopen('fileout.csv');
fprintf(fo,'%c',string);
fclose(fo);
dlmwrite('fileout.csv',data,'-append');
There are some newer commands you can use in place of dlmwrite, and you can replace fprintf with sprintf or similar, but the basic concept is the same.

  1 Comment

Hi Bob,
I got it wo work using this script, thank you very much.

Sign in to comment.