1
2
3
4
5
6
7
8
9
| # -*- coding: utf-8 -*-
| import openpyxl, os
| tmp = r'C:\Users\jcxiong\AppData\Local\Temp\ta_e2e_524cecf1'
| wb = openpyxl.load_workbook(os.path.join(tmp, 'gen_freight_rank.xlsx'))
| ws = wb[wb.sheetnames[0]]
| for r in range(1, ws.max_row+1):
| v = ws.cell(r,1).value
| v2 = ws.cell(r,2).value
| print(r, '|', str(v)[:24] if v is not None else '', '|', str(v2)[:10] if v2 is not None else '')
|
|
