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