How to update the Excel sheet with matlab.

My project is automated classroom attendance system using video based face recognition. After recognition of the detected faces, how can I mark the attendance of the same in the excel sheet.

[José-Luis]

xlswrite()

[Anshun Raghuwanshi]

xlswrite() will copy the fixed content.After writing the excel sheet i want to update one of its coloum according to the result of the program, like if the face of the student matches with the face in the database then write "present" in one of the coloum of our excel sheet which contains name and id of the students.

[Walter Roberson]

If you are using MS Windows and have Excel installed, then you can use row and column references when you write the data. For example,

xlswrite(file, CellOfNewData, 'F3:F5');

[Anshun Raghuwanshi]

thanx

Answer 1

[Rahul agarwal]

can also use "table"; and then writetable to write in xlsx