How to display results in a table and same time save results do excel file

Question

Learning 2023-5-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1964404-how-to-display-results-in-a-table-and-same-time-save-results-do-excel-file

评论： Walter Roberson 2023-5-18

Hi, I have a code to predicting new data on an already trained model. How do I declare a property in app designer for the path where I import data from and also how do I display the prediction from the model in a table and at the same time save that result to an excel file when I click a button? Any code or example documentation would be appreciated. Thank you.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2023-5-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1964404-how-to-display-results-in-a-table-and-same-time-save-results-do-excel-file#answer_1236034

how do I display the prediction from the model in a table and at the same time save that result to an excel file when I click a button

Start by creating a table object -- though using array2table or related functions can also be valuable.

When you have the table of data to display, set a uitable object's Data property to be the table to display.

And use writetable to write to excel file.

2 个评论
显示无隐藏无

Learning 2023-5-17

Thank you for your help. Also, I have a code generated from a trained ANN model using the ANN fitting tool in Matlab. I can pass new data through the code and get an output. I have a button called “Predict”. When I click this button I want the output of the code to be displayed in the table. Do I implement the code at the callback for the “Predict” button? Also do I set the output of the code as a property so I can use it in the callback for “Predict”?

Walter Roberson 2023-5-18

Yes, the Predict button will likely call predict() or classify(), and after the code gets the results from that, put it into a Table and set the uitable's Data property to the table.

You can store the output of predict() or classify() as a property if you need it for other purposes beyond just displaying.

请先登录，再进行评论。