The latest articles on DEV Community by Steph Mojekwu (@missyneon). https://dev.to/missyneon https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1083445%2F8919517b-42eb-4e75-ae26-e595a1da363c.png https://dev.to/missyneon en Steph Mojekwu Tue, 16 May 2023 00:18:07 +0000 https://dev.to/missyneon/openpyxl-wont-load-excel-fill-with-blue-style-fill-in-cells-2213 https://dev.to/missyneon/openpyxl-wont-load-excel-fill-with-blue-style-fill-in-cells-2213 <p>I wrote a python script to load an excel file with blue style fill in the excel sheet (blue color background in cells) and the load_workbook function keeps failing with the error below:<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>wb = load_workbook(excel file) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\&lt;username&gt;\AppData\Local\Programs\Python\Python311\Lib\site-packages\openpyxl\reader\excel.py", line 346, in load_workbook reader.read() File "C:\Users\&lt;username&gt;\AppData\Local\Programs\Python\Python311\Lib\site-packages\openpyxl\reader\excel.py", line 299, in read apply_stylesheet(self.archive, self.wb) File "C:\Users\&lt;username&gt;\AppData\Local\Programs\Python\Python311\Lib\site-packages\openpyxl\styles\stylesheet.py", line 198, in apply_stylesheet stylesheet = Stylesheet.from_tree(node) ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\&lt;username&gt;\AppData\Local\Programs\Python\Python311\Lib\site-packages\openpyxl\styles\stylesheet.py", line 103, in from_tree return super(Stylesheet, cls).from_tree(node) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\&lt;username&gt;\AppData\Local\Programs\Python\Python311\Lib\site-packages\openpyxl\descriptors\serialisable.py", line 103, in from_tree return cls(**attrib) ^^^^^^^^^^^^^ File "C:\Users\&lt;username&gt;\AppData\Local\Programs\Python\Python311\Lib\site-packages\openpyxl\styles\stylesheet.py", line 74, in __init__ self.fills = fills ^^^^^^^^^^ File "C:\Users\&lt;username&gt;\AppData\Local\Programs\Python\Python311\Lib\site-packages\openpyxl\descriptors\sequence.py", line 27, in __set__ seq = self.container(_convert(self.expected_type, value) for value in seq) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\&lt;username&gt;\AppData\Local\Programs\Python\Python311\Lib\site-packages\openpyxl\descriptors\sequence.py", line 27, in &lt;genexpr&gt; seq = self.container(_convert(self.expected_type, value) for value in seq) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\&lt;username&gt;\AppData\Local\Programs\Python\Python311\Lib\site-packages\openpyxl\descriptors\base.py", line 61, in _convert raise TypeError('expected ' + str(expected_type)) TypeError: expected &lt;class 'openpyxl.styles.fills.Fill'&gt; </code></pre> </div> <p>How do I fix this error using python? Thank you!</p> openpyxl