Options to compile a Matlab application with Excel GUI

3 views (last 30 days)
I am developing a Matlab application for myself and for others using a GUI on Excel (for ease of use but also because some data processing need to be done in Excel).
To simplify, here are all the parts making up my application:
  • Part 1: Excel GUI with run settings
  • Part 2: Matlab program creating data results and images
  • Part 3: Excel GUI with Matlab data & image results and aditionnal Excel data processing
Currently, when others need to use it, they give me the run settings ( Part 1 ), I run the Matlab program for them ( Part 2 ) and give them the data, images and my last Excel GUI ( Part3 ).
I am trying to improve the situation by combining the parts above. I see 2 options:
  • Option 1: Running Matlab from Excel (Spreadsheet Link EX Toolbox) therefore having Part1 & Part2 together=> would be more for me (I have Matlab, and I can see more info from running my Matlab code)
  • Option 2: Packaging it all: Part 1+2+3 in an executable (MATLAB Compiler Toolbox)=> would be for my end users (no Matlab needed)
Now my questions:
  1. Can I (Should I? Should I not?) do both options? or am I over complicating everything? and should not use Excel Link toolbox at all?
  2. Do I need Matlab Builder EX to achieve Option 2? (therefore creating an Add-in) or could I also achieve this with the toolboxes: Excel Link + Compiler? (No Add-in, but VBA code?)
  3. Using the compiler, will I still be able to run all my macros in Excel? or is that only for the "Spreadsheet Link EX" solution?
PS: I have already developped the Excel GUI quite extensively, so at this stage I need a solution including Excel (therefore a completely Matlab GUI solution is not envisaged for now)
Cheers!

Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!