How can i save multiple sets on data from MATLAB App Designer to excel?

12 次查看（过去 30 天）

Grace Frost 2020-5-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524400-how-can-i-save-multiple-sets-on-data-from-matlab-app-designer-to-excel

回答： saleh said bouhliga 2020-10-10

So i have created a call back function for my 'save data' edit text box. So when the user presses the 'save data' button the data from the simulation is saved to an excel file and this is my code below. However if i run multiple simulations and press 'save data' the data is saved on top of the original values and so it only saves one set of data each time.

I wanted to know how to save multiple data sets one after another, underneath one another, every time the user presses 'save data'.

Thanks in advance, Grace

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

请先登录，再进行评论。

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

采纳的回答

Ameer Hamza 2020-5-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524400-how-can-i-save-multiple-sets-on-data-from-matlab-app-designer-to-excel#answer_431562

编辑：Ameer Hamza 2020-5-10

在 MATLAB Online 中打开

See the 'Range' option of writetable(): https://www.mathworks.com/help/releases/R2020a/matlab/ref/writetable.html#d120e1378251. You can create a property in the app to store the current row. Increment it after each callback and use it to specify the row in excel file.

For example, if the row number is 5, then you can use something like this

writetable(t, 'filename', 'Range', ['A', num2str(5)])

12 个评论
显示 10更早的评论隐藏 10更早的评论

Grace Frost 2020-5-10

Hi Ameer, sorry to bother again,

but when i save my data it does save but its saves on row 20 or 21 or 22 or 23 for some reason and not at the top of the excel spreadsheet. This is the code i have, dont think it chnaged any of it. Do you know why?