Skip to Main Content Skip to Search
Login
File Exchange
MATLAB Newsgroup
Link Exchange
  Blogs  
 Contest 
MathWorks.com

Thread Subject: Spaced headers with dlmwrite

Subject: Spaced headers with dlmwrite

From: Daphne W

Date: 11 Aug, 2007 15:07:26

Message: 1 of 3


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

Subject: Re: Spaced headers with dlmwrite

From: us

Date: 12 Aug, 2007 10:20:08

Message: 2 of 3

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

Subject: Re: Spaced headers with dlmwrite

From: Daphne

Date: 12 Aug, 2007 13:56:39

Message: 3 of 3


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

Tags for this Thread

Everyone's Tags:

Add a New Tag:

Separated by commas
Ex.: root locus, bode

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Tag Activity for This Thread
Tag Applied By Date/Time
code us 12 Aug, 2007 06:25:06
file io us 12 Aug, 2007 06:25:06
dlmwrite us 12 Aug, 2007 06:25:06
rssFeed for this Thread

envelope graphic E-mail this page to a colleague

Public Submission Policy
NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Disclaimer prior to use.
Related Topics