Run matlab function in excel

19 次查看（过去 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 Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by