how can i write data into excel sheet in MATLAB ?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
VBBV
el 7 de Jul. de 2018
Comentada: VBBV
el 7 de Jul. de 2018
I have a GUI, from which I need to write data to an excel sheet. The data contains both text and numeric content, which is read from a sheet, but before I write to same sheet. it is edited, the data for a specific row/ column and then write whole data to the same sheet For example, I made changes to one or more cells in specific row /column keeping others unchanged ... then it needs to write the whole data after the changes to same sheet using pushbutton callback
2 comentarios
Walter Roberson
el 7 de Jul. de 2018
xlswrite() and writetable() both accept sheet numbers or names.
Respuesta aceptada
Image Analyst
el 7 de Jul. de 2018
"It does not update the data, means edited data in dataP array is not reflected" Well, did you write out dataP? No. You wrote out Raw only. So you did not write out anything that got changed, so of course nothing got changed. Write out dataP if you want a new dataP in the workbook file.
By the way, don't use All for a variable name - it's too close to a built-in function called all().
3 comentarios
Image Analyst
el 7 de Jul. de 2018
You can make up a cell array and write that out with one call to xlswrite.
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!