Horizontal alignment of text in openpyxl

Question

I am trying to change the alignment of the text to the center of two combined sales, I found several answers that did not 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, are there other ways to do this?

Answer 1

You can achieve this using the Python XlsxWriter library.

 import xlsxwriter workbook = xlsxwriter.Workbook('example.xlsx') worksheet = workbook.add_worksheet() cell_format = workbook.add_format({'align': 'center'}) worksheet.merge_range('A1:B1', "") worksheet.write_rich_string('A1','Example', cell_format) workbook.close() 

Here I combined cells A1, B1 and added a cell format parameter that includes the alignment parameter assigned as the center.

Answer 2

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 helps you

Answer 3

This is what finally worked for me with the latest version from PIP (2.2.5)

  # center all cells for col in w_sheet.columns: for cell in col: # openpyxl styles aren't mutable, # so you have to create a copy of the style, modify the copy, then set it back alignment_obj = cell.alignment.copy(horizontal='center', vertical='center') cell.alignment = alignment_obj 

Answer 4

No other solutions worked for me, since my solution requires openpyxl, and at least in 2.1.5 cell.alignment cannot be set directly.

 from openpyxl.styles import Style, Alignment cell = ws.cell('A1') cell.style = cell.style.copy(alignment=Alignment(horizontal='center')) 

The above instance copies the current style and replaces the alignment. You can also create a completely new style - with any values ​​not specified using the default values ​​from https://openpyxl.readthedocs.org/en/latest/styles.html

 cell.style = Style(alignment=Alignment(horizontal='center'),font=Font(bold=True)) # or - a tidier way vals = {'alignment':Alignment(horizontal='center'), 'font':Font(bold=True), } new_style = Style(**vals) cell.style = new_style