python 打开excl 格式 openpyxl
- 编程
- 2022-08-23
- 940
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)
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)
发表评论