PHP Feature for Excel Export of Car Stock

We are a used car dealership based in Kolkata with an existing PHP-based website that lists our car stock. We want to add a feature in our admin panel that allows us to download an Excel (.xlsx) file of all available cars in stock with one click.

This Excel file should be properly formatted and include the following columns:

Serial Number

Car Name

Brand

Model Year

Fuel Type

Transmission

Price

Location

Direct Link to Car Detail Page (based on car slug)

Requirements:
Add a button in admin dashboard labeled “Download Stock Excel”

On click, export all cars marked as available from our MySQL database

Use PHP (no external platforms) with PhpSpreadsheet or PHPExcel

Generate a professional .xlsx file on-the-fly with relevant data

Each row must include a direct link to the car page (e.g., https://msmotorindia.com/car/[slug])

Ensure correct formatting (e.g., ₹ for price, proper number formatting)

Code must be clean, secure, and well-commented

Optional (bonus): Add date in filename like MSMotor_Stock_10-07-2025.xlsx

Access & Security:
The feature should only be accessible to logged-in admins

You may need to implement a basic session check if not already present

Stack:
Website built in PHP (custom, not WordPress)

MySQL backend

Admin panel already exists

Deliverables:
Fully functional export_stock_excel.php file

Any front-end change in admin panel (HTML button)

Installation and integration on our server

Testing to ensure correct output and formatting

Bonus (if applicable):
Ability to select filters (e.g., by brand or year) before downloading

Option to auto-email the Excel file to pre-defined email IDs

To Apply:
Please include:

Examples of similar PHP export tasks you’ve done

Estimated time for completion

Whether you’ll need FTP/db access or will work on code files only