Python常用模块-处理excell

处理excell的包

• xlrd  读取excell
• xlwt 写入excell
• xlutils excell高级操作工具

一、xlrd

用来读取excel文件内容

# http://www.360doc.com/content/19/0303/20/60149846_818870157.shtml
import xlrd
import pprint

book = xlrd.open_workbook('../data/主机信息.xlsx')
sheet = book.sheet_by_name('服务器信息')

demo_data = [
    {'ip': {
        'user': 'root',
        'port': 22,
        'password': '123456'
    }}
]


data = []
for i in range(1, sheet.nrows):
    row = sheet.row_values(i)
    manager_ip = row[0]
    user = row[2]
    port = int(row[1])
    password = row[3]
    p_type = sheet.cell(i, 3).ctype
    if p_type == 2:
        password = int(password)
    host_dic = {
        manager_ip: {
            'user': user,
            'port': port,
            'password': password
        }
    }
    data.append(host_dic)

pprint.pprint(data)