关于用python写入表格的问题

关于出现Exception
Attempt to overwrite cell: sheetname='ClassA' rowx=2 colx=8
主要改动是我在原本的几个元素中加入了studentName数组,个人想法是想通过识别Name中的相同元素来增加冲突值,但是由于我是python入门.主要代码都是借鉴于：

cell的问题后不知如何解决,希望有人能解答,不胜感激
部分代码如下：
with open('Calendar.csv') as calendar:

#re=reader()
r = calendar.readlines()
for i in range(len(r)):
    r[i] = r[i].split(',')
for section in range(1,sectionnum+1):  # only 1 section
    
    sheet=w.add_sheet(data[0][section])
    for i in range(10):
        sheet.col(i).width=256*30   #set width of the block
    for j in range(size):
        sheet.write(0,j,col_labels[j],style)  #set column label
    for j in range(1,5):
        for k in range(3):
            sheet.write(j,k,r[j][k],style)
    schedule = []
    for k in res:
        if k.classId == section:
            schedule.append(k)
    for s in schedule:
        
        weekDay = s.weekDay
        slot = s.slot
        text = 'course: {} \n class: {} \n room: {} \n teacher: {} \n studentId: {} '.format(s.courseId, s.classId, s.roomId, s.teacherId,s.studentId)
        
        text = str(courseid[s.courseId]) +'\nVenue：301-'+ str(100+s.roomId)+'\nInvigilator：'+str(teacherid[str(s.teacherId)])+'\nStudent：'+str(studentid[str(s.studentId)])
        print(text)
        print(weekDay)
        print(slot)
        sheet.write(slot,weekDay+2,text,style)

你都是with open('Calendar.csv') as calendar，，你是读写csv，这个不是excel文件，两者是有差别的