Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
Excel to GUI

Subject: Excel to GUI

From: Tony GREENFIELD

Date: 23 Oct, 2009 14:30:22

Message: 1 of 2

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?

Subject: Excel to GUI

From: Dave Brackett

Date: 23 Oct, 2009 16:07:01

Message: 2 of 2

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

Tags for this Thread

No tags are associated with this thread.

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us