import pandas as pd
import json

excel_path = r'f:\laravel\job\abality - Copy\public\ABILITY_PRICE_LIST_2026-1.xlsx'

# Read first 20 rows without headers to see where they are
df_raw = pd.read_excel(excel_path, header=None, nrows=20, engine='openpyxl')

# Convert to list for inspection
rows = df_raw.values.tolist()

with open(r'f:\laravel\job\abality - Copy\scratch\raw_rows.json', 'w', encoding='utf-8') as f:
    json.dump(rows, f, ensure_ascii=False, indent=4)

print("Raw rows saved to scratch/raw_rows.json")