pip install Spire.XLS.Free

import json
from spire.xls import *
from spire.xls.common import *

def simple_json_to_csv(json_path: str, csv_path: str) -> None:
    """
    簡單結(jié)構(gòu)JSON轉(zhuǎn)CSV（無嵌套）
    :param json_path: 輸入JSON文件路徑
    :param csv_path: 輸出CSV文件路徑
    """
    try:
        # 1. 讀取并解析JSON數(shù)據(jù)
        with open(json_path, 'r', encoding='utf-8') as f:
            json_data = json.load(f)
        
        # 校驗數(shù)據(jù)格式（必須是包含字典的列表）
        if not isinstance(json_data, list) or not all(isinstance(item, dict) for item in json_data):
            raise ValueError("JSON數(shù)據(jù)需為「包含字典的列表」格式")
        
        # 2. 提取表頭（去重）
        headers = []
        for item in json_data:
            for key in item.keys():
                if key not in headers:
                    headers.append(key)
        
        # 3. 初始化Excel工作簿和工作表
        workbook = Workbook()
        worksheet = workbook.Worksheets[0]
        
        # 4. 寫入表頭（第一行）
        for col_idx, header in enumerate(headers, start=1):
            worksheet.Range[1, col_idx].Text = header
        
        # 5. 寫入數(shù)據(jù)行（從第二行開始）
        for row_idx, item in enumerate(json_data, start=2):
            for col_idx, header in enumerate(headers, start=1):
                # 處理空值，避免KeyError
                cell_value = item.get(header, "")
                worksheet.Range[row_idx, col_idx].Text = str(cell_value)
        
        # 6. 保存為CSV并釋放資源
        worksheet.SaveToFile(csv_path, ",", Encoding.get_UTF8())
        workbook.Dispose()
        print(f"轉(zhuǎn)換完成！CSV文件路徑：{csv_path}")
    
    except Exception as e:
        print(f"轉(zhuǎn)換失敗：{str(e)}")

# 測試調(diào)用
if __name__ == "__main__":
    # 示例test.json內(nèi)容：
    # [{"name":"張三","age":25,"city":"北京"},{"name":"李四","age":30,"city":"上海"}]
    simple_json_to_csv("test.json", "simple_result.csv")

import json
from spire.xls import *
from spire.xls.common import *

def flatten_dict(nested_dict: dict, parent_key: str = '', sep: str = '_') -> dict:
    """
    遞歸扁平化嵌套字典
    :param nested_dict: 待扁平化的嵌套字典
    :param parent_key: 父鍵名（遞歸使用）
    :param sep: 鍵名分隔符（如info_age）
    :return: 扁平化后的單層字典
    """
    items = []
    for k, v in nested_dict.items():
        new_key = f"{parent_key}{sep}{k}" if parent_key else k
        if isinstance(v, dict):
            # 遞歸處理嵌套層級
            items.extend(flatten_dict(v, new_key, sep).items())
        else:
            items.append((new_key, v))
    return dict(items)

def nested_json_to_csv(json_path: str, csv_path: str) -> None:
    """
    嵌套結(jié)構(gòu)JSON轉(zhuǎn)CSV
    :param json_path: 輸入JSON文件路徑
    :param csv_path: 輸出CSV文件路徑
    """
    try:
        # 1. 讀取并解析JSON
        with open(json_path, 'r', encoding='utf-8') as f:
            json_data = json.load(f)
        
        # 2. 扁平化所有嵌套字典
        flattened_data = []
        for item in json_data:
            flattened_item = flatten_dict(item)
            flattened_data.append(flattened_item)
        
        # 3. 提取表頭（扁平化后的鍵）
        headers = []
        for item in flattened_data:
            for key in item.keys():
                if key not in headers:
                    headers.append(key)
        
        # 4. 初始化工作簿并寫入數(shù)據(jù)（同基礎(chǔ)場景）
        workbook = Workbook()
        worksheet = workbook.Worksheets[0]
        
        # 寫入表頭
        for col_idx, header in enumerate(headers, start=1):
            worksheet.Range[1, col_idx].Text = header
        
        # 寫入扁平化數(shù)據(jù)
        for row_idx, item in enumerate(flattened_data, start=2):
            for col_idx, header in enumerate(headers, start=1):
                cell_value = item.get(header, "")
                worksheet.Range[row_idx, col_idx].Text = str(cell_value)
        
        # 保存并釋放資源
        worksheet.SaveToFile(csv_path, ",", Encoding.get_UTF8())
        workbook.Dispose()
        print(f"嵌套JSON轉(zhuǎn)換完成！CSV文件路徑：{csv_path}")
    
    except Exception as e:
        print(f"轉(zhuǎn)換失?。簕str(e)}")

# 測試調(diào)用
if __name__ == "__main__":
    # 示例nested_test.json內(nèi)容：
    # [{"name":"張三","info":{"age":25,"job":{"title":"工程師"}}},{"name":"李四","info":{"age":30,"job":{"title":"產(chǎn)品經(jīng)理"}}}]
    nested_json_to_csv("nested_test.json", "nested_result.csv")

cell_value = str(cell_value).replace('\n', ' ').replace('\r', ' ').replace('\t', ' ')