Path: news.mathworks.com!newsfeed-00.mathworks.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!m3g2000pri.googlegroups.com!not-for-mail
From: TideMan <mulgor@gmail.com>
Newsgroups: comp.soft-sys.matlab
Subject: Re: how to make rows and columns from excel files? please help
Date: Tue, 3 Nov 2009 18:19:23 -0800 (PST)
Organization: http://groups.google.com
Lines: 24
Message-ID: <09f4f3a9-b4b9-47ea-b907-c00fb7e9d1fe@m3g2000pri.googlegroups.com>
References: <hcqkgq$n9$1@fred.mathworks.com>
NNTP-Posting-Host: 202.78.152.105
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1257301163 32712 127.0.0.1 (4 Nov 2009 02:19:23 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 4 Nov 2009 02:19:23 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: m3g2000pri.googlegroups.com; posting-host=202.78.152.105; 
	posting-account=qPexFwkAAABOl8VUndE6Jm-9Z5z_fSpR
User-Agent: G2/1.0
X-HTTP-Via: 1.1 bc7
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.4) 
	Gecko/20091016 Firefox/3.5.4,gzip(gfe),gzip(gfe)
Xref: news.mathworks.com comp.soft-sys.matlab:582223


On Nov 4, 2:14 pm, "rohan patel" <rpatel...@live.com> wrote:
> 'Game'         'January'    'February'    'March'    'April'    'May'      'June'
>  'iKitty'            75]         254           1235     1820      2114     1600
> 'ShootEmUp'   3584]     4588          9421     10588    12788    16889
>
> okay i have this. i know how to put in rows and columns for iKitty and ShootemUP.
>
> [numbers, text, everything] = xlsread(fileName);
>
> iKitty = numbers(1,:);
> shootEmUp = numbers(2,:);
>
> but i need to figure out how if there was more data add(such as new game) how can i use a for loop to put everything in row and columns?

One solution is to use a structure:
[ngames,nmonths]=size(numbers);
for igame=1:ngames
   Game.(text{igame+1,1})=numbers(igame,:);
end