title: Openpyxl: set background color to a row and column Attribute Error
body: <p>having looked at a few examples over here I tried to set background color to an entire row and column. I have done</p>
  <pre><code> import openpyxl
   from openpyxl.styles import PatternFill
   wb = openpyxl.load_workbook(self.inputfile)
   ws = wb.active
   ws['A1'].fill = PatternFill(bgColor=&quot;FFC7CE&quot;, fill_type = &quot;solid&quot;)`
  </code></pre>
  <p>I get an Attribute error if I do `ws[1].fill =PatternFill(bgColor=&quot;FFC7CE&quot;, fill_type = &quot;solid&quot;)</p>
  <p>The above code fills a single cell(A1). But how do I go forward if I want to fill an entire row(1), and an entire column(A).</p>