1
2
3
4
5
6
7
8
9
10
11
12
13
14
| # -*- 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]]
| print('SAMPLE dims:', ws.max_row, ws.max_column)
| for r in range(1, ws.max_row+1):
| vals = []
| for c in range(1, ws.max_column+1):
| v = ws.cell(r,c).value
| if v is not None:
| vals.append(f'c{c}={str(v)[:12]}')
| print(r, '|', ' '.join(vals))
|
|
