Thread Subject: excel to matlab/GUI

Subject: excel to matlab/GUI

From: helena raz

Date: 27 Jul, 2007 21:26:19

Message: 1 of 3

Is there any way to start from an excel file to GUI.
I have already designed a GUI which has a select button to select/import the data.
However, I want the user to start from the excel sheet and from there get a GUI. is that possible to do?

Thanks,
heli

Subject: excel to matlab/GUI

From: ImageAnalyst

Date: 28 Jul, 2007 07:50:41

Message: 2 of 3

On Jul 27, 5:26 pm, "helena raz" <helena....@gmail.com> wrote:
> Is there any way to start from an excel file to GUI.
> I have already designed a GUI which has a select button to select/import the data.
> However, I want the user to start from the excel sheet and from there get a GUI. is that possible to do?
>
> Thanks,
> heli

To summarize, you want the user to begin by launching an Excel
workbook and then running an Excel macro to have it run your MATLAB
macro, which has a GUI. You'd have to look into the Excel macro
language to see if they can launch a program. I'm pretty sure it can
since it's macro language is in Visual Basic. But you might have to
compile your MATLAB GUI into a stand alone executable that Excel can
launch.
Regards,
ImageAnalyst

Subject: excel to matlab/GUI

From: Gautam Vallabha

Date: 29 Jul, 2007 16:46:32

Message: 3 of 3

"ImageAnalyst" <imageanalyst@mailinator.com> wrote in message
news:1185634241.857788.275650@z24g2000prh.googlegroups.com...
> On Jul 27, 5:26 pm, "helena raz" <helena....@gmail.com> wrote:
>> Is there any way to start from an excel file to GUI.
>> I have already designed a GUI which has a select button to select/import
>> the data.
>> However, I want the user to start from the excel sheet and from there get
>> a GUI. is that possible to do?
>
> To summarize, you want the user to begin by launching an Excel
> workbook and then running an Excel macro to have it run your MATLAB
> macro, which has a GUI. You'd have to look into the Excel macro
> language to see if they can launch a program. I'm pretty sure it can
> since it's macro language is in Visual Basic. But you might have to
> compile your MATLAB GUI into a stand alone executable that Excel can
> launch.

Another option is to use MATLAB as an COM/ActiveX server, and feed it
commands from Excel (for example, to initialize and open the GUI). See this
tech note for details:
http://www.mathworks.com/support/tech-notes/2000/2001.shtml

Gautam


Tags for this Thread

Everyone's Tags:

Add a New Tag:

Separated by commas
Ex.: root locus, bode

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.

Tag Activity for This Thread
Tag Applied By Date/Time
activex Yair Altman 30 Jul, 2007 01:19:21
gui Ned Gulley 28 Jul, 2007 01:18:16
excel Ned Gulley 28 Jul, 2007 01:18:16
rssFeed for this Thread

Public Submission Policy

NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Disclaimer prior to use.

Contact us at files@mathworks.com