#!/usr/bin/env python3

from google.oauth2 import service_account
from googleapiclient.discovery import build

def read_sheet_data():
    """
    讀取指定分頁的資料結構
    """
    SPREADSHEET_ID = '1FFRR9i5wFSNjNqLjVN7xWI74qV7SqjJncQHyEyzmtAA'
    
    # 要讀取的工作表
    sheet_names = [
        'No.08_2025.05（沒有加班時段）',
        'No.16（較完整者）_2025.09', 
        'No.16（較完整者）_2025.10'
    ]
    
    try:
        creds = service_account.Credentials.from_service_account_file(
            'service_account_key.json',
            scopes=['https://www.googleapis.com/auth/spreadsheets.readonly']
        )
        
        service = build('sheets', 'v4', credentials=creds)
        sheet = service.spreadsheets()
        
        for sheet_name in sheet_names:
            print(f"\n{'='*60}")
            print(f"工作表：{sheet_name}")
            print('='*60)
            
            # 讀取前幾行來了解結構
            range_name = f'{sheet_name}!A1:Z10'
            result = sheet.values().get(
                spreadsheetId=SPREADSHEET_ID,
                range=range_name
            ).execute()
            
            values = result.get('values', [])
            
            if not values:
                print('沒有找到資料')
                continue
            
            # 顯示標題行和前幾行資料
            for i, row in enumerate(values[:10], 1):
                print(f"第 {i:2d} 行: {row}")
                
            print(f"\n總欄位數: {len(values[0]) if values else 0}")
            
    except Exception as e:
        print(f"讀取試算表時發生錯誤：{e}")

if __name__ == '__main__':
    read_sheet_data()