python-excel操作-openpyxl（一）

# 1、引入openpyxl模块中的load_workbook和workbook
from openpyxl import load_workbook
from openpyxl import workbook

# 2、打开excel表
wb = load_workbook('test.xlsx')

# 3、定位worksheet
# 返回第一张表
# ws = wb.active
# sheet表名定位
ws = wb['Sheet1']
# 4、定位cell
# 方法1
# one_cell = ws.cell(row=1, column=2).value
# print(one_cell)
# 方法2
# iter_rows 返回一个生成器，由每一行数据构成的元祖
# for row_tuple in ws.iter_rows(min_row=2):
#     for one_cell in row_tuple:
#         data = one_cell.value
for row_tuple in ws.iter_rows(min_row=2, values_only=True):
    data = row_tuple
    print(data)

转载于:https://my.oschina.net/yyqkz/blog/3046931