excel表格中基于分数的评分系统

Question

我正在尝试根据标记将成绩粘贴到excel表中

我这样做了，但这只显示excel表中的F。。我想如果有人有标记>80然后想显示A级。。如果有人干草>70然后B

如果有人的体重低于70，那么就想展示F

更新代码

clc,clear all
filename = 'PROJECT..xlsx';
table = readtable(filename);
data = xlsread(filename);
[r,c] = size(data);
total_courses = c;
table.SumofMarks = zeros(r,1);
table.Percentage = zeros(r,1);
table.StudentGrade = repmat({''},r,1);

% Sum of marks in different courses and their percentage.
format bank
Sum_of_Marks = sum(data,2);
Student_Percentage = Sum_of_Marks./total_courses;
T = horzcat(Sum_of_Marks,Student_Percentage);


N = length(Student_Percentage);
table.SumofMarks = Sum_of_Marks;
table.Percentage = Student_Percentage;

for i = 1:63
sheet1=readtable(filename);
mark=sheet1{i,{'CALCULUS','DISCRETE','ECONOMICS','ISLAMIAT','STATISTICS'}};

if mark(mark<40)
grade='F';
sheet1(i,'StudentGrade')=cellstr(grade);
else 
continue
end
end
writetable(table,filename)
xlswrite(filename,T,1, 'H2')
xlswrite(filename,grade,1,'J2')

这些是我得到的错误

Error using getRowIndices (line 75)
Row index exceeds table dimensions.

Error in table/subsrefBraces (line 17)
[rowIndices,numRowIndices] =
getRowIndices(t, s(1).subs{1});

Error in table/subsref (line 60)
[varargout{1:nargout}] =
subsrefBraces(t,s);

Error in lab4 (line 38)
mark=sheet1{i,{'CALCULUS','DISCRETE','ECONOMICS','ISLAMIAT','STATISTICS'}}; 

我试过了，但这个代码不起作用

我是怎么做这个的

我将链接粘贴到我的文件所在的位置。。我想如果任何学生在任何科目上的成绩低于40分，那么就想表现出F级。。此代码显示总分是否小于40。。我想展示的是，在任何科目的中，分数是否低于40

这是excel文件

https://drive.google.com/file/d/1VQ8XxAQPu6reY0SCNV9Rxt65w1koduGA/view?usp=sharing

Answer 1

我没有安装Excel，所以我不能检查有关读取和写入Excel的部分，但你应该替换

if R>=80
table.StudentGrade{i} = 'A';
elseif R>=70 
table.StudentGrade{i} = 'B';
elseif R <70
table.StudentGrade{i}= 'F';
end

带有

if R(i)>=80
table.StudentGrade{i} = 'A';
elseif R(i)>=70 
table.StudentGrade{i} = 'B';
elseif R(i) <70
table.StudentGrade{i}= 'F';
end