MATLAB Central Newsreader - How do I add header information to a matric when using the writng to file?

How do I add header information to a matric when using the writng to file?

Jack — Fri, 19 Jun 2009 02:45:04 -0400

I have a 201 x 7 numerical matrix that I want to write to file. Format doesn't really matter provided I can open it in excel (csv is probablt best, but could be ASCII, text, dlm, etc). How do I add header information for each column to the matric when I write the file? Thanks.

Re: How do I add header information to a matric when using the writng

vedenev — Fri, 19 Jun 2009 08:32:11 -0400

Use xlswrtite function. Wrtie descritpions of colomns in first row.
Using cell arays will allow you to add stings and numbers. Example:
M={'col1','col2';10,12};
xlswrite('tmp_xls_file',M);

------------------------------------
Maxim Vedenev, Matlab Expert
vedenev@ngs.ru
http://simulations.narod.ru/

Re: How do I add header information to a matric when using the writng to file?

Yair Altman — Sat, 20 Jun 2009 19:27:01 -0400

"Jack " <use.text.after.underscore.only_jcannon@csu.edu.au> wrote in message <h1eu3g$i7q$1@fred.mathworks.com>...
> I have a 201 x 7 numerical matrix that I want to write to file. Format doesn't really matter provided I can open it in excel (csv is probablt best, but could be ASCII, text, dlm, etc). How do I add header information for each column to the matric when I write the file? Thanks.

If you write a CSV file, it will be fast, portable (non-windows) and simple:
fprintf(...,'field #1, field #2, ...');
fprintf(...,data)

You can also use dlmwrite for this

Yair Altman
http://UndocumentedMatlab.com

Re: How do I add header information to a matric when using the writng to file?

us — Sat, 20 Jun 2009 20:53:01 -0400

"Jack " <use.text.after.underscore.only_jcannon@csu.edu.au> wrote in message <h1eu3g$i7q$1@fred.mathworks.com>...
> I have a 201 x 7 numerical matrix that I want to write to file. Format doesn't really matter provided I can open it in excel (csv is probablt best, but could be ASCII, text, dlm, etc). How do I add header information for each column to the matric when I write the file? Thanks.

this FEX contribution might be helpful

http://www.mathworks.com/matlabcentral/fileexchange/23840

us