def init(file):
'''解析excel文件用例'''
log.info('解析excel文件数据')
cases_list=[]
try:
module_list=open_excel.excel_table_by_index(file)
except Exception, e:
print e
log.error('%s文件打开失败'%file)
def init_sqlfield(file):
sqlfield=[]
try:
field_list=open_excel.excel_table_by_index(file)
for i in field_list:
if i['VERIFY'] == 'y' or i['VERIFY'] =='Y':
i['SQLCMD'] = field_list[1]['SQLCMD']
i['DestroyData'] = field_list[1]['DestroyData']
#i['FIELD1_VALUE'] = field_list[1]['field1_value']
sqlfield.append(i)
except Exception, e:
print e
log.error('%s'%e)
