• import xlsxwriter

• wb = xlsxwriter.Workbook("data.xlsx") # 创建工作簿

• sheet = wb.add_worksheet("newsheet") # 创建工作表

• sheet.write(0, 0, "title") # 写入单元格数据

• sheet.merge_range(1, 0, 2, 2, "data") # 合并单元格并写入数据

• sheet.write_row(3, 0, ["col1", "col2", "col3" ]

• sheet.write(7, 1, "=sum(B5:B7)" # 写入公式

• sheet.write_url(9, 0, "http://www.baidu.com", string = "更多数据" # 写入超链接

• sheet.insert_image(10, 0, "view.png") # 插入图片
  

• wb.close() # 关闭文件
  

xlsxwriter.Workbook("工作簿名.xlsx")            创建工作簿

.add_worksheet("表名")                                  创建工作表

.write(行,列,"内容")                                          写入单元格

.merge_range(起始行,起始列,结束行,结束列,"内容")            写入合并单元格

.write_row(行,列,["内容1","内容2","内容3"])                        写入一行数据

.write_url(行,列,"超链接",srting="显示的文字")                   写入超链接

.insert_image(行,列,"路径/文件名.png")                             插入图片

sheet.write()