Home  >  Article  >  Backend Development  >  Example code for using Python to draw a report and set cell color

Example code for using Python to draw a report and set cell color

高洛峰
高洛峰Original
2017-03-26 17:33:563538browse

This article mainly introduces in detail the example code of using Python to draw reports and set cell colors. It has certain reference value. Interested friends can refer to it

原文地址:Python通过Pattern设置单元格底纹及背景色作者:teng
Python通过Pattern设置excel文件的单元格底纹及背景颜色时,无法得到想要设置的单元格颜色所代表的数值,最开始采用笨办法,从0开始不停地测试对应的颜色,最后同事提示不如利用Python写个小程序,将0-256对应的颜色显示出来,从而可以根据自己想要的颜色找到对应的数值。在这里将这段小程序和大家共享一下,就不需要一个个去尝试了。
如果对一个单元格重复操作,会引发
returns error:
# Exception: Attempt to overwrite
cell:
# sheetname=u'sheet 1' rowx=0
colx=0
所以在打开时加cell_overwrite_ok=True
解决
以下为源代码:
# -*-
coding: utf-8 -*-
import xlwt
#新建一个excel文件
file=xlwt.Workbook()
#新建一个sheet
table=file.add_sheet('sheet
name',cell_overwrite_ok=True)
for i in range(0,256):
     stylei= xlwt.XFStyle()
       #初始化样式
     patterni= xlwt.Pattern()
      #为样式创建图案
     patterni.pattern=1         #设置底纹的图案索引,1为实心,2为50%灰色,对                       应为excel文件单元格格式中填充中的图案样式
     patterni.pattern_fore_colour=i  #设置底纹的前景色,对应为excel文件单元格格式                       中填充中的背景色
     patterni.pattern_back_colour=35 #设置底纹的背景色,对应为excel文件单元格格式
                      中填充中的图案颜色
     stylei.pattern=patterni     #为样式设置图案
     table.write(i,0,i,stylei)    #使用样式
file.save('D:/Python27/colour.xls')

The above is the detailed content of Example code for using Python to draw a report and set cell color. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn