convert_excel.py

#!/opt/rh/python33/root/usr/bin/python3

import openpyxl
import sys, os
import re

'mv3wexaa01prvc2 H:\ 1367257 510976 01/01/2016 11:44:18 PM 01/02/2016 12:40:26 PM full 12:56:8 46568 10.973'

def creat_list_list (fname):
	elem_list = []
	list_list = []
	fd = open (fname, 'r')
	for i in ["Client", "Saveset", "NFiles", "Size", "Start Time", "End Time", "Level", "Duration", "Total second","Rate"]:
		elem_list.append (i)
	list_list.append(elem_list)
	elem_list = []
	for i in fd:
		m = re.search (r'''(\w+)\s+					#client
				([\w:\\:?/-]+)\s+					#saveset
				(\d+)\s+					#number of files
				(\d+)\s+					#size
				(\d+/\d+/\d+\s\d+:\d+:\d+\s[P|A]M)\s+		#start time/date
				(\d+/\d+/\d+\s\d+:\d+:\d+\s[P|A]M)\s+		#end time/date
				(\w+)\s+					#level
				(\d+:\d+:\d+)\s+				#duration
				(\d+)\s+					#total seconds
				([\.\d]+)					#rate
				''', i, re.X)
		if m:
			for j in range(1, 11):
				if j == 3 or j == 4 or j == 9:
					elem_list.append(int(m.group(j)))
				elif j == 10:
					elem_list.append(float(m.group(j)))
				else:
					elem_list.append(m.group(j))
			list_list.append(elem_list)
			elem_list = []
	return list_list
def to_excel (list_name, wbname):
	wb = openpyxl.Workbook()
	sh = wb.get_sheet_by_name('Sheet')
	for i in list_name:
		sh.append (i)
	wb.save (wbname)

def main ():
	if len(sys.argv) != 3:
		print ("Usage: %s [TEXT file name] [EXCEL file name] " % (sys.argv[0]))
		sys.exit (1)
	filename = sys.argv[1]
	output_filename = sys.argv[2]
	list_list = creat_list_list (filename)
	to_excel (list_list, output_filename)
if __name__ == '__main__':
	main ()