openpyxl读取一个sheet的所有行数据可以用rows属性,官方文档如下:
If you need to iterate through all the rows or columns of a file, you can instead use the Worksheet.rows property:
sheet的rows属性返回的是一个生成器,如下:
# -*- coding: utf-8 -*-
from openpyxl import load_workbook
wb = load_workbook('test.xlsx',data_only=True)
for sheet in wb:
sheet_name = sheet.title
data_all = sheet.rows
print('sheet名:',sheet_name)
print(data_all)
sheet名: 北京
sheet名: 上海
sheet名: 杭州
可以直接遍历生成器也可以使用tuple将生成器变为元组来输出行:
# -*- coding: utf-8 -*-
from openpyxl import load_workbook
wb = load_workbook('test.xlsx',data_only=True)
for sheet in wb:
sheet_name = sheet.title
data_all = sheet.rows
print('sheet名:',sheet_name)
data_tuple = tuple(data_all)
for row in data_tuple:
print(row)
sheet名: 北京
(, )
(, )
(, )
(, )
(, )
(, )
(, )
sheet名: 上海
(, )
(, )
(, )
(, )
(, )
(, )
(, )
(, )
(, )
(, )
(, )
sheet名: 杭州
(, )
(, )
(, )
(, )
(, )
(, )
(, )
(, )
(, )
(, )
(, )
输出元格的数据,需要value属性:
# -*- coding: utf-8 -*-
from openpyxl import load_workbook
wb = load_workbook('test.xlsx',data_only=True)
for sheet in wb:
sheet_name = sheet.title
data_all = sheet.rows
print('sheet名:',sheet_name)
data_tuple = tuple(data_all)
for row in data_tuple:
print('===一行数据如下===:')
for cell in row:
value = cell.value
print(value)
sheet名: 北京
===一行数据如下===:
贡院6号
https://bj.5i5j.com/xiaoqu/117460.html
===一行数据如下===:
万年花城二期
https://bj.5i5j.com/xiaoqu/369118.html
===一行数据如下===:
铁医新楼
https://bj.5i5j.com/xiaoqu/428075.html
===一行数据如下===:
百万庄大街乙21号楼
https://bj.5i5j.com/xiaoqu/14042.html
===一行数据如下===:
观澳园
https://bj.5i5j.com/xiaoqu/3464.html
===一行数据如下===:
天鹅湾南区
https://bj.5i5j.com/xiaoqu/10522.html
===一行数据如下===:
报国寺1号院
https://bj.5i5j.com/xiaoqu/6250.html
sheet名: 上海
===一行数据如下===:
静安豪景苑
https://sh.5i5j.com/xiaoqu/79364.html
===一行数据如下===:
新泾苑
https://sh.5i5j.com/xiaoqu/138741.html
===一行数据如下===:
兆嘉苑
https://sh.5i5j.com/xiaoqu/367631.html
===一行数据如下===:
天山怡景苑
https://sh.5i5j.com/xiaoqu/385850.html
===一行数据如下===:
金星绿苑
https://sh.5i5j.com/xiaoqu/390212.html
===一行数据如下===:
申晖小区
https://sh.5i5j.com/xiaoqu/436536.html
===一行数据如下===:
共康四村
https://sh.5i5j.com/xiaoqu/197400.html
===一行数据如下===:
崧泽华城青湖苑
https://sh.5i5j.com/xiaoqu/377290.html
===一行数据如下===:
新昌里公寓
https://sh.5i5j.com/xiaoqu/47394.html
===一行数据如下===:
建国西路158弄
https://sh.5i5j.com/xiaoqu/125420.html
===一行数据如下===:
蔷薇七村
https://sh.5i5j.com/xiaoqu/388767.html
sheet名: 杭州
===一行数据如下===:
复兴城市家园
https://hz.5i5j.com/xiaoqu/100000000001038.html
===一行数据如下===:
木材新村
https://hz.5i5j.com/xiaoqu/100000000004309.html
===一行数据如下===:
万寿亭街
https://hz.5i5j.com/xiaoqu/100000000002688.html
===一行数据如下===:
瓶窑镇凤溪路
https://hz.5i5j.com/xiaoqu/100000000000367.html
===一行数据如下===:
孝子坊
https://hz.5i5j.com/xiaoqu/100000000002902.html
===一行数据如下===:
永和坊
https://hz.5i5j.com/xiaoqu/100000000002147.html
===一行数据如下===:
教工路131号
https://hz.5i5j.com/xiaoqu/100000000001423.html
===一行数据如下===:
星星港湾琴海居
https://hz.5i5j.com/xiaoqu/100000000005718.html
===一行数据如下===:
文二路98号
https://hz.5i5j.com/xiaoqu/100000000001269.html
===一行数据如下===:
龙悦湾
https://hz.5i5j.com/xiaoqu/100000000006161.html
===一行数据如下===:
意盛花苑
https://hz.5i5j.com/xiaoqu/100000000002797.html