import pandas as pd

orders = pd.DataFrame(
    {
        "Order ID": ["01001", "01002", "01003"],
        "Customer": ["Ada Lovelace", "Lin Chen", "Maya Patel"],
        "Region": ["EMEA", "APAC", "AMER"],
        "Total": [149.50, "pending", 212.00],
        "Order Date": ["2026-06-01", "2026-06-02", "2026-06-03"],
        "Internal Note": ["reviewed", "awaiting invoice", "reviewed"],
    }
)

lookup = pd.DataFrame(
    {
        "Region": ["EMEA", "APAC", "AMER"],
        "Owner": ["Finance Europe", "Finance Asia", "Finance Americas"],
    }
)

with pd.ExcelWriter("sales.xlsx", engine="openpyxl") as writer:
    orders.to_excel(writer, sheet_name="Orders", index=False)
    lookup.to_excel(writer, sheet_name="Lookup", index=False)

print("Created sales.xlsx")
print("Sheets: Orders, Lookup")