how can i write data into excel sheet in MATLAB ?
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
Image Analyst
on 7 Jul 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 Comments
Image Analyst
on 7 Jul 2018
You can make up a cell array and write that out with one call to xlswrite.
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!