python 读取excel生成javaBean类

import openpyxl
import os

def generate_java_bean_class(excel_file, class_name):
    # 读取Excel文件
    workbook = openpyxl.load_workbook(excel_file)

    # 获取工作表对象
    sheet = workbook.active

    # 生成JavaBean类的字符串
    java_bean_str = f"public class {class_name} {{\n"
    for row in sheet.iter_rows():
        field = row[0].value
        desc = row[1].value
        # 生成属性和注释
        java_bean_str += f"    /**\n     * {desc}的设定\n     */\n"
        java_bean_str += f"    private String {field};\n\n"
        java_bean_str += f"    /**\n     * {desc}的取得\n     */\n"
        java_bean_str += f"    public String get{field[0].upper()}{field[1:]}() {{\n"
        java_bean_str += f"        return {field};\n    }}\n\n"
        java_bean_str += f"    /**\n     * {desc}的设定\n     */\n"
        java_bean_str += f"    public void set{field[0].upper()}{field[1:]}(String {field}) {{\n"
        java_bean_str += f"        this.{field} = {field};\n    }}\n\n"

    java_bean_str += "}"

    # 将JavaBean类的字符串写入文件
    java_file= f"{class_name}.java"
    if os.path.exists(java_file):
        os.remove(java_file)
    with open(java_file, "w", encoding="utf-8") as f:
        f.write(java_bean_str)
generate_java_bean_class("aa.xlsx","Example")