MATLAB Central Newsreader - Spaced headers with dlmwrite

Re: Spaced headers with dlmwrite

Daphne — Sun, 12 Aug 2007 13:56:39 -0400

Works great. Thanks !
Now I have to re-figure my alignments...

Daphne

"us " <us@neurol.unizh.ch> wrote in message
<f9mmso$75h$1@fred.mathworks.com>...
> Daphne:
> <SNIP <dlmwrite> conundrum...
>
> one of the solutions
>
> % the data
> fnam='foo.txt'; % <- your data file
> hdr={'a','bb','ccc'};
> m=magic(3);
> % the engine
> txt=sprintf('%s\t',hdr{:});
> txt(end)='';
> dlmwrite(fnam,txt,'');
> dlmwrite(fnam,m,'-append','delimiter','\t');
> % the result
> type(fnam)
>
> us

Re: Spaced headers with dlmwrite

us — Sun, 12 Aug 2007 10:20:08 -0400

Daphne:
<SNIP <dlmwrite> conundrum...

one of the solutions

% the data
     fnam='foo.txt'; % <- your data file
     hdr={'a','bb','ccc'};
     m=magic(3);
% the engine
     txt=sprintf('%s\t',hdr{:});
     txt(end)='';
     dlmwrite(fnam,txt,'');
     dlmwrite(fnam,m,'-append','delimiter','\t');
% the result
     type(fnam)

us

Spaced headers with dlmwrite

Daphne W — Sat, 11 Aug 2007 15:07:26 -0400

I am using dlmwrite to create a txt file that is exported
into excel. The txt includes text headers and number
matrices.
So far I have been creating a single text header that
includes all the titles that a line in excel will have,
and spacing the titles manually....
Is there a way to get each title tabbed from the one
preceeding it?
If I use the '\t' option each letter in the title gets a
tab and gets put into a different cell in excel.

Thanks,
Daphne