pandas - xlswriter“valign”：“vcenter”不工作

Question

下面的脚本读取现有的 CSV 文件，添加一些格式并导出到 Excel 文件。当我打开 Excel 文件时，所有格式都在那里，除了这个属性：

"valign": "vcenter"

下面是我的代码的一部分......

df     = pd.read_csv(in_fname)
writer = pd.ExcelWriter(out_fname, engine="xlsxwriter")

df.to_excel(writer, sheet_name="Products")
workbook  = writer.book
worksheet = writer.sheets["Products"]

worksheet.set_default_row(20) 
hdr_format = workbook.add_format({"bg_color": "yellow", "align": "center", 
                                 "valign": "vcenter", "bold": True, "text_wrap": True, 
                                  "bottom": 1, "top": 0, "left": 0, "right": 0})
format1    = workbook.add_format({"num_format": "#,##0.00"})
format2    = workbook.add_format({"num_format": "#,##0"})

count = 0
while count < len(hdgs):
    worksheet.write(cells[count], hdgs[count], hdr_format)
    worksheet.set_column(cols[count], widths[count])  
    count += 1

worksheet.freeze_panes(1, 0) 
writer.save()

标签： pandasexport-to-excel