Python-将txt文件转换成Excel

Excel 生成

import os
import xlwt


class TxtToExcel(object):
    def __init__(self, file_path):
        """
        初始化excel
        :param file_path:文件存放目录路径
        """
        self.file_path = file_path
        self.workbook = xlwt.Workbook(encoding='utf-8')
        self.worksheet = self.workbook.add_sheet('My Worksheet', cell_overwrite_ok=True)
        self.style = xlwt.XFStyle()  # 初始化样式
        self.font = xlwt.Font()  # 为样式创建字体
        self.font.name = 'Times New Roman'
        self.font.bold = True  # 黑体
        self.font.underline = True  # 下划线
        # self.font.italic = True  # 斜体字
        self.style.font = self.font  # 设定样式
        self.header = [</