录入学生信息

最新推荐文章于 2024-06-03 13:31:43 发布

胡尔摩

最新推荐文章于 2024-06-03 13:31:43 发布

阅读量76

点赞数

文章标签： python 开发语言

本文链接：https://blog.csdn.net/weixin_46678567/article/details/129049811

版权

"""
我与我周旋久 宁作我.
"""
import openpyxl
import os
if os.path.exists('files/example4.xlsx'):
    wb2 = openpyxl.load_workbook('files/example4.xlsx')
else:
    wb2 = openpyxl.Workbook()
    # wb2.save('files/example4.xlsx')
sheet1 = wb2.create_sheet('student')
sheet1.cell(1, 1).value = '姓名'
sheet1.cell(1, 2).value = '年龄'
sheet1.cell(1, 3).value = '性别'
sheet1.cell(1, 4).value = '电话'
if 'student' in wb2.sheetnames:
    sheet1 = wb2['student']
else:
    sheet1 = wb2.create_sheet('student', 0)
i = 2
while True:
        sheet1.cell(i, 1).value = input('请输入学生的姓名:')
        sheet1.cell(i, 2).value = input('请输入学生的姓年龄:')
        sheet1.cell(i, 3).value = input('请输入学生的性别:')
        sheet1.cell(i, 4).value = input('请输入学生的电话:')
        wb2.save('files/example4.xlsx')  #保存很重要
        str2 = input('是否继续(Y/N):')
        if str2 == 'Y':
            i = i + 1
            pass
        else:
            break

wb2.save('files/example4.xlsx')

#老师给出的答案:
import openpyxl
import os

if os.path.exists('files/录入的学生信息.xlsx'):
    wb = openpyxl.open('files/录入的学生信息.xlsx')
else:
    wb = openpyxl.Workbook()

if 'student' in wb.sheetnames:
    sheet = wb['student']
else:
    sheet = wb.create_sheet('student')
    # 方法1：
    # sheet.cell(1, 1).value = '姓名'
    # sheet.cell(1, 2).value = '年龄'
    # sheet.cell(1, 3).value = '性别'
    # sheet.cell(1, 4).value = '电话'
    # 方法2：
    list1 = ['姓名', '年龄', '性别', '电话']
    for index in range(len(list1)):
        sheet.cell(1, index+1).value = list1[index]


wb.save('files/录入的学生信息.xlsx')

while True:
    # name = input('请输入姓名:')
    # age = int(input('请输入年龄:'))
    # gender = input('请输入性别:')
    # tel = input('请输入电话:')
    # m_r = sheet.max_row
    # sheet.cell(m_r+1, 1).value = name
    # sheet.cell(m_r + 1, 2).value = age
    # sheet.cell(m_r + 1, 3).value = gender
    # sheet.cell(m_r + 1, 4).value = tel
    # wb.save('files/录入的学生信息.xlsx')
    # value = input('是否继续添加(Y/N):')
    # if value == 'N':
    #     break
    # 方法2：
    m_r = sheet.max_row
    msg = ['请输入姓名:', '请输入年龄:', '请输入性别:', '请输入电话:']
    for x in range(len(msg)):
        result = input(msg[x])
        sheet.cell(m_r+1, x+1).value = result
    wb.save('files/录入的学生信息.xlsx')
    value = input('是否继续添加(Y/N):')
    if value == 'N':
        break