total marks and percentage in marksheet of excelfile

roll no names sub1 sub2 sub3 sub4 total marks percentage

1 abc 50 60 70 80

2 def 60 70 80 90

3 ghi 90 50 60 75

i have given this type of excel file how do i get the total marks and percentage of each student using matlab and write data in excel file

Answer 1

[KSSV]

T = readtable(myexcelfile) ;  
marks = table2array(T(:,3:6)) ;
total_marks = sum(marks)/400 ;  % four subjects each 100 marks 
percentage = total_marks*100 ;
T1 = table(total_marks,percentage) ;
T = [T T1]

[mudassir tariq]

i forgot to mention that i want to write it again in same excel sheet so how i can do this

[KSSV]

writetable(T,'text.xlsx')

[mudassir tariq]

i applied your method but this error occured in line 2 plz guide me boos

[KSSV]

This line:

marks = table2array(:,3:6) ;

should be:

marks = table2array(T(:,3:6)) ;

Type error in the answer. Edited the answer as well.

[mudassir tariq]

error occured in line 6

T = [T T1]

[KSSV]

Attach your excel file.