Options to compile a Matlab application with Excel GUI
Show older comments
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:
- 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?
- 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?)
- 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 Excel Add-Ins 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!