python3使用xlsxwriter创建xlsx并写入数据
环境:python版本---3.6.5
import xlsxwriter
#创建工作簿
file_name = "D:\\0data\\python\\meng\\first_book.xlsx"
workbook = xlsxwriter.Workbook(file_name)
#创建工作表
worksheet = workbook.add_worksheet('first_sheet')
#写单元格
worksheet.write(0,0,'Hello')
worksheet.write('A2','wold')
#写行
worksheet.write_row(2,0,[1,2,3,4,5,6])
#写列,其中列F需要大写
worksheet.write_column('F2',['a','b','c','d'])
#关闭工作簿
workbook.close()