【代码】xlsxwriter设计sheet页样式

将数据以excel文件的形式导出，并使用xlsxwriter完成sheet页样式的定制 1、生成字节流对象以及编写对象

self.ouput = io.BytesIO()
self.writer = pd.ExcelWriter(self.ouput, engine=xlsxwriter)

2、获取需要操作的sheet页

df = pd.Series(, name=" ")
df.to_excel(self.writer, index=False, sheet_name="_xxx")
worksheet = self.writer.sheets[_xxx]
workbook = self.writer.book
worksheet.set_column("A:F", 30)

3、设计单元格样式

format = workbook.add_format({
          
   
bold: True, 
border: 1, 
align: center,
valign: vcenter,
bg_color: writer,
text_wrap: True})

4、向指定位置单元格中写入内容，合并单元格，插入图片

worksheet.write(row_number, col_number, 内容， format)
worksheet.merge_range(start_row, start_col, end_row, end_col, 内容， format)
worksheet.insert_image(row_number, col_number, 图片地址)

5、保存导出数据

self.writer.save()
self.ouput.seek(0)
self.set_header(Content-Type, application/octet-stream)
self.set_header(Content-Disposition, attachment;filename={}.xls.format(excel_file_name.encode(utf-8).decode(ISO-8859-1)))
self.writer(self.ouput.read())