copywriting_production/docs/gpt/excel_writer_usage.py

from src.excel_tools.excel_writer import ExcelWriter
from src.models.asin_model import TrafficKeywordModel, ProductInfoModel
import json
input_path = r'G:\code\amazone\copywriting_production\output\page\debug\B0B658JC22_extract.json'

# 示例数据加载
with open(input_path, encoding='utf-8') as f:
    data = json.load(f)

# 调用示例
success = ExcelWriter.process_json_to_excel(
    data=data,            # 输入数据
    asin="B0B658JC22",    # 产品ASIN编号
    template_path=r"G:\code\amazone\copywriting_production\output\3月新品-文案制作-temp.xlsx",  # Excel模板路径
    output_path=r"G:\code\amazone\copywriting_production\output\3月新品-文案制作-temp.xlsx"     # 输出文件路径
)

if success:
    print("Excel文件生成成功！")
else:
    print("文件生成失败，请检查日志")