将txt转化为excel

最新推荐文章于 2024-07-18 15:42:44 发布

lyf1126209324

最新推荐文章于 2024-07-18 15:42:44 发布

阅读量2.2k

点赞数 2

分类专栏： python

本文链接：https://blog.csdn.net/lyf1126209324/article/details/73920590

版权

python 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

#-*-coding:utf-8-*-

from openpyxl import Workbook  #python读取excel表格
from openpyxl import load_workbook  #python读取excel表格，处理excel数据多使用Python openpyxl这个包
import os #导入os模块
 
global_result_txt_in = '.\\output.txt'
global_output_excel = r'.\Txt2Excel.xlsx'

wb = Workbook()
#ws=wb.create_sheet()
ws=wb.worksheets[0]
ws.title="Txt2Excel"
file1 = open(global_result_txt_in, mode='r', encoding="gbk") #当前输出为gbk,后期改为utf8
lines = file1.readlines()
lineNum = len(lines)
print(lineNum)
i = 0
j=1
querylines = ''
line = ''
#逐行扫描写入
while i < lineNum:
     print( i )
     if lines[i] != '\n':
          line = lines[i]
          querylines = querylines + line
     else:
          ws.cell(row = j, column = 1).value=querylines
          querylines = ""
          j=j+1
     i = i + 1
wb.save( global_output_excel )
print("OK!")