Python 实现Excel (XLS 或 XLSX) 与TXT文本格式互转

import os
import xlrd
import csv

# 将XLS/XLSX文件转换为TXT文本文件
def convert_xls_to_txt(input_file, output_file):
    if input_file.endswith('.xls'):
        book = xlrd.open_workbook(input_file, on_demand=True)
        sh = book.sheet_by_index(0)
    elif input_file.endswith('.xlsx'):
        book = xlrd.open_workbook(input_file)
        sh = book.sheet_by_index(0)

    with open(output_file, 'w', newline='', encoding='utf-8') as f:
        csw = csv.writer(f, delimiter='\t')
        for row_num in range(sh.nrows):
            csw.writerow(sh.row_values(row_num))

# 将TXT文本文件转换为XLSX文件
def convert_txt_to_xlsx(input_file, output_file):
    with open(input_file, 'r', newline='', encoding='utf-8') as f:
        reader = csv.reader(f, delimiter='\t')
        with open(output_file, 'w', newline='', encoding='utf-8') as f:
            writer = csv.writer(f)
            for row in reader:
                writer.writerow(row)

# 示例使用
convert_xls_to_txt('example.xlsx', 'example.txt')
convert_txt_to_xlsx('example.txt', 'example.xlsx')