function handle specify in matlabfcn function

llu
2021 11 14
1 个回答
更新时间：2021 11 22
4 次查看（30 天）

0 个投票

Hi,
Is it possible to specify the function handle in matlabfcn function when using the spreadsheet link in Excel? when i try to do an integration with the syntax"=@matlabfcn("quadgk","@(x) x.^2",M3,M4)" in Excel, it returnd an error, and said the first input argument must be function handle, is there anyone can help me how to specify the function handle in matlabfcn function? Many thanks.

请先登录，再回答此问题。

回答（1 个）

Jan
Jan 2021-11-14
编辑：Jan 2021-11-16

0 个投票

According to the documentation doc matlabfcn :
=matlabfcn("quadgk(@(x) x.^2)", M3, M4)

7 个评论
显示 5更早的评论 隐藏 5更早的评论

llu
llu 2021-11-16
Thanks for your help @Jan, but it still does not work, is it workable in your Excel?
Jan
Jan 2021-11-16
quadgk needs 3 input arguments: A function and the initial and final limit. It is not clear how you try to provide the function in the Excel call. So please post, what the inputs are, what you want to calculate and what "does not work" means.
llu
llu 2021-11-20
Hi Jan, I'd like to use matlab function from excel to calculate the numerical integration, below is the screenshot
Jan
Jan 2021-11-20
Matlab's quadgk command requires 3 inputs: The function handle and 2 limits. You call it with 1 input only.
llu
llu 2021-11-21
Syntax "matlabfcn("quadgk(@(x) x.^2，1,2)")" can work, but i want to pass the 2 limits from Excel as arguments.
Jan
Jan 2021-11-21
编辑：Jan 2021-11-21
I cannot test it by my own. What about:
matlabfcn("@(a,b) quadgk(@(x) x.^2，a, b)", L3, L4)
llu
llu 2021-11-22
Can't work. Currently, the only methodology that I find is using the user definded function, like below:
function y = ab(a,b)
f= @(x) x.^2;
y= quadgk(f,a,b);
end
then use the syntax " matlabfcn("ab",L3,L4)" in excel

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

提问:

llu
llu
2021-11-14

评论：

llu
llu
2021-11-22

Community Treasure Hunt

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

Start Hunting!

Translated by