#!/usr/bin/env python3
"""比較「2026年加班登記表（選擇補休）」和「2026年加班登記表」"""
from google.oauth2 import service_account
from googleapiclient.discovery import build

SPREADSHEET_ID = '1Y708RZgZHL3Gqah9ujiw5brMuxAoW3RFl0txfXq8qrE'
creds = service_account.Credentials.from_service_account_file(
    'service_account_key.json',
    scopes=['https://www.googleapis.com/auth/spreadsheets']
)
service = build('sheets', 'v4', credentials=creds)

def read_sheet(name, range_):
    res = service.spreadsheets().values().get(
        spreadsheetId=SPREADSHEET_ID,
        range=f'{name}!{range_}'
    ).execute()
    return res.get('values', [])

# 讀兩張表
manual = read_sheet('2026年加班登記表（選擇補休）', 'A1:H100')
auto   = read_sheet('2026年加班登記表', 'A1:H100')

print('=== 手算表（選擇補休）共', len(manual), '列 ===')
for i, r in enumerate(manual):
    print(f"  row{i+1}: {r}")

print('\n=== 自動填表 共', len(auto), '列 ===')
for i, r in enumerate(auto):
    print(f"  row{i+1}: {r}")