python写入数据到excel

import openpyxl as op

#创建workbook
ws = op.Workbook()

wb = ws.create_sheet(index=0)

wb.cell(row=1, column=1, value='职位名称')
wb.cell(row=1, column=2, value='国家')
wb.cell(row=1, column=3, value='城市')
wb.cell(row=1, column=4, value='职位分类')
wb.cell(row=1, column=5, value='职位更新时间')
wb.cell(row=1, column=6, value='职位要求')

# 加入count是为了换行写入数据
count = 2

# # 要写入excel的数据
# post_name = job['RecruitPostName']  # 职位名称
# country_name = job['CountryName']  # 国家
# loc_name = job['LocationName']  # 城市
# category_name = job['CategoryName']  # 职位分类
# last_up_time = job['LastUpdateTime']  # 职位更新时间
# responsibility = job['Responsibility']  # 职位要求

# 打印获取到的数据
# print(post_name, country_name, loc_name, category_name, last_up_time, responsibility)

# 将数据写入到下一行
wb.cell(row=count, column=1, value=1)
wb.cell(row=count, column=2, value=2)
wb.cell(row=count, column=3, value=3)
wb.cell(row=count, column=4, value=4)
wb.cell(row=count, column=5, value=5)
wb.cell(row=count, column=6, value=6)

# count加1，进入到下一行写入数据
count += 1
print(count)

# 保存数据
ws.save('腾讯职位.xlsx')