import xlrd import sys,time data = xlrd.open_workbook("C:\Users\Administrator\Desktop\\new1.xlsx") table = data.sheets()[0] cols = table.ncols rows = table.nrows for i in range(cols): fields = table.col_values(i) [appname,packet] = fields[:2] # print appname,packet for word in fields[2:]: sys.stdout.flush() # print "1:"+repr(word), if len(word.strip())>0: #print packet+"|"+word#有时候丟数据 print packet,"|",word#正常 time.sleep(0.01) sys.stdout.flush()