python处理excel的模块有哪些_Python常用模块-处理excell

处理excell的包

xlrd  读取excell

xlwt 写入excell

xlutils excell高级操作工具

一、xlrd

用来读取excel文件内容

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)

标签：sheet,Python,excell,模块,xlrd,password,data,row

来源： https://www.cnblogs.com/wc89/p/12067120.html