当使用XLSXWriter导出到Excel时，如何更改URL字段的格式？

Question

我尝试更改从保存熊猫到下面的excel代码所获得的URL字段的格式，

应该适用于Excel文件的所有可用区域，但由于某种原因，第一列包含Web Adresses并没有改变其样式。取而代之的是，它仍然使用默认的excel格式化

writer = pd.ExcelWriter(f"{date_filename}.xlsx", engine="xlsxwriter")

df.to_excel(writer, index=False, sheet_name='current')

workbook = writer.book
worksheet = writer.sheets['current']

font_format = workbook.add_format({'font_name': 'Calibri', 'font_size': 13})
header_format = workbook.add_format({'font_name': 'Calibri', 'font_size': 13, 'bold': True})

worksheet.set_column('A:H', None, font_format)
worksheet.set_row(0, None, header_format)


writer.save()

我的df具有几列，其中第一个是一个URL One（一个对象dtype）

#   Column                Non-Null Count  Dtype  
---  ------                --------------  -----  
 0   url                   2 non-null      object 

，我在其中存储WG，

https://google.com in a first row, 
https://amazon.com in a second etc

我想知道为什么它可以保持默认的Excel格式化。

Answer 1

我真的看不到问题，但是可以肯定的是，建议您不声明变量writer = pd.excelwriter而不是使用whit

示例代码

import pandas as pd

tops = [
    {"name": "google", "url": "https://www.google.com"},
    {"name": "amazon", "url": "https://www.amazon.com"},
    {"name": "apple", "url": "https://www.apple.com"},
]

df = pd.DataFrame(tops)

with pd.ExcelWriter("excel.xlsx", engine="xlsxwriter") as writer:
    df.to_excel(writer, index=False, sheet_name="current")

    workbook = writer.book
    worksheet = writer.sheets["current"]

    font_format = workbook.add_format({"font_name": "Calibri", "font_size": 13})
    header_format = workbook.add_format(
        {"font_name": "Calibri", "font_size": 13, "bold": True}
    )

    worksheet.set_column("A:H", None, font_format)
    worksheet.set_row(0, None, header_format)

print("save")

<强>响应

它起作用了！