Ideal Rankine Cycle Excel Add-In

Integrating MATLAB and Excel - passing structures as input and assigning output to multiple cells.

Description

This demo uses MATLAB Builder for Excel to create an Excel Add-In from a MATLAB function rankine.m. The spreadsheet uses the Add-In to compute the thermodynamic properties of an Ideal Rankine cycle.

Two points of interest to this demo are the use of the MATLAB struct as input and output of the rankine.m function and the distribution of the output values in the struct to multiple cells of the Excel spreadsheet. The use of a struct requires the data passed into and out of the Excel Add-In use the MWStruct object from the MWComUtil library. To distribute the members of the struct into multiple cells for the output, his Add-In is used like an Excel Array function.

Acknowledgements

The author wishes to acknowledge the following in the creation of this submission:
Ideal Rankine Cycle GUI

• Required Products: MATLAB Builder EX; MATLAB Compiler
• MATLAB release: MATLAB 7.9 (2009b)
• Other requirements: Microsoft Excel

[iurjhh uzterg]

 

[Tim]

eval string in lines 54/55 of of build_mcode.m needs quotes surrounding the 2 file paths if those paths have spaces