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

4 visualizaciones (últimos 30 días)
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

Respuesta aceptada

Ameer Hamza
Ameer Hamza el 10 de Mayo de 2020
Editada: Ameer Hamza el 10 de Mayo de 2020
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 comentarios
Grace Frost
Grace Frost el 10 de Mayo de 2020
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?
Ameer Hamza
Ameer Hamza el 10 de Mayo de 2020
You have written
.... 'range', ['A2' num2str(.....
replace 'A2' with just 'A'.

Iniciar sesión para comentar.

Más respuestas (1)

saleh said bouhliga
saleh said bouhliga el 10 de Oct. de 2020
For example
filename = book1
sheet = sheet1
table name = app.t
writetable(app.t,"Book1.xlsx","Sheet",1);

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by