How to convert xls file to mat file in appdesigner?
2 views (last 30 days)
Show older comments
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
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.
Answers (0)
See Also
Categories
Find more on Monte Carlo Analysis in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!