1 #!/usr/bin/env python 2 #coding:utf-8 3 import xlrd,os,datetime 4 5 data=xlrd.open_workbook(u"\\\\10.25.1.9\\Dpt_IT\\基础架构部\\服务器_系统\\3.配置信息\\IDC设备配置信息列表.xlsx") #打开excel文件,Windows下 6 table=data.sheet_by_index(0) #通过索引选择第一个sheet 7 nrows=table.nrows #行数 8 ncols=table.ncols #列数 9 10 item=["Item","HostName","IP","外部IP","域名","环境","描述","类型","基础运维负责人","应用管理员","位置","设备类型","硬件厂商","型号","SN","CPU","DISK","MEM","OS","APP","开放端口","备注","日期"] 11 key=[chr(i) for i in range(65,88)] #生产列名A,B,C,D,E...W 12 choice=dict(zip(key,item)) 13 ncols_dir=dict(zip(key,range(len(choice)))) 14 data_list=[] 15 for i in range(5,nrows): 16 data_list.append(table.row_values(i)) #生成每行数据组成的列表 17 18 def show(chosen): 19 chosen=chosen.split(',') 20 chosen=[i.upper() for i in chosen] 21 print "*"*len(chosen)*50 22 for i in range(4,nrows): 23 for j in chosen: 24 ctype=table.cell(i,ncols_dir[j]).ctype 25 if ctype == 3: 26 date_value=xlrd.xldate_as_tuple(table.cell(i,ncols_dir[j]).value,data.datemode) 27 date_value=datetime.date(*date_value[:3]).strftime("%Y/%m/%d") 28 print "%-50s" % date_value, 29 elif ctype == 0: 30 print "%-50s" % "NULL", 31 else: 32 print "%-50s" % table.cell(i,ncols_dir[j]).value, #打印每行指定列的元素 33 print 34 35 while True: 36 print ''' 37 ****************************************** 38 1.query 39 2.see all 40 3.exit 41 ''' 42 print 43 chosen_num=raw_input("Pls enter ur choice:") 44 #类型: 0 empty,1 string, 2 number, 3 date, 4 boolean, 5 error 45 if chosen_num == '1': 46 for i,j in sorted(choice.items()): 47 print i+"--->"+j 48 chosen=raw_input("Pls enter ur choice(以,分隔,不区分大小写):") 49 show(chosen) 50 elif chosen_num == '2': 51 chosen=','.join(key) 52 show(chosen) 53 elif chosen_num == '3': 54 exit(0) 55 elif chosen_num == '': 56 pass 57 else: 58 pass