blocks|key|4499067|text|我认为问题在于你试图给一个样式分配一个填充对象。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4499068|ws['A1'].fill+=+redFill应该可以很好地工作。|offset|length|style|CODE|4499069|entityMap^0|0|0|N|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I believe the issue is that you're trying to assign a fill object to a style.

<code>ws['A1'].fill = redFill</code> should work fine.

blocks|key|4499988|text|这对我很有效。他们改变了一些东西，你在互联网上看到的大多数帮助都是针对我所看到的openpyxl库的旧版本的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4499989|#+Change+background+color+
xls_cell.style+=+Style(fill=PatternFill(patternType='solid',
++++++++++++++++++++++++++++++++++++++++fill_type='solid',+
++++++++++++++++++++++++++++++++++++++++fgColor=Color('C4C4C4')))|code-block|syntax|javascript|4499990|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This worked for me. They changed things and most of the help you see on the internet is for older versions of the openpyxl library from what I am seeing.

<pre><code># Change background color 
xls_cell.style = Style(fill=PatternFill(patternType='solid',
 fill_type='solid', 
 fgColor=Color('C4C4C4')))
</code></pre>

blocks|key|4500011|text|样式的API再次更改。对我起作用的是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4500012|my_red+=+openpyxl.styles.colors.Color(rgb='00FF0000')
my_fill+=+openpyxl.styles.fills.PatternFill(patternType='solid',+fgColor=my_red)
cell.fill+=+my_fill|code-block|syntax|javascript|4500013|颜色是alpha+RGB十六进制颜色。您可以将其作为默认alpha为00的'rrggbb'传递，也可以使用'aarrggbb'指定alpha。如果您需要快速获取一种颜色，则在openpyxl.styles.colors中将一组颜色定义为常量。|offset|length|style|CODE|4500014|entityMap^0|0|0|11|8|1H|A|2F|M|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]|$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|N|$]]

The API for styles changed once again. What worked for me was

<pre><code>my_red = openpyxl.styles.colors.Color(rgb='00FF0000')
my_fill = openpyxl.styles.fills.PatternFill(patternType='solid', fgColor=my_red)
cell.fill = my_fill
</code></pre>

Color is an alpha RGB hex color. You can pass it in as <code>'rrggbb'</code> with a default alpha of 00 or specify the alpha with <code>'aarrggbb'</code>. A bunch of colors are defined as constants in <code>openpyxl.styles.colors</code> if you need to grab one quickly.

blocks|key|4499146|text|在python+3.x中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4499147|wb+=+openpyxl.Workbook()
ws+=+wb.active
redFill+=+PatternFill(start_color='FFFF0000',
+++++++++++++++++++end_color='FFFF0000',
+++++++++++++++++++fill_type='solid')
ws['A1'].fill+=+redFill|code-block|syntax|javascript|4499148|但在Python2.x中我不知道，我希望工作只是把ws['A1'].fill=redFill|offset|length|style|CODE|4499149|entityMap^0|0|0|P|L|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

in python 3.x

<pre><code>wb = openpyxl.Workbook()
ws = wb.active
redFill = PatternFill(start_color='FFFF0000',
 end_color='FFFF0000',
 fill_type='solid')
ws['A1'].fill = redFill
</code></pre>

that working but i dont know in python 2.x i hope working
just put <code>ws['A1'].fill=redFill</code>

blocks|key|4499158|text|要填充一定范围的行/列，请执行以下操作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4499159|for+cell+in+ws['A1:A100']:
+++cell[0].fill+=+redFill|code-block|syntax|javascript|4499160|填充列的所有行|4499161|for+cell+in+ws['A1:{}'.format(ws.max_row)]:
+++cell[0].fill+=+redFill|4499162|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

To fill a range of rows/columns, do this
<pre><code>for cell in ws['A1:A100']:
 cell[0].fill = redFill
</code></pre>
To fill all rows of a column
<pre><code>for cell in ws['A1:{}'.format(ws.max_row)]:
 cell[0].fill = redFill
</code></pre>

blocks|key|4500067|text|from+openpyxl+import+Workbook,+load_workbook
from+openpyxl.styles+import+PatternFill

_file_name+=+"Test.xlsx"
_sheet_name+=+"Test_Sheet"

def+new_workbook(_file_name,+_sheet_name):
++++wb+=+Workbook()++#+Workbook+Object
++++ws+=+wb.active++#+Gets+the+active+worksheet
++++ws.title+=+_sheet_name++#+Name+the+active+worksheet

++++#+Writing+the+header+columns
++++ws['A1']+=+'Name'
++++ws['B1']+=+'Class'
++++ws['C1']+=+'Section'
++++ws['D1']+=+'Marks'
++++ws['E1']+=+'Age'
++++

++++col_range+=+ws.max_column++#+get+max+columns+in+the+worksheet

++++#+formatting+the+header+columns,+filling+red+color
++++for+col+in+range(1,+col_range+%2B+1):
++++++++cell_header+=+ws.cell(1,+col)
++++++++cell_header.fill+=+PatternFill(start_color='FF0000',+end_color='FF0000',+fill_type="solid")+#used+hex+code+for+red+color

++++wb.save(_file_name)++#+save+the+workbook
++++wb.close()++#+close+the+workbook

if+__name__+==+'__main__':
new_workbook(_file_name,+_sheet_name)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4500068|结果-|unstyled|4500069|📷|atomic|offset|length|4500070|​|4500071|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/6ebee68da6c8fbf13e33df99bfc1dc16.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|Y|8|@]|9|@$J|Z|K|10|1|11]]|A|$]]|$1|L|3|M|5|F|7|12|8|@]|9|@]|A|$]]|$1|N|3|-4|5|F|7|13|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U|V|-4]]]]

<pre><code>from openpyxl import Workbook, load_workbook
from openpyxl.styles import PatternFill

_file_name = &quot;Test.xlsx&quot;
_sheet_name = &quot;Test_Sheet&quot;

def new_workbook(_file_name, _sheet_name):
 wb = Workbook() # Workbook Object
 ws = wb.active # Gets the active worksheet
 ws.title = _sheet_name # Name the active worksheet

 # Writing the header columns
 ws['A1'] = 'Name'
 ws['B1'] = 'Class'
 ws['C1'] = 'Section'
 ws['D1'] = 'Marks'
 ws['E1'] = 'Age'
 

 col_range = ws.max_column # get max columns in the worksheet

 # formatting the header columns, filling red color
 for col in range(1, col_range + 1):
 cell_header = ws.cell(1, col)
 cell_header.fill = PatternFill(start_color='FF0000', end_color='FF0000', fill_type=&quot;solid&quot;) #used hex code for red color

 wb.save(_file_name) # save the workbook
 wb.close() # close the workbook

if __name__ == '__main__':
new_workbook(_file_name, _sheet_name)
</code></pre>
<h1>Result - <a href="https://i.stack.imgur.com/rgEpE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rgEpE.png" alt="enter image description here" /></a></h1>

blocks|key|4500094|text|使用嵌套的for循环填充二维范围。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4500095|Python+3.9|4500096|import+openpyxl+as+op
fill_gen+=+op.styles.PatternFill(fill_type='solid',
+++++++++++++++++++++++++++++++++start_color='FFFFFF',
+++++++++++++++++++++++++++++++++end_color='FFFFFF')
for+row+in+ws["A1:BB50"]:
++++for+cell+in+row:
++++++++cell.fill+=+fill_gen|code-block|syntax|javascript|4500097|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Use a nested for loop to fill a two dimensional range.
Python 3.9
<pre><code>import openpyxl as op
fill_gen = op.styles.PatternFill(fill_type='solid',
 start_color='FFFFFF',
 end_color='FFFFFF')
for row in ws[&quot;A1:BB50&quot;]:
 for cell in row:
 cell.fill = fill_gen
</code></pre>

blocks|key|4500107|text|对于Excel，我会这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4500108|from+openpyxl+import+Workbook,+load_workbook
from+openpyxl.style+import+PatternFill

wb+=+load_workbook("test.xlsx")
ws+=+wb.active

ws["A1"].fill+=+PatternFill("solid",+start_color="FFA500")|code-block|syntax|javascript|4500109|你可以用另一个单元格替换"A1“，并且start_color必须是十六进制的颜色。|4500110|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

What I would do for Excel is this:
<pre><code>from openpyxl import Workbook, load_workbook
from openpyxl.style import PatternFill

wb = load_workbook(&quot;test.xlsx&quot;)
ws = wb.active

ws[&quot;A1&quot;].fill = PatternFill(&quot;solid&quot;, start_color=&quot;FFA500&quot;)
</code></pre>
You can replace &quot;A1&quot; with another cell and start_color has to be a hex color.

I am currently using openpyxl v2.2.2 for Python 2.7 and i wanted to set colors to cells. I have used the following imports

<pre><code>import openpyxl,
from openpyxl import Workbook
from openpyxl.styles import Color, PatternFill, Font, Border
from openpyxl.styles import colors
from openpyxl.cell import Cell
</code></pre>

and the following is the code I tried using:

<pre><code>wb = openpyxl.Workbook()
ws = wb.active

redFill = PatternFill(start_color='FFFF0000',
 end_color='FFFF0000',
 fill_type='solid')

ws['A1'].style = redFill
</code></pre>

but I get the following error:

<pre><code>Traceback (most recent call last)
 self.font = value.font.copy()
AttributeError: 'PatternFill' object has no attribute 'font'
</code></pre>

Any idea on how to set cell A1 (or any other cells) with colors using openpyxl?

Fill cells with colors using openpyxl?

Python

我目前在Python2.7上使用openpyxl v2.2.2，我想给单元格设置颜色。我使用了以下导入import openpyxl,from openpyxl import Workbookfrom openpyxl.styles import Color, PatternFill, Font, Borderfrom...

问使用openpyxl用颜色填充单元格？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用openpyxl用颜色填充单元格？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用openpyxl用颜色填充单元格？
EN