Path: news.mathworks.com!not-for-mail
From: "Sadik " <sadik.hava@gmail.com>
Newsgroups: comp.soft-sys.matlab
Subject: Reading in XLS data containing numbers&strings
Date: Wed, 18 May 2011 15:37:03 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 9
Message-ID: <ir0p2v$qbi$1@newscl01ah.mathworks.com>
References: <ir0o34$mc8$1@newscl01ah.mathworks.com>
Reply-To: "Sadik " <sadik.hava@gmail.com>
NNTP-Posting-Host: www-06-blr.mathworks.com
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: newscl01ah.mathworks.com 1305733023 26994 172.30.248.38 (18 May 2011 15:37:03 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Wed, 18 May 2011 15:37:03 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1666517
Xref: news.mathworks.com comp.soft-sys.matlab:727486

Hi Catalin,

You should use all three outputs so that you can keep track of the NaN'ified strings.

[numeric,txt,raw] = xlsread('file.xls');

raw keeps everything you want: numeric and text.

Best.