Pandas表头不能垂直居中的解决方案

用Pandas的XlsxWriter保存Excel表格表头不能垂直居中

如题，做了一个导出小程序，但一直存在一个问题，即表头总是靠顶对齐，在网上找了很久，也没有找到合适的解决方案，今天跑XlsxWriter的官网去了，找到了解决办法，具体见下面的代码，不过代码中有个小错误，我已经改过来了。

小错误，当然也不算是一个错误，如果默认增加索引列的话，如果不增加索引列，就是一个错误了，会导致表头向右偏移一个单元格。

原代码

worksheet.write(0, col_num + 1, value, header_format)

修正后代码，即去掉col_num后面的+1

 worksheet.write(0, col_num, value, header_format)

以下为代码来源：https://xlsxwriter.readthedocs.io/example_pandas_header_format.html

##############################################################################
#
# An example of converting a Pandas dataframe to an xlsx file
# with a user defined header format.
#
# SPDX-License-Identifier: BSD-2-Clause
# Copyright 2013-2024, John McNamara, jmcnamara@cpan.org
#

import pandas as pd

# Create a Pandas dataframe from some data.
data = [10, 20, 30, 40, 50, 60]
df = pd.DataFrame({"Heading": data, "Longer heading that should be wrapped": data})

# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter("pandas_header_format.xlsx", engine="xlsxwriter")

# Convert the dataframe to an XlsxWriter Excel object. Note that we turn off
# the default header and skip one row to allow us to insert a user defined
# header.
df.to_excel(writer, sheet_name="Sheet1", startrow=1, header=False)

# Get the xlsxwriter workbook and worksheet objects.
workbook = writer.book
worksheet = writer.sheets["Sheet1"]

# Add a header format.
header_format = workbook.add_format(
    {
        "bold": True,
        "text_wrap": True,
        "valign": "top",
        "fg_color": "#D7E4BC",
        "border": 1,
    }
)

# Write the column headers with the defined format.
for col_num, value in enumerate(df.columns.values):
    worksheet.write(0, col_num + 1, value, header_format)

# Close the Pandas Excel writer and output the Excel file.
writer.close()