场景:txt文档有标识符分割每行数据,行数据之间以制表符分割
代码:
#! /usr/bin/python
# encoding:utf-8
from pyExcelerator import *
def to_excel(fpath):
# 读取参数路径文件
f=file(fpath,'r')
line = f.read()
# 创建workbook
w = Workbook()
# 增加一个sheet页'Sheet1'
ws = w.add_sheet('Sheet1')
# 以'*'分割,获取每行数据
arr_line = line[1:].split('*')
for i in range(len(arr_line)):
# 对行数据进行遍历,获取行数据元素元组
arr_cell = arr_line[i].split('\t')
for j in range(len(arr_cell) - 1):
# 写入数据
ws.write(i, j, arr_cell[j])
print '写入(%i,%i):%s' % (i, j, arr_cell[j])
fpath_excel=fpath.replace('txt','xls')
w.save(fpath_excel)
# 创建txt文件
f = file('D:/txt-to-excel.txt', 'w')
for i in range(1, 6):
# 写入数据,每行数据以'*'开头,以'\n'结