Python Excel 学生成绩管理系统 - 使用 xlrd 和 xlwt 库

{/n/'import///': /'xlrd/',/n/'import///': /'xlwt/',/n/'stu_file///': /'///'理论力学21.xlsx///'///',/n/'order///': /'(1, 87)///',/n/'book///': /'xlrd.open_workbook(stu_file)///',/n/'sheet///': /'book.sheets()[0]///',/n/'stu_name///': /'[]/',/n/'stu_order///': /'[]/',/n/'stu_class///': /'[]/',/n/'for i in range(*order)://n stu_name.append(sheet.cell_value(i, 2))//n stu_order.append(str(int(sheet.cell_value(i, 1))))//n stu_class.append(sheet.cell_value(i, 4))///',/n/'tmp_order///': /'[]/',/n/'tmp_grade///': /'[]/',/n/'if input(///'是否载入保存数据 tmp.tmp(默认 否)///')://n try://n with open(///'tmp.tmp///','r') as fp://n for i in fp://n tmp_order.append(i[:8])//n tmp_grade.append(i[9:-1])//n except://n pass///',/n/'#print(stu_order)//n#print(stu_name)//n#print(len(stu_name),len(stu_order))///',/n/'#for i in range(order[1]-1)://n# wt_sheet.write(i,0,stu_name[i])//n# wt_sheet.write(i,1,stu_order[i])///',/n/'while 1://n inp = input(///'姓名或学号：///')//n if inp == ''://n break//n if inp[-1] in ///'0123456789///'://n index = stu_order//n inp = ///'2021///' + inp//n else://n index = stu_name//n try://n i = index.index(inp)//n except://n l_t = []//n for j in range(len(index))://n if inp in index[j]://n l_t.append(j)//n if l_t://n for j in l_t://n print(f///'{j}: {stu_name[j]} {stu_order[j]}///')//n while 1://n try://n i = int(input(///'输入序号：///'))//n if i in l_t://n break//n except://n print(///'输入有误///')//n else://n print(///'输入有误请重新输入///')//n continue//n print(///'%s: %s: %s///'%(stu_order[i], stu_name[i], stu_class[i]))//n gin = input(///'输入成绩：///')///',/n/' try://n tmp_index = tmp_order.index(stu_order[i])//n gin = input(///'%s: %s: %s已有成绩：%s //n 请输入修改后的成绩///'%(stu_order[i], stu_name[i], stu_class[i], tmp_grade[tmp_index]))//n tmp_grade[tmp_index] = gin//n except://n tmp_order.append(stu_order[i])//n tmp_grade.append(gin)///',/n/'if input(///'是否保存tmp.tmp(默认 否)///')://n with open(///'tmp.tmp///','w') as fp://n for i in range(len(tmp_order))://n fp.write(///'%s:%s//n///'%(tmp_order[i],tmp_grade[i]))//n else://n wt_book = xlwt.Workbook(encoding=///'utf-8///')//n wt_sheet = wt_book.add_sheet(///'Test///')//n for i in range(len(tmp_order))://n j = stu_order.index(tmp_order[i])//n wt_sheet.write(j, 0, tmp_order[i])//n wt_sheet.write(j, 1, tmp_grade[i])//n wt_book.save(///'Test.xls///')/