用库文件操作EXCEL表格练习2

# encoding utf-8
import xlwings as xw

wb = xw.Book()
sht = wb.sheets['Sheet1']  # 实例化工作表

sht.range('A1').value = [['name', 'gender', 'ages', 'jobs', 'salary'],
                         ['John', 'male', '21', 'staff', '1500'],
                         ['Alen', 'male', '23', 'staff', '1800'],
                         ['Sara', 'female', '21', 'staff', '1600'],
                         ['Oscar', 'male', '25', 'manager', '2200']
                         ]

wb.save('Files.xlsx')   # 保存文件
wb.close()     # 关闭文件