Adding column headers when saving/exporting as an Excel file
in [Matlab]
|
From: Thomas on 26 Feb 2010 05:31 Cokelid <cokelid(a)googlemail.com> wrote in message <41c30474-2304-457a-8e63-dcad79b4fe0f(a)j6g2000vbd.googlegroups.com>... > On Feb 24, 5:38 am, "Thomas " <tpickha...(a)yahoo.co.uk> wrote: > > "Warning: Could not start Excel server for export. > > > > "Warning: Could not start Excel server for export. > > > > I think this may be caused because I'm using the Mac version of Matlab, and the COM server functionality is only available on Windows. Is there any alternative way to add headers to some kind of delimited file (be it tab or comma) that Excel can then read and import? > > I don't have a Mac, but sounds like that could be an issue. > > Given this, I would suggest a creating a csv file using fprintf() to > write your text and numerics to a file opened with fopen() (and > finally closed with fclose()). You'll have to understand C-style > formatting codes for fprintf(), but it's worth the effort in the long > run. > > This won't be a one or two liner like with xlswrite(), but will give > you full control over your text output. > > HTH, > > Justin Hi Justin, Thanks for the reply. Using this method, do I have to write each individual row of my "data" array (lets say its a 20x20 array) in turn using fprintf (using a for loop I imagiine), or can it do the whole array in one go? Thanks for the help.
From: Thomas on 26 Feb 2010 06:10
Thanks for all the help, I have managed to get it working now! Cheers, Thomas |