python xlwt设置单元格背景色

最新推荐文章于 2023-03-29 14:14:27 发布

njit_peiyuan

最新推荐文章于 2023-03-29 14:14:27 发布

阅读量1.4k

点赞数

文章标签： python

原文链接：https://my.oschina.net/HappyRoad/blog/175028

版权

2019独角兽企业重金招聘Python工程师标准>>>

<pre><code> import xlwt workbook = xlwt.Workbook() worksheet = workbook.add_sheet('My Sheet') pattern = xlwt.Pattern() # Create the Pattern pattern.pattern = xlwt.Pattern.SOLID_PATTERN # May be: NO_PATTERN, SOLID_PATTERN, or 0x00 through 0x12 pattern.pattern_fore_colour = 5 # May be: 8 through 63. 0 = Black, 1 = White, 2 = Red, 3 = Green, 4 = Blue, 5 = Yellow, 6 = Magenta, 7 = Cyan, 16 = Maroon, 17 = Dark Green, 18 = Dark Blue, 19 = Dark Yellow , almost brown), 20 = Dark Magenta, 21 = Teal, 22 = Light Gray, 23 = Dark Gray, the list goes on... style = xlwt.XFStyle() # Create the Pattern style.pattern = pattern # Add Pattern to Style worksheet.write(0, 0, 'Cell Contents', style) workbook.save('Excel_Workbook.xls') </code></pre>

或者直接

<pre><code> xlwt.easyxf(‘pattern: pattern solid, fore_colour ocean_blue; font: bold on;’); </code></pre>

转载于:https://my.oschina.net/HappyRoad/blog/175028