import pandas as pd

# Load the excel file
file_path = '/Users/dwicompany/Documents/Developer/projects/koperasi/doc/barang.xlsx'
xls = pd.ExcelFile(file_path)

print(f"Sheet names: {xls.sheet_names}")

# Read first sheet
df = pd.read_excel(file_path, sheet_name=xls.sheet_names[0])

print(f"\nColumns for sheet '{xls.sheet_names[0]}':")
print(df.columns.tolist())

print("\nFirst 5 rows:")
print(df.head())

print("\nInfo:")
print(df.info())