import logging.handlers if __name__ == '__main__': tempPath=os.path.split(sys.argv[0])#取文件名的路径。 if tempPath[0]=='':#文件名采用绝对路径,而是采用相对路径时,取工作目录下的路径 config_dir=os.getcwd()+os.sep else: config_dir=tempPath[0]+os.sep # set Logger Config log = logging.getLogger() log.setLevel(logging.DEBUG) h1 = logging.handlers.RotatingFileHandler(config_dir+'sql.log',maxBytes=2097152,backupCount=5) h1.setLevel(logging.INFO) f=logging.Formatter('%(message)s') h1.setFormatter(f) log.addHandler(h1) excelProxy=EasyExcel("D:\\temp\\room\\59901.xls") room_id='59901'#房间ID,需要手工更改. sql="insert into monitor_agent_info (agent_error_type,agent_no,term_id,term_code,node_id,company_id) values ('0','%s','0591%s','%s','0591','1');\ninsert into monitor_room_agent (term_id,room_id,agent_type) values ('0591%s','"+room_id+"','%s');" try: for iTuple in excelProxy.getRange('Sheet1',1,1,11,15): for position in iTuple: if isinstance(position,unicode): aData=position.split(';') if len(aData)<3: print aData else: log.info(sql,aData[1],aData[0],aData[0],aData[0],aData[2]) finally: log.info('commit;') excelProxy.close()