# -*- 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(1, ws.max_row+1):
|
vals = [str(ws.cell(r,c).value)[:12] if ws.cell(r,c).value is not None else '' for c in range(1, 6)]
|
print(r, '|', ' | '.join(vals))
|
