python - 如何在我想要的 pandas 数据框中仅居中对齐单元格

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()

我想要的是仅对齐“-”的单元格。它现在与左对齐。我想知道我怎么能这样。谢谢你。

标签： pythonpandas

Answer 1

这是一个openpyxl解决方案：

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()