python处理excel文档作为配置文件

#!/usr/bin/env python # -*- coding: utf-8 -*- import xlrd import sys import time def usage(): print "This Program need 4 parameters including command itself:i/n/tconfigfile is configfile format .xls/n/tparameter2 is test environment/n/tparameter3 is testcase/n/nFor Example :/n/tcommand configfile 0 3/n/tcommand configfile 1 5/n/tcommand configfile 0 5/n/nEditor and Programmer:/n/n" sys.exit() def column_num(i): columntypes = sheet_0.col_types(i) column_list_temp = [] # print len(columntypes) for j in range(len(columntypes)): if columntypes[j] == 1 or columntypes[j] == 2: column_list_temp.append(j) column_list_temp.append(sheet_0.nrows) return column_list_temp def action_pro(str, i): print 'Action %s Times %d is running ...'%(str, i) def case_pro(case_str): # times_act = int(case_str.split(',')[1]) for i in range(int(case_str.split(',')[1])): # print case_str.split(',')[0] try: action_pro(ca