I know this method, but i need set style for many cell's, not in cycle.
Try using a function like this:
defcopyStyle(toStyle,fromStyle):"""Simple way to copy styles for openpyxl."""toStyle.font=deepcopy(fromStyle.font)toStyle.fill=deepcopy(fromStyle.fill)toStyle.borders=deepcopy(fromStyle.borders)toStyle.alignment=deepcopy(fromStyle.alignment)toStyle.number_format=deepcopy(fromStyle.number_format)toStyle.protection=deepcopy(fromStyle.protection)# Then:font=Font()font.name='Consolas'font.size=10style=Style()style.font=fontcopyStyle(ws.cell('B1').style,style)
Starting with v2.0 styles are immutable so the suggestions won't work quite as advertised.
There is no function for applying the same style to multiple cells at once but you could do this within a range or simply iterate over the the cells. Styles can also be applied to rows and columns or even groups of columns.
Wow! Too fast answer! 1 year, 3 month, 3 days. Thank you/
Actually, you were provided with workable answers last year. Posting questions like this on the bugtracker is not necessarily the best place, the mailing list might be better. But this also how things are in the open source world: every project depends upon volunteers being prepared to look at things.