Excel to GUI

Tony GREENFIELD — Fri, 23 Oct 2009 14:30:22 -0400

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?

Re: Excel to GUI

Dave Brackett — Fri, 23 Oct 2009 16:07:01 -0400

"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.

MATLAB Central Newsreader - Excel to GUI

Excel to GUI

Re: Excel to GUI