python 打开excl 格式 openpyxl
- 编程
- 2022-08-23
- 1284
from openpyxl import load_workbook
wb = load_workbook(r'ua\ua.xlsx', read_only=True, data_only=True)
ws = wb['Sheet1']
for row in ws.rows:
for data in row:
print(data.value)
print('*' * 90)
发表评论