Alter the style of all cells with openpyxl

excel, openpyxl, python

Solution

There is no method to do this. At the moment the best approach would probably be to set the style for all the relevant columns or rows

style = Style(…)
for col in 'ABCD':
     ws._styles[col] = style

I think we'll be working on improving handling styles in coming releases.

Problem

I'm using openpyxl 2.0.3 with python2.7. Is there a way to apply a style to every cell in a worksheet? Lets say I want to change the font of all cells, similar to how I would open an excel document, hit ctrl+a, right click and change the format.

Original source