How can I center align in pandas dataframe only cell that i want

Question

writer=pd.ExcelWriter('Data.xlsx',engine='openpyxl')
emptydf.to_excel(writer,sheet_name=('Sheet1'),na_rep='-')
concat5.to_excel(writer,sheet_name=('Sheet2'),na_rep='-')
workbook=writer.book
writer.save()

What I want is align to center only cells that "-". It is aligned to left right now. I want to know how i could this. Thank you.

Originally, All "-" cells are expressed "NaN". I changed to "-". — lincplus htm, Jun 02 '20 at 10:36
Have a look here - [Horizontal text alignment in openpyxl](https://stackoverflow.com/questions/26671581/horizontal-text-alignment-in-openpyxl) — 0buz, Jun 02 '20 at 10:36

score 0 · Answer 1 · answered Jun 02 '20 at 11:38

0

This is an openpyxl solution:

from openpyxl.styles import Alignment
from openpyxl import load_workbook

wb = load_workbook('Data.xlsx')
ws_names=wb.get_sheet_names()

for ws_name in ws_names:
    for row_cells in wb.get_sheet_by_name(ws_name):
        for cell in row_cells:
            if cell.value == '-':
                cell.alignment = Alignment(horizontal='center')

wb.save('Data.xlsx')
wb.close()

answered Jun 02 '20 at 11:38

0buz

3,443
2
8
29

Thank you very much. I got all i want. – lincplus htm Jun 02 '20 at 12:06

How can I center align in pandas dataframe only cell that i want

1 Answers1