Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: putting together
Date: Fri, 1 Aug 2008 19:09:02 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 41
Message-ID: <g6vn0e$qb1$1@fred.mathworks.com>
References: <g6vjne$68m$1@fred.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-02-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1217617742 26977 172.30.248.37 (1 Aug 2008 19:09:02 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Fri, 1 Aug 2008 19:09:02 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 869596
Xref: news.mathworks.com comp.soft-sys.matlab:483186



"Anna Chen" <icedredtea@yahoo.com> wrote in message 
<g6vjne$68m$1@fred.mathworks.com>...
> hello,
> i have a file that contains a data table, with data and 
the 
> header names.  when i use xlsread, the data part gets 
put 
> as "double," but the header names all get put 
into "cell" 
> format, and i can't figure out how to splice the two 
> together.  can anyone help?
> 
> i guess basically, if i have something like "dwe ewrwe 
ere" 
> that is in cell format, and i want to put it over " 1 3 
4" 
> which are numbers to get
> 
> dwe ewrwe ere
> 1    3     4
> 
> how would i do that?  
> 
> thanks!

Anna,

Does your data look like this?:

Symbol, Exchange, Date, Time, Bid
CMGI, ARCA, 20040901, 9:31:33, 1.99
GE, ISLAND, 20040901, 9:31:34, 34.63
QQQQ, AUTO, 20040901, 9:31:35, 35.13

That is, do you have a delimited headerline? Is the data a 
mix of numeric and text columns?

If so, you can take a look at autodataread.m in the File 
Exchange.

Scott