python-excel文件读取

excel 文件读取

xlrd xlwt pandas openpyxl

openpyxl 操作excel

文件：bb.xlsx

import openpyxl

# 加载工作簿
wb = openpyxl.load_workbook(r'./data/bb.xlsx')
print(wb)
# 指定sheet表单
sheet = wb['Sheet1']
print(sheet)
# 拿单元格 值
id1=sheet['A1'].value
print(id1)
name = sheet.cell(row =1,column=2).value
print(name)

# 拿到所有值 如果没有值就会是none
# 方法1
values = sheet.values
for i in values:
# 放在元组中
print(i)

# 方法2
rows = sheet.max_row
print(rows)
for i in range(1,rows+1):
id = sheet.cell(row =i,column=1).value
name = sheet.cell(row =i,column=2).value
age = sheet.cell(row =i,column=3).value
sex = sheet.cell(row =i,column=4).value
print(id,name,age,sex)

# 读取所有的sheet
sheets = wb.sheetnames
print(sheets)
# 读取所有的表单，
for i in sheets:
print(i)
for j in wb[i].values:
print(j)

# 保存数据在表单
sheet.cell(row=1,column=5).value='结果'
wb.save('./data/bb.xlsx')