首选展示一下txt文件
转变为excel文件如下:
具体代码如下:
import xlwt
txtname = 'baifenbi1.txt'
excelname = '2.xlsx'
fopen = open(txtname, 'r')
lines = fopen.readlines()
file = xlwt.Workbook(encoding='utf-8', style_compression=0)
#新建一个sheet
sheet = file.add_sheet('data')
i = 0
for line in lines:
line = line.strip('\n')
line = line.split(',')
company_num = line[0]
date = line[1]
baifenbi = line[2]
# print(company_num)
# print(date)
# print(baifenbi)
# print(type(company_num))
sheet.write(i, 0, company_num)
sheet.write(i, 1, date)
sheet.write(i, 2, baifenbi)
i = i + 1
file.save(excelname)