pip install Spire.Xls.Free

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

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

def txt_to_csv_basic(txt_path, csv_path):
    # 1. 創(chuàng)建Workbook對(duì)象
    workbook = Workbook()
    # 2. 獲取第一張工作表
    worksheet = workbook.Worksheets[0]
    
    # 3. 讀取TXT文件內(nèi)容
    with open(txt_path, 'r', encoding='utf-8') as f:
        lines = f.readlines()
    
    # 4. 將TXT內(nèi)容寫入工作表
    row_index = 1  # Spire.XLS行索引從1開始
    for line in lines:
        # 去除換行符并按逗號(hào)分割
        row_data = line.strip().split(',')
        col_index = 1
        for cell_value in row_data:
            # 寫入單元格
            worksheet.Range[row_index, col_index].Text = cell_value
            col_index += 1
        row_index += 1
    
    # 5. 保存為CSV文件
    workbook.SaveToFile(csv_path, FileFormat.CSV)
    workbook.Dispose()
    print(f"基礎(chǔ)轉(zhuǎn)換完成！CSV文件已保存至：{csv_path}")

# 調(diào)用函數(shù)
if __name__ == "__main__":
    txt_file = "data.txt"
    csv_file = "output_basic.csv"
    txt_to_csv_basic(txt_file, csv_file)

姓名	年齡	城市	職業(yè)
張三	25	北京	程序員
李四	30	上海	產(chǎn)品經(jīng)理

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

def txt_to_csv_tab_separator(txt_path, csv_path):
    workbook = Workbook()
    worksheet = workbook.Worksheets[0]
    
    with open(txt_path, 'r', encoding='utf-8') as f:
        lines = f.readlines()
    
    row_index = 1
    for line in lines:
        row_data = line.strip().split('\t')  # 按制表符分割
        col_index = 1
        for cell_value in row_data:
            worksheet.Range[row_index, col_index].Text = cell_value
            col_index += 1
        row_index += 1
    
    workbook.SaveToFile(csv_path, FileFormat.CSV)
    workbook.Dispose()
    print(f"制表符分隔轉(zhuǎn)換完成！文件路徑：{csv_path}")

# 調(diào)用
txt_to_csv_tab_separator("data_tab.txt", "output_tab.csv")

# 僅修改讀取TXT的編碼參數(shù)
with open(txt_path, 'r', encoding='gbk') as f:  # 替換為gb2312/utf-8-sig（含BOM）
    lines = f.readlines()

import os

def batch_txt_to_csv(txt_folder, csv_folder):
    # 創(chuàng)建CSV文件夾（若不存在）
    if not os.path.exists(csv_folder):
        os.makedirs(csv_folder)
    
    # 遍歷TXT文件夾
    for file_name in os.listdir(txt_folder):
        if file_name.endswith(".txt"):
            txt_path = os.path.join(txt_folder, file_name)
            # 生成CSV文件名（替換后綴）
            csv_name = file_name.replace(".txt", ".csv")
            csv_path = os.path.join(csv_folder, csv_name)
            # 調(diào)用基礎(chǔ)轉(zhuǎn)換函數(shù)
            txt_to_csv_basic(txt_path, csv_path)
    
    print(f"批量轉(zhuǎn)換完成！所有CSV文件已保存至：{csv_folder}")

# 調(diào)用（轉(zhuǎn)換txt_files文件夾下所有TXT，保存到csv_files文件夾）
batch_txt_to_csv("txt_files", "csv_files")