Horizontal text alignment in openpyxl

python xlsx openpyxl
Pythonizer picture Pythonizer · Oct 31, 2014 · Viewed 40.8k times · Source

I'm tryign to change the text alignment to the center of 2 merged sells, I've found some answers that didn't work for my case

currentCell = ws.cell('A1')
currentCell.style.alignment.horizontal = 'center' #TypeError: cannot set horizontal attribute
#or
currentCell.style.alignment.vertical = Alignment.HORIZONTAL_CENTER #AttributeError: type object 'Alignment' has no attribute 'HORIZONTAL_CENTER'

both didn't work, is there any other ways to do it?

Answer

samsemilia7 picture samsemilia7 · Jul 29, 2015

yes, there is a way to do this with openpyxl:

from openpyxl.styles import Alignment

currentCell = ws.cell('A1') #or currentCell = ws['A1']
currentCell.alignment = Alignment(horizontal='center')

hope this will help you

Related questions

Setting styles in Openpyxl

I need advice on setting styles in Openpyxl. I see that the NumberFormat of a cell can be set, but I also require setting of font colors and attributes (bold etc). There is a style.py class but it seems …

Read More
iterating over a range of rows using ws.iter_rows in the optimised reader of openpyxl

I need to read an xlsx file of 10x5324 cells This is the gist of what i was trying to do: from openpyxl import load_workbook filename = 'file_path' wb = load_workbook(filename) ws = wb.get_sheet_by_name('LOG') …

Read More
Insert image in openpyxl

Is it possible to insert an image (jpeg, png, etc) using openpyxl? Basically I want to place a generated image with a chart below it. I don't see anything in the documentation, which seems to be a little lacking compared …

Read More