pip install Spire.XLS.Free

姓名,年齡,城市,職業(yè)
張三,28,北京,工程師
李四,32,上海,產(chǎn)品經(jīng)理
王五,25,廣州,設(shè)計(jì)師

from spire.xls import *
from spire.xls.common import *
import xml.etree.ElementTree as ET
from xml.dom import minidom

def csv_to_custom_xml(csv_path, xml_path):
    """
    手動(dòng)構(gòu)建自定義結(jié)構(gòu)的XML（靈活適配業(yè)務(wù)需求）
    :param csv_path: 輸入CSV文件路徑
    :param xml_path: 輸出XML文件路徑
    """
    try:
        # 1. 初始化Workbook對(duì)象，加載CSV文件
        workbook = Workbook()
        # 設(shè)置加載CSV的編碼（根據(jù)實(shí)際情況調(diào)整，如gbk、utf-8）
        workbook.LoadFromFile(csv_path, ",", 1, 1)
        
        # 2. 獲取第一個(gè)工作表（CSV加載后默認(rèn)在第一個(gè)Sheet）
        worksheet = workbook.Worksheets[0]
        
        # 3. 獲取CSV的總行數(shù)和總列數(shù)（排除空行）
        row_count = worksheet.LastRow
        col_count = worksheet.LastColumn
        
        # 4. 構(gòu)建XML根節(jié)點(diǎn)
        root = ET.Element("DataRecords")
        
        # 5. 遍歷CSV數(shù)據(jù)（第一行為表頭，從第二行開(kāi)始是數(shù)據(jù)）
        headers = []
        for col in range(1, col_count + 1):
            # 獲取表頭文本
            header_text = worksheet.Range[1, col].Text
            headers.append(header_text)
        
        # 遍歷數(shù)據(jù)行
        for row in range(2, row_count + 1):
            # 創(chuàng)建子節(jié)點(diǎn)（每個(gè)數(shù)據(jù)行對(duì)應(yīng)一個(gè)Record節(jié)點(diǎn)）
            record = ET.SubElement(root, "Record")
            # 遍歷當(dāng)前行的列
            for col in range(1, col_count + 1):
                # 獲取單元格值
                cell_value = worksheet.Range[row, col].Text
                # 創(chuàng)建列節(jié)點(diǎn)，節(jié)點(diǎn)名=表頭，節(jié)點(diǎn)值=單元格內(nèi)容
                field = ET.SubElement(record, headers[col - 1])
                field.text = cell_value
        
        # 6. 保存XML文件
        tree = ET.ElementTree(root)
        tree.write(custom_xml_file, encoding="utf-8", xml_declaration=True)
        
        print(f"自定義XML轉(zhuǎn)換成功！文件已保存至：{xml_path}")
        
    except Exception as e:
        print(f"轉(zhuǎn)換失?。簕str(e)}")
    finally:
        # 釋放Workbook資源
        workbook.Dispose()

# 調(diào)用自定義XML轉(zhuǎn)換函數(shù)
if __name__ == "__main__":
    csv_file = "data.csv"
    custom_xml_file = "custom_data.xml"
    csv_to_custom_xml(csv_file, custom_xml_file)

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

def csv_to_open_xml(csv_path, xml_path):
    """
    導(dǎo)出Open XML格式（兼容Excel等辦公軟件）
    :param csv_path: 輸入CSV文件路徑
    :param xml_path: 輸出Open XML文件路徑
    """
    try:
        # 1. 初始化Workbook對(duì)象，加載CSV文件
        workbook = Workbook()
        # 設(shè)置CSV編碼和分隔符
        workbook.LoadFromFile(csv_path, ",", 1, 1)
        
        # 2. 導(dǎo)出為Open XML格式
        workbook.SaveAsXml(xml_path)
        
        print(f"Open XML導(dǎo)出成功！文件已保存至：{xml_path}")
        
    except Exception as e:
        print(f"導(dǎo)出失敗：{str(e)}")
    finally:
        # 釋放Workbook資源
        workbook.Dispose()

# 調(diào)用Open XML導(dǎo)出函數(shù)
if __name__ == "__main__":
    csv_file = "data.csv"
    open_xml_file = "open_data.xml"
    csv_to_open_xml(csv_file, open_xml_file)