I want to edit values of a cell in excel based on certain condition. Can any body pls help me..??
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
sapna prajapati
am 23 Mär. 2015
Kommentiert: sapna prajapati
am 20 Apr. 2015
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 Kommentare
Akzeptierte Antwort
Christiaan
am 23 Mär. 2015
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
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!