I have a database and use php and phpspreadsheet vendor, when I want to download and add the comments “BETWEEN” and also “AND” to download according to the selected date of birth, but the downloaded excel file cannot be opened with the statement “because the file format or file extension not valid…”, please help, where is the problem? enter image description here

i have this this tabel “pelajar”

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 17, 2024 at 11:09 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `crud-php`
--

-- --------------------------------------------------------

--
-- Table structure for table `pelajar`
--

CREATE TABLE `pelajar` (
  `id_pelajar` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `jenis_kelamin` varchar(2) NOT NULL,
  `tanggal_lahir` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pelajar`
--

INSERT INTO `pelajar` (`id_pelajar`, `nama`, `jenis_kelamin`, `tanggal_lahir`) VALUES
(1, 'Muhammad Fauzi', 'L', '1997-11-30'),
(2, 'Inda Rahayu Rayni', 'P', '2000-11-29'),
(3, 'TEGUH KRISTIYANTO', 'M', '1974-09-12'),
(4, 'BAMBANG ANTARIKSA GUNAWAN', 'M', '1976-09-01'),
(5, 'BAMBANG T. BUDIAJI', 'M', '1969-02-19'),
(6, 'SITI NURHAYATI', 'F', '1976-06-07'),
(7, 'SRIPINA BR. SEMBIRING', 'F', '1979-11-15'),
(8, 'ANDI ISTATI', 'F', '1976-04-20'),
(9, 'ESTI GUSLIANTI WILUJENG', 'F', '1983-04-29'),
(10, 'YUNUS HADI PRABOWO', 'M', '1972-10-13'),
(11, 'ENRIKO SIREGAR', 'M', '1986-09-22'),
(12, 'AUDI NAUFAL RAMADHIAN', 'M', '1995-11-01'),
(13, 'TULUS BUDYARJO', 'M', '1976-01-24'),
(14, 'AMIRUL BAKTI', 'M', '1981-02-06'),
(15, 'NADIA RAHMA NISITA', 'F', '1983-09-25'),
(16, 'TRI YOSI KUNCORO', 'M', '1975-06-27'),
(17, 'SULISTYO DWI ATMOJO', 'M', '1987-05-13'),
(18, 'WANDA DAMAYANTI VANDA', 'F', '1980-08-13'),
(19, 'INUNG BUDIANTO', 'M', '1982-09-18'),
(20, 'FIRMAN ANNDY AWANGGA', 'M', '1974-05-28'),
(21, 'IMANIYYA MAHIRA', 'F', '1987-11-03'),
(22, 'LENNY SEPTIANI PUTRI', 'F', '1997-09-01'),
(23, 'DIPO DWIDANI', 'M', '1979-05-25'),
(24, 'MUHAMMAD SATRIA ALAM', 'M', '2000-09-05'),
(25, 'RIZKI FADHIL SYAHRIAL', 'M', '1993-12-21'),
(26, 'IRAWAN SUBIYAKTO', 'M', '1998-05-22'),
(27, 'FEBRI FRANS PAMUNGKAS SIANTURI', 'M', '1994-02-27'),
(28, 'LUPITA ARDHYANINGRUM', 'F', '1992-06-07'),
(29, 'ARMIN TOTO', 'M', '1977-10-24'),
(30, 'INDHAH HENDRIYANI', 'F', '1981-06-22'),
(31, 'MAYANG SEKAR MUSTIKOWATI', 'F', '1993-04-25'),
(32, 'RUSMIYATI', 'F', '1985-03-30'),
(33, 'NOVY INNA FITRIANA', 'F', '1997-02-11'),
(34, 'CARLA NATHANIA', 'F', '1997-08-08'),
(35, 'WENTRA HAKAMI', 'M', '1998-09-05'),
(36, 'ADYANSYAH PATONANGI', 'M', '1993-11-12'),
(37, 'NINUK NURUL CHAEDAH', 'F', '1973-07-04'),
(38, 'AGUS DANANG WIBOWO', 'M', '1988-08-14'),
(39, 'FARDAN WAINARI', 'M', '1986-05-25'),
(40, 'MUHAMAD FAKRI PIRDAUS', 'M', '1992-10-06'),
(41, 'APRIADI', 'M', '1988-04-15'),
(42, 'IMAM AFANDI', 'M', '1975-11-16'),
(43, 'MUHAMMAD LUTFI', 'M', '1992-11-10'),
(44, 'DINAR PAULINA ROSELANY', 'F', '1983-06-22'),
(45, 'AMUDI PRAWIYATA SITOHANG', 'M', '1987-08-12'),
(46, 'TRI PURNAMASARI', 'F', '1993-10-20'),
(47, 'KLARA SYLVANA WILIA', 'F', '2000-05-23'),
(48, 'ALDI RAMADHIKA', 'M', '1989-04-13'),
(49, 'TRI WICAKSONO', 'M', '1971-03-12'),
(50, 'AMYLDA SILFIA', 'F', '1977-12-13'),
(51, 'FLORA PRAMASARI', 'F', '1972-11-24'),
(52, 'INDRA MOESTIKO', 'M', '1969-10-02'),
(53, 'MARDIAS OKTARIBUS', 'F', '1965-09-30'),
(54, 'PATRISIA MARLINA TJAHJADI', 'F', '1976-03-16'),
(55, 'RONNY IRAWAN', 'M', '1976-07-02'),
(56, 'SARAH ANGELIQUE MUSTIKASARI', 'F', '1973-08-10'),
(57, 'TONYANTO WIJAYA', 'M', '1972-11-22'),
(58, 'ACHMAD BUDHI PRASETYA', 'M', '1981-12-11'),
(59, 'NANI PUSPITARINI', 'F', '1970-11-28'),
(60, 'VIVI APRIANTY', 'F', '1972-04-04'),
(61, 'ADIEL PARADIELLA', 'F', '1986-04-05'),
(62, 'LAKSMI MURTI', 'F', '1975-10-13'),
(63, 'JIM WIBOWO', 'M', '1987-05-03'),

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pelajar`
--
ALTER TABLE `pelajar`
  ADD PRIMARY KEY (`id_pelajar`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pelajar`
--
ALTER TABLE `pelajar`
  MODIFY `id_pelajar` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1457;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

and this my html and php

<?php
require 'config/app.php';

require 'vendor/autoload.php';

use PhpOfficePhpSpreadsheetSpreadsheet;
use PhpOfficePhpSpreadsheetWriterXlsx;

if (isset($_POST['download'])) {
    $tgl1 = ['tgl1'];
    $tgl2 = ['tgl2'];

    $data_pelajar = select("SELECT * FROM pelajar WHERE tanggal_lahir BETWEEN '$tgl1' AND '$tgl2'");

    $spreadsheet = new Spreadsheet();
    $activeWorksheet = $spreadsheet->getActiveSheet($spreadsheet);
    $activeWorksheet->setCellValue('A1', 'No');
    $activeWorksheet->setCellValue('B1', 'Nama');
    $activeWorksheet->setCellValue('C1', 'Jenis Kelamin');
    $activeWorksheet->setCellValue('D1', 'Tanggal Lahir');

    $no = 1;
    $start = 2;

    foreach ($data_pelajar as $pelajar) {
        $activeWorksheet->setCellValue('A'. $start, $no++);
        $activeWorksheet->setCellValue('B'. $start, $pelajar['nama']);
        $activeWorksheet->setCellValue('C'. $start, $pelajar['jenis_kelamin']);
        $activeWorksheet->setCellValue('D'. $start, $pelajar['tanggal_lahir']);

        $start++;
    }

    $writer = new Xlsx($spreadsheet);
    $writer->save('pelajar.xlsx');
    header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheet.sheet');
    header('Content-Disposition: attachment;filename="pelajar.xlsx"');
    readfile('pelajar.xlsx');
    unlink('pelajar.xlsx');
    exit;
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <form action="" method="post">
        <input type="date" name="tgl1">
        <input type="date" name="tgl2">
        <button type="submit" name="download" id="download">Download</button>
    </form>
    
</body>
</html>

I want to download it based on the selected date, example like this on sql

enter image description here

SELECT * FROM `pelajar` WHERE tanggal_lahir BETWEEN '1990-01-01' AND '2000-12-31';

anyone help me for this code?

thank you