![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1352834/image.png)
Run matlab function in excel
14 次查看(过去 30 天)
显示 更早的评论
I have the following cells in an excell sheet:
Power Year
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.
0 个评论
回答(1 个)
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.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1352834/image.png)
To get started with the add-ins, kindly refer to the following links:
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!