# -*- coding: utf-8 -*-
import openpyxl, glob, os
docs = r'C:\Users\jcxiong\Documents\Codex\MyProject\trafficAudit\docs'
f = glob.glob(os.path.join(docs, '模板_交企统H203-2表_道路货物运输月度生产情况.xlsx'))[0]
ws = openpyxl.load_workbook(f)[openpyxl.load_workbook(f).sheetnames[0]]
empty = []
for r in range(2, ws.max_row+1):
    name = ws.cell(r, 3).value
    code = ws.cell(r, 2).value
    if name is None or str(name).strip() == '':
        empty.append((r, 'name empty', code))
    elif code is None or str(code).strip() == '':
        empty.append((r, 'code empty', name))
print('rows with missing name/code:', empty)
print('max_row:', ws.max_row, '=> data rows:', ws.max_row - 1)