Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: Excel to GUI
Date: Fri, 23 Oct 2009 16:07:01 +0000 (UTC)
Organization: Loughborough University
Lines: 12
Message-ID: <hbskb5$75a$1@fred.mathworks.com>
References: <hbselu$ag$1@fred.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-03-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1256314021 7338 172.30.248.38 (23 Oct 2009 16:07:01 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Fri, 23 Oct 2009 16:07:01 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1338633
Xref: news.mathworks.com comp.soft-sys.matlab:579637


"Tony GREENFIELD" <tony@greenfieldresearch.co.uk> wrote in message <hbselu$ag$1@fred.mathworks.com>...
> I want to read an Excel spreadsheet, chosen from explorer that I access from the GUI, into a table in a GUI.
> 
> I want the column heads to appear in the table.
> 
> I want to select data from the table: one or more columns and a set of rows.
> 
> Then, after analysis and plotting,  I want to output the results to an external document such as a word doc where I shall write my interpretation before printing.
> 
> Any help?

use uigetfile to get the path and filename of the spreadsheet. then use xlsread to read it in to matlab. then manipulate the data as required and display in a uitable in a GUI.