# mypath should be the complete path for the directory containing the input text files
mypath = raw_input("Please enter the directory path for the input files: ")

from os import listdir
from os.path import isfile, join
textfiles = [ join(mypath,f) for f in listdir(mypath) if isfile(join(mypath,f)) and '.txt' in  f]

def is_number(s):
    try:
        float(s)
        return True
    except ValueError:
        return False

import xlwt
import xlrd

style = xlwt.XFStyle()
style.num_format_str = '#,###0.00'

for textfile in textfiles:
    f = open(textfile, 'r+')
    book = xlwt.Workbook()
    ws = book.add_sheet('First Sheet')  # Add a sheet
    data = f.readlines()  # read all lines at once
    for i in range(len(data)):
        row = data[i].split('[')

        for j in range(len(row)):
            ws.write(i, j, row[j])  # Write to cell i, j

        i+=1
    book.save(textfile.replace('.txt', '.xls'))
    f.close()