How to convert xls file to mat file in appdesigner?

1 view (last 30 days)
Hello, I am new in Matlab, I want to run nntool regression prediction in appdesigner, when i read excel files, it can't run the program. it shoes errors, so i am guessing because the xls files neeed to be converted into mat file maybe.
Below shown are the codes.
X = readtable('Fypinputdata.xlsx','Sheet',2);
app.UITable3.Data = X;
T = readtable('FypTargetdata.xlsx','Sheet',2);
app.UITable3_2.Data = T;
[net,tr] = train(net,X,T);
nntraintool
nntraintool('close')
plotperform(tr)
testX = X(:,tr.testInd);
testT = T(:,tr.testInd);
testY = net(testX);
perf = mse(net,testT,testY)
Y = net(X);
plotregression(T,Y)
e = T - Y;
ploterrhist(e)
Thanking you in advance
  1 Comment
dpb
dpb on 16 Nov 2021
Read the documentation more carefully and look at the examples -- I don't have the toolbox, but
shows you need to have defined the NN net object first, then the input variables are arrays or vectors; you've passed table objects, not the data in the tables.

Sign in to comment.

Answers (0)

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!