import json, urllib.request
from openpyxl import load_workbook

TOKEN = open("/tmp/m365_token.txt").read().strip()
DRIVE = "b!d79PuNE4sUikf8oSJfQTya8V8kCziUlNt_1sDq_4zl5mehqe3GKmS4y-z5nxXbDB"
ITEM = "01QCTU7EN3BTFEVE5IFJBKQUIJTUYUSCJJ"
url = f"https://graph.microsoft.com/v1.0/drives/{DRIVE}/items/{ITEM}/content"
req = urllib.request.Request(url, method="GET")
req.add_header("Authorization", f"Bearer {TOKEN}")
data = urllib.request.urlopen(req, timeout=120).read()
open("/tmp/Reactivations_verify.xlsx","wb").write(data)
wb = load_workbook("/tmp/Reactivations_verify.xlsx")
print("VERIFY sheets:", wb.sheetnames)
ws2 = wb["Active No-Followup"]
print("VERIFY Sheet2 header:", [c.value for c in ws2[1]])
print("VERIFY Sheet2 data rows:", ws2.max_row-1)
print("VERIFY Sheet1 data rows:", wb[wb.sheetnames[0]].max_row-1)
assert ws2.max_row-1 > 0, "Sheet 2 has zero data rows!"
print("VERIFY PASS: Sheet 2 row count > 0")