python 对excel的操作

python创建excel

def create_excel(save_path):
    if not os.path.exists(save_path):    #不存在结果文件则创建文件，写入表头
        workbook = openpyxl.Workbook()  # 实例化
        sheet = workbook.active  # 激活worksheet
        sheet.title = 'sheet1'
        value = [['岗位名称', '公司名称', '岗位薪资', '岗位要求', '公司位置', '工作类型','公司类型','公司规模']]
        index = len(value)

        for i in range(index):
            for j in range(len(value[i])):
                sheet.cell(row=i + 1, column=j + 1, value=str(value[i][j]))
        workbook.save(save_path)

python向excel中追加数据

def append2xlsx(current_page,path, value):
    index = len(value)
    workbook = openpyxl.load_workbook(path)
    sheet = workbook['sheet1']

    for i in range(index):
        sheet.append(list(value[i]))  # append的内容必须是可迭代对象，里面的value必须是str类型
    workbook.save(path)
    print("xlsx格式表格数据追加成功！")