How to save for loop data to same excel file of variable?
7 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Swapnil Rane
el 1 de Abr. de 2018
Comentada: Walter Roberson
el 18 de Nov. de 2022
In my code for every for loop a output variable is calculated. So, I want to save the data of each loop in same sheet after the last line in excel. Is there any way to do so?
0 comentarios
Respuesta aceptada
Walter Roberson
el 1 de Abr. de 2018
If you are using MS Windows with Excel installed then see https://www.mathworks.com/matlabcentral/fileexchange/28600-xlsappend
However, I would recommend that you consider saving all of the results in an array and appending only once all of the values are known, as the communication with Excel is comparatively expensive.
3 comentarios
Parthiban Arumugam
el 18 de Nov. de 2022
could you please explain how to call this function (above link) ?
can you put some example code here, if possible ?
Walter Roberson
el 18 de Nov. de 2022
In current releases I would use writetable or writematrix or writecell, with the option WriteMode 'append'
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!