python笔记系列：数据报表之Excel操作模块：XlsxWriter

本文链接：https://blog.csdn.net/qq_40809549/article/details/79697219

本文详细介绍了使用Python的XlsxWriter模块创建Excel报表的方法，包括设置单元格格式、添加图表、调整行列宽高等。通过示例展示了如何定制自动化业务流量报表周报，包括写入数据、绘制柱状图以及计算平均值。

摘要由CSDN通过智能技术生成

 
 定制业务质量报表详解 

  数据报表之Excel操作模块： 
 XlsxWriter 

  pip install XlsxWriter 

  easy_install XlsxWriter 

  curl -O -L http://github.com/jmcnamara/XlsxWriter/archive/master.tar.gz 

  tar -zxvf master.tar.gz 

  cd XlsxWriter-master/ 

  sudo python setup.py install 

  生成一个简单的excel 

  #coding: utf-8 

  import xlsxwriter 

  # Create an new Excel file and add a worksheet. 

  workbook = xlsxwriter.Workbook('demo1.xlsx') 

  worksheet = workbook.add_worksheet() 

  # Widen the first column to make the text clearer. 

  worksheet.set_column('A:A', 20) 

  # Add a bold format to use to highlight cells. 

  #bold = workbook.add_format({'bold': True}) 

  bold = workbook.add_format() 

  bold.set_bold() 

  # Write some simple text. 

  worksheet.write('A1', 'Hello') 

  # Text with formatting. 

  worksheet.write('A2', 'World', bold) 

  worksheet.write('B2', u'中文测试', bold) 

  # Write some numbers, with row/column notation. 

  worksheet.write(2, 0, 32) 

  worksheet.write(3, 0, 35.5) 

  worksheet.write(4, 0, '=SUM(A3:A4)') 

  # Insert an image. 

  worksheet.insert_image('B5', 'img/python-logo.png') 

  workbook.close() 

  》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》 

 
 Workbook(filename[,options])类，创建XlsxWriter的Workbook对象 

  add_worksheet([sheetname])方法，创建一个新的工作表 

  add_format([properties])方法，在工作表中创建一个新的格式对象来格式化单元格 

  add_chart(options)方法，工作表中创建一个图表对象，内部通过insert_chart()方法实现 

  close()方法，关闭工作表文件，如workbook.close() 

 
 Worksheet类  

 
 write(row,col,*args) 写普通数据到单元格，row行坐标，col列坐标，起始值为0 

  write_string() 

  eg：worksheet.write_string(0,0,'Hello') 

  write_number() 

  eg：worksheet.write_number('A2',3.14) 

  write_blank() 

  eg：worksheet.write_blank('A2',None) 

  write_formula() 

  eg：worksheet.write_formula(2,0,'=SUM(B1:B5)') 

  write_datetime() 

  eg：worksheet.write_datetime(2,0,datetime.datetime.strptime('2013-01-23','%Y-%m-%d'),workbook.add_format({'num_format':'yyyy-mm-dd'})) 

  write_boolean() 写入逻辑类型数据 

  eg：worksheet.write_boolean(0,0,True) 

  write_url() 

  eg：worksheet.write_url('A1','ftp://www.python.org/') 

 
 set_row(row,height,cell_format,