spatie/simple-excel example

excel_report.php

<?php
use Spatie\SimpleExcel\SimpleExcelWriter;

$username = "blabla";
$pass = "3CVzq8MmV8U3TXDL";
$host = "localhost";

$db = "db_arsip";


$connect = mysqli_connect($host, $username, $pass, $db) or die(mysqli_error($connect));

$populate = mysqli_query($connect, "SELECT * FROM arsip;");

$counter = 0;

$writer = SimpleExcelWriter::streamDownload('your-export.xlsx');

while ($row = mysqli_fetch_array($populate)) {
    $writer->addRow([
        // nama_kolom => isi_kolom
        'no' => $row['no_arsip'],
        'judul' => $row['judul'],
        'klasifikasi' => $row['klasifikasi'],
    ]);
    
    if ($counter % 1000 === 0) {
        flush(); // Flush the buffer every 1000 rows
    }
    
    $counter++;
}
    
$writer->toBrowser();