Path: news.mathworks.com!newsfeed-00.mathworks.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!g23g2000yqh.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 23:16:59 -0800 (PST)
Organization: http://groups.google.com
Lines: 39
Message-ID: <36c3a68d-10d9-4573-bf0c-6a60ef50eaa6@g23g2000yqh.googlegroups.com>
References: <hcqkgq$n9$1@fred.mathworks.com> <09f4f3a9-b4b9-47ea-b907-c00fb7e9d1fe@m3g2000pri.googlegroups.com> 
	<hcqvql$3fq$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 1257319019 22606 127.0.0.1 (4 Nov 2009 07:16:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 4 Nov 2009 07:16:59 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g23g2000yqh.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:582275


On Nov 4, 5:27 pm, "rohan patel" <rpatel...@live.com> wrote:
> TideMan <mul...@gmail.com> wrote in message <09f4f3a9-b4b9-47ea-b907-c00fb7e9d...@m3g2000pri.googlegroups.com>...
> > 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
>
> okay i done this but if i add another game application to the data sheet will it create rows and columns for that also?
> and
> i have another problem i want to find the total number of quantity sold in for each game so how would i for loop it to add to get results?

Yes, my method will expand as you add extra rows.
Please do not listen to posters who suggest that you use the eval
function.
It is an evil function that will lead to you to unhappiness.