import os
import openpyxl
os.chdir(r'D:/openpyxl')

wb = openpyxl.Workbook()

sht = wb.create_sheet('data')

#写入数据方法1

sht.cell(row=1,column=1,value='test')

#写入数据方法2
sht['A2'] = 'python'

#保存并关闭

wb.save('test.xlsx')
wb.close()