创建excel(xlsx)表格，连续写入数据

import openpyxl
import os
from openpyxl import Workbook,load_workbook
from openpyxl.worksheet import worksheet

if __name__ == '__main__':
    # 指定文件路径
    file_full_path = r'D:\gy_data\test.xlsx'  #表格自己创建
    if os.path.isfile(file_full_path) != True:
        workbook = Workbook()
        worksheet = workbook.active
        worksheet.title = "test"

        column_names = ['姓名','班级','学号']
        for i in range(len(column_names)):
            worksheet.cell(row=1,column=i+1,value=column_names[i])


        workbook.save(file_full_path)

    # sheet名称
    sheet_name = 'test'

    # 获取指定的文件
    wb = openpyxl.load_workbook(file_full_path)
    # 获取指定的sheet
    ws = wb[sheet_name]
    # 获得最大行数
    max_row_num = ws.max_row
    # 获得最大列数
    max_col_num = ws.max_column

    # 将当前行设置为最大行数
    ws._current_row = max_row_num

    # 使用append方法，将行数据按行追加写入
    a = 'amy'
    b = '8班'
    c = '2023454722'
    values = [a, b, c]
    ws.append(values)

    # 保存文件
    wb.save(file_full_path)