Run matlab function in excel

25 次查看(过去 30 天)
Joel
Joel 2023-4-11
评论: Joel 2023-4-14
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.

回答(1 个)

Amit Dhakite
Amit Dhakite 2023-4-12
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:
  1 个评论
Joel
Joel 2023-4-14
Hi
I have made a request for MATLAB Compiler with no response.
Since your staff, can you make a request for me?

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Data Export to MATLAB 的更多信息

产品


版本

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by