I want to edit values of a cell in excel based on certain condition. Can any body pls help me..??

Question

sapna prajapati 2015-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/184547-i-want-to-edit-values-of-a-cell-in-excel-based-on-certain-condition-can-any-body-pls-help-me

评论： sapna prajapati 2015-4-20

there is certain condition based on which i need to edit the data base. I need to call excel database iteratively row by row and edit certain cell value of it.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Christiaan 2015-3-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/184547-i-want-to-edit-values-of-a-cell-in-excel-based-on-certain-condition-can-any-body-pls-help-me#answer_172416

Dear Sapna,

Please have a look at the Documentation of the MATLAB function xlsread here. At this link you can find a method how to read the value of a certain cell. You could use an if statement to correct this cell if necessary. The change can stored in the excel file with the MATLAB function xlswrite. If the name of the file which you save is equal to the name you have read from, you can 'correct' your excel sheet with your if statement in MATLAB.

Good luck! Christiaan