Python 2.7
IDE Pycharm 5.0.3
pyExcelerator 0.6.4.1

目的

將txt轉(zhuǎn)化為csv格式

準(zhǔn)備工作

安裝pyExcelerator包

• 推薦在cmd窗口使用pip install pyExcelerator
• 或者百度pyExcelerator github下載zip解壓后，cmd切換到解壓目錄，執(zhí)行輸入python setup.py install，還不明白就百度把，一抓一大把，不在贅述

接口代碼

首先新建一個(gè)py文件，我以txt2excel.py為例(csv之后直接另存為excel就行，主要是csv比較通用，這個(gè)名字隨便取，只要調(diào)用時(shí)候用到就可以了)，輸入以下內(nèi)容：

# -*- coding: utf-8 -*-
from pyExcelerator import *
import time
def txt2csv(readpath,writepath,delimiter="\t"):
    start_time = time.time()
    try:
        f = open(readpath)
        lines = f.readlines()
        w = Workbook()
        sheet1 = w.add_sheet("Sheet1")
        i = 0
        for line in lines:
            linesplist = line.strip().split(delimiter)
            j = 0
            for linesp in linesplist:
                sheet1.write(i,j,linesp.strip().decode('utf-8')) # 需要轉(zhuǎn)化才能存儲(chǔ)
                j += 1
            i +=1
        w.save(writepath) 
    except Exception as ex:
        print ex
    finally:
        end_time = time.time()
        print "Done! it costs %.2f sec"%(end_time-start_time)

# 測試使用
if __name__ == '__main__':
    readpath = "C:\\Users\\MrLevo\\Desktop\\AL_Toolbox\\datacombinlabel.txt"
    writepath = "C:\\Users\\MrLevo\\Desktop\\AL_Toolbox\\datacombinlabel.csv"
    txt2csv(readpath,writepath,"\t")

接口說明

txt2excel.txt2csv(readpath,writepath,delimiter="\t")
# readpath是需要轉(zhuǎn)換的txt路徑
# writepath是需要寫入的csv路徑
# delimiter是txt中的字符分割類型，如果是","那么直接另存為csv就可以，不用調(diào)用函數(shù)，如果是" "就是tab的制表分隔符，則需要用此函數(shù)了。在delimiter處寫"\t"就可以了

接口(函數(shù))調(diào)用實(shí)例

在同一工程目錄下的另一個(gè)py文件中只需要操作如下

import txt2excel # 導(dǎo)入包
txt2excel.txt2csv("C:\\Users\\MrLevo\\Desktop\\txt2csv.txt","C:\\Users\\MrLevo\\Desktop\\txt2csv.csv",",")

執(zhí)行效果

這里寫圖片描述