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)