Run matlab function in excel

I have the following cells in an excell sheet:

Power Year

24200 2021

Power is an input number. Under Year, there is a hyperlink to the spreadsheet Data2021, containing a large amount of data for the year 2021.

Now I want to run this function:

function[start, finish, time]=FLEX2(Power,Year)

start, finish and time are all vectors of 9x1, which I would like to be shown on another sheet in the file.

How can I do this using Spreadsheet Link? I would like it to run without opening MATLAB, since my coworkers are not familiar with it.

Answer 1

[Amit Dhakite]

Hi Joel,

As per my understanding, you want to run MATLAB functions inside the excel sheet, without the use of opening MATLAB.

You can do that using Excel Add-ins Using MATLAB Compiler. By applying this add-in, you can create a MATLAB function and add it to the excel sheet as a package. Further this will enable you to use that function as a excel sheet formula.

To get started with the add-ins, kindly refer to the following links:

• https://www.mathworks.com/videos/getting-started-excel-add-ins-using-matlab-compiler-100089.html
• https://www.mathworks.com/discovery/matlab-excel.html

[Joel]

Hi

I have made a request for MATLAB Compiler with no response.

Since your staff, can you make a request for me?