1
2
3
4
5
6
7
8
9
| # -*- coding: utf-8 -*-
| import openpyxl, glob, os
| docs = r'C:\Users\jcxiong\Documents\Codex\MyProject\trafficAudit\docs'
| f = glob.glob(os.path.join(docs, '生成_货运量周转量.xlsx'))[0]
| wb = openpyxl.load_workbook(f)
| ws = wb[wb.sheetnames[0]]
| for r in range(17, 25):
| vals = [str(ws.cell(r,c).value)[:10] if ws.cell(r,c).value is not None else '' for c in range(1, 10)]
| print(r, '|', ' | '.join(vals))
|
|
