# -*- coding: utf-8 -*-
import openpyxl, glob, os

tmp = r'C:\Users\jcxiong\AppData\Local\Temp\ta_e2e_524cecf1'
docs = r'C:\Users\jcxiong\Documents\Codex\MyProject\trafficAudit\docs'

pairs = [
    ('gen_freight_turnover.xlsx', '生成_货运量周转量.xlsx'),
    ('gen_city_detail.xlsx', '生成_货运量分市州明细.xlsx'),
    ('gen_freight_rank.xlsx', '生成_货运量排名.xlsx'),
    ('gen_turnover_rank.xlsx', '生成_周转量排名.xlsx'),
]
for gen_name, sample_name in pairs:
    gen_path = os.path.join(tmp, gen_name)
    sglob = glob.glob(os.path.join(docs, sample_name))[0]
    wg = openpyxl.load_workbook(gen_path)
    ws = wg[wg.sheetnames[0]]
    wss = openpyxl.load_workbook(sglob)[openpyxl.load_workbook(sglob).sheetnames[0]]
    print(f'{gen_name}: dims {ws.max_row}x{ws.max_column} | sample: {wss.max_row}x{wss.max_column}')
    # compare row1 col1 and structure markers
    print('  gen R1:', ws.cell(1,1).value)
    print('  smp R1:', wss.cell(1,1).value)