Python实现Excel和TXT文件格式的转换

说明：只针对文件中的文字，Excel表格的样式等不随之转换，所以Excel转TXT再转Excel，得到的表格将为默认样式。

【1】Excel转TXT，代码如下：

import pandas

# 格式转换
def Excel_to_Txt(input_path, output_path):
    df = pandas.read_excel(input_path, header=None)
    print('开始写入txt文件')
    df.to_csv(output_path, header=None, sep=',', index=False) #sep指定分隔符，分隔单元格
    print('写入成功')

# 创建同路径同名TXT文件
def creat_txt(input_path):
    length = len(input_path)
    output_path = ''
    for i in range(length-1, -1,-1):
        if input_path[i] == '.':
            break
    for j in range(0, i+1):
        output_path = output_path + input_path[j]
    output_path = output_path + 'txt'
    # file = open(output_path,)
    return output_path


if __name__ == '__main__':
    input_path = r'C:\1-校级活动列表_1.xlsx'
    output_path = creat_txt(input_path)
    Excel_to_Txt(input_path, output_path)

【2】TXT转Excel：

import csv
import openpyxl

def Txt_to_Excel(input_path,output_path):
    wb = openpyxl.Workbook()
    ws = wb.worksheets[0]

    with open(input_path, 'rt', encoding="utf-8") as data:
        reader = csv.reader(data, delimiter=',')  # delimiter：分隔符
        for row in reader:
            ws.append(row)

    wb.save(output_path)


if __name__ == '__main__':
    output_path = r'C:\1-校级活动列表_1.xlsx'
    input_path = r'C:\1-校级活动列表.txt'