Python写入CSV时Player对象显示异常，如何在Excel正常展示注册值？

问题根源 #

直接把Player类实例写入CSV时，Python会调用对象默认的__repr__()方法，输出<BBlineup.Player object at 0x...>这种内存地址字符串，CSV只会原样存储这个内容，自然无法在Excel里显示正常球员数据。

可行解决方案 #

方案1：提取对象属性转成字典/列表再写入 #

写入前手动把每个Player对象的属性提取成CSV能识别的结构，比如字典或列表。假设你的Player类有name、position、jersey_number这几个核心属性：

import csv
from BBlineup import Player

# 示例球员对象列表
team_players = [
    Player(name="王大锤", position="投手", jersey_number=12),
    Player(name="李铁蛋", position="捕手", jersey_number=7)
]

# 把对象转成字典列表，方便匹配表头
player_records = [
    {
        "姓名": p.name,
        "位置": p.position,
        "球衣号": p.jersey_number
    }
    for p in team_players
]

# 写入CSV
with open("baseball.csv", "w", newline="", encoding="utf-8") as csv_file:
    # 指定表头字段
    header = ["姓名", "位置", "球衣号"]
    writer = csv.DictWriter(csv_file, fieldnames=header)
    writer.writeheader()
    writer.writerows(player_records)

方案2：给Player类加序列化方法 #

在BBlineup.py的Player类里添加专门的方法，返回可直接写入CSV的结构，后续复用更方便：

# BBlineup.py
class Player:
    def __init__(self, name, position, jersey_number):
        self.name = name
        self.position = position
        self.jersey_number = jersey_number

    # 返回对应CSV列的属性列表
    def to_csv_row(self):
        return [self.name, self.position, self.jersey_number]

    # 或者返回字典，适配DictWriter
    def to_csv_dict(self):
        return {
            "姓名": self.name,
            "位置": self.position,
            "球衣号": self.jersey_number
        }

然后写入时直接调用这个方法：

import csv
from BBlineup import Player

team_players = [Player("王大锤", "投手", 12), Player("李铁蛋", "捕手", 7)]

# 用列表方式写入
with open("baseball.csv", "w", newline="", encoding="utf-8") as csv_file:
    writer = csv.writer(csv_file)
    writer.writerow(["姓名", "位置", "球衣号"])  # 写表头
    for player in team_players:
        writer.writerow(player.to_csv_row())

方案3：重载__str__方法（临时应急用） #

如果只是快速解决，可重载__str__让对象直接输出CSV格式的字符串，但这种方式不够灵活，后续修改属性得同步改方法：

class Player:
    # ... 原有初始化代码 ...
    def __str__(self):
        return f"{self.name},{self.position},{self.jersey_number}"

写入时要手动处理表头，还要注意属性里有逗号的情况（会破坏CSV结构，所以不推荐长期用）：

with open("baseball.csv", "w", encoding="utf-8") as csv_file:
    csv_file.write("姓名,位置,球衣号\n")
    for player in team_players:
        csv_file.write(f"{player}\n")

额外提醒 #

• 写入CSV时一定要指定encoding="utf-8"，避免Excel打开出现乱码
• 尽量用Python自带的csv模块处理写入，它会自动转义逗号、换行符这些特殊字符，比手动拼接字符串靠谱得多

内容的提问来源于stack exchange，提问作者kim