from openpyxl import load_workbook, Workbook
def read_tb(fullname):
# 打开存在的文件
wb = load_workbook(fullname)
# 选择选项卡
ws = wb.get_sheet_by_name("tenant_info")
# 获取所有行的数据便利
for r in ws.rows:
# 获取当前行的所有列数据
tb_rows = [i.value for i in r]
print tb_rows[1], tb_rows
def create_tb():
# 实例化
wb = Workbook()
# 激活 worksheet
ws = wb.active
# 添加表头
ws.append(['name', 'age', 'gender'])
data = [
{'name': 'zs', 'age': 18, 'gender': 'man'},
{'name': 'lh', 'age': 18, 'gender': 'woman'}
]
# 写入数据
for i in data:
ws.append([i['name'], i['age'], i['gender']])
# 保存实例
wb.save('./test_openpyxl.xlsx')