How to deploy function from MATLAB to Microsoft excel?

function ypred = mypredict(tbl)

%#function fitrtree

load('matlab.mat');

load('Trainingdata.mat')

ypred = trainedModel.predictFcn(Trainingdata);

end

This is made after trained the data from regression learner

How to deploy this function in form of web app and in excel to get new output by giving new inputs ?

Answer 1

[Bhomik Kankaria]

Hi Manoj,

You can create Excel Add-In from MATLAB for your function to use in Excel. Refer below link to know more about the steps required to do the same-

https://www.mathworks.com/help/compiler/excel/create-an-excel-application-from-matlab-code.html

[Manoj kumar Beriya]

yes, I am using same thing but during compiling , it says that supported complier is not found. But, compiler is in the system? why are happening it?

[Bhomik Kankaria]

When compiling Excel add-ins or COM components from MATLAB using MinGW, you will also need to install Windows SDK 10.

See the following link on installing Windows SDK 10 with MinGW:

https://www.mathworks.com/matlabcentral/answers/355476-how-can-i-install-mingw-compiler-for-use-with-windows-10-sdk-kit

You can take a look at the software requirements for using the MATLAB Compiler with other MATLAB releases in the following link:

https://www.mathworks.com/support/sysreq/previous_releases.html

[Manoj kumar Beriya]

Thanks

It is working