# -*- 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 '')