how can i write data into excel sheet in MATLAB ?

Question

VBBV 2018-7-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/409210-how-can-i-write-data-into-excel-sheet-in-matlab

评论： VBBV 2018-7-7

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 个评论
显示无隐藏无

Walter Roberson 2018-7-7

xlswrite() and writetable() both accept sheet numbers or names.

VBBV 2018-7-7

编辑：Image Analyst 2018-7-7

 I use xlsread() function to read data from file as shown below 
[dataP dataN Raw] = xlsread(LL,All{1});

Then I make changes to dataP which is numeric array, and later when I write to excel sheet using following code

xlswrite(LL,Raw(3:end,:),All{1},'A3:BE42');

It does not update the data, means edited data in dataP array is not reflected ... though it writes both numeric and text arrays to location specified. why ?

请先登录，再进行评论。

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

Answer 1

Image Analyst 2018-7-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/409210-how-can-i-write-data-into-excel-sheet-in-matlab#answer_327851

"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().