Read Metadata Information from Excel XLSX file with PyLightXL API

read-metadata-using-pylightxl-api-python.py

import pylightxl as xl

# Load the Excel file
file_path = "example.xlsx"
workbook = xl.readxl(fn=file_path)

# PyLightXL does not have built-in metadata extraction,
# but you can check basic file-level information
print("Excel Metadata Information:")
print(f"File Name: {file_path}")
print(f"Number of Sheets: {len(workbook.ws_names)}")

# Print all sheet names
print("Sheet Names:", workbook.ws_names)