Spreadsheets, driven by code.

<?php

require 'vendor/autoload.php';

use \PhpOffice\PhpSpreadsheet\Spreadsheet;
use \PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$worksheet = $spreadsheet->getActiveSheet();

// A header row plus enough data rows to make scrolling meaningful.
$worksheet->fromArray([['id', 'name', 'email']]);

$row = 2;
for ($i = 1; $i <= 100; $i++) {
    $worksheet->fromArray(
        [[$i, "User $i", "user$i@example.com"]],
        null,
        "A$row"
    );
    $row++;
}

// Freeze everything above row 2 — i.e. keep row 1 (the header) in view.
$worksheet->freezePane('A2');

$writer = new Xlsx($spreadsheet);
$writer->save('frozen.xlsx');

echo "Done. Wrote frozen.xlsx with the header row frozen.\n";