python 讀取txt文件，將內容寫入excel表格

# -*- coding: UTF-8 -*-
import os
import time

import openpyxl as openpyxl
Parser_version = 'version_1.0'
print Parser_version
items = os.listdir(".")
w = openpyxl.Workbook()
table = w.create_sheet(title="password")#在將寫的文件建立sheet


afteritems = os.listdir(".")
for i in range(len(afteritems)):
    if os.path.isfile(afteritems[i]) and afteritems[i].startswith('fileName.txt'):
        file_object = open(afteritems[i], "rU")
        for (num, line) in enumerate(file_object):
            print "第 %d 行:" % (num) +line
            #讀取每一行的內容，根據我的內容及需求將內容寫入excelName表格中
            ssid_pass = line.split('        ')
            ssid = ssid_pass[0].split(":")
            password = ssid_pass[1].split(":")
            table.cell(num + 1, 1, ssid[1]) #num + 1 表示第幾行，1 表示第幾列
            table.cell(num + 1, 2, password[1])
        break
w.save(time.strftime('%Y_%m_%d_%H_%M_%S', time.localtime(time.time())) + " excelName.xls")#根據時間來保存文件名