import openpyxl
import os

def xlsx_to_txt(file_path, output_dir="output", header_row=1):
    """
    將Excel文件內(nèi)容轉(zhuǎn)換為多個(gè)TXT文件
    
    參數(shù):
    file_path (str): Excel文件路徑
    output_dir (str): 輸出目錄，默認(rèn)為"output"
    header_row (int): 標(biāo)題行數(shù)，默認(rèn)為1
    """
    try:
        # 創(chuàng)建輸出目錄
        os.makedirs(output_dir, exist_ok=True)
        
        # 加載Excel工作簿
        workbook = openpyxl.load_workbook(file_path)
        sheet = workbook.active

        # 遍歷每一行
        for row_num, row in enumerate(sheet.iter_rows(values_only=True), start=1):
            if row_num > header_row:  # 跳過標(biāo)題行
                # 檢查序號(hào)列是否為空
                if row[0] is None:
                    print(f"警告：第{row_num}行缺少序號(hào)，已跳過")
                    continue
                    
                # 檢查內(nèi)容列是否為空
                if row[1] is None:
                    print(f"警告：第{row_num}行內(nèi)容為空，已跳過")
                    continue
                    
                # 清理文件名中的非法字符
                safe_filename = "".join(c for c in str(row[0]) if c.isalnum() or c in (' ', '_')).rstrip()
                if not safe_filename:
                    print(f"警告：第{row_num}行文件名無效，已跳過")
                    continue
                    
                # 寫入文件
                output_path = os.path.join(output_dir, f"{safe_filename}.txt")
                try:
                    with open(output_path, "w", encoding="utf-8") as txt_file:
                        txt_file.write(str(row[1]))
                    print(f"成功創(chuàng)建文件: {output_path}")
                except Exception as e:
                    print(f"錯(cuò)誤：無法寫入文件 {output_path} - {str(e)}")
                        
    except FileNotFoundError:
        print(f"錯(cuò)誤：文件 {file_path} 不存在！")
    except Exception as e:
        print(f"程序運(yùn)行出錯(cuò): {str(e)}")

# 示例調(diào)用
xlsx_to_txt('data.xlsx')

python3 test.py

content = '\n'.join([str(cell) for cell in row[1:] if cell])

filename = f"{row_num}_{safe_filename}"

from openpyxl.styles import numbers
if cell.number_format == numbers.FORMAT_DATE_XLSX22:
    # 處理日期格式

import logging
logging.basicConfig(filename='converter.log', level=logging.INFO)

import smtplib
# 將生成的txt文件作為附件自動(dòng)發(fā)送

import sqlite3
# 將轉(zhuǎn)換記錄存入數(shù)據(jù)庫(kù)

import logging
logging.basicConfig(filename='converter.log')