Excel 003 - basic 1

<?php
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\IOFactory;
/*
Bagian ini silahkan anggap tidak ada..
karena dasarnya ini include composer (autoload.php)
*/
{
    $paths = [
        __DIR__ . '/../vendor/autoload.php', // In case PhpSpreadsheet is cloned directly
        __DIR__ . '/../../../autoload.php', // In case PhpSpreadsheet is a composer dependency.
        __DIR__ . '/../../../web/example/vendor/autoload.php' //memakai ini
    ];

    foreach ($paths as $path) {
        if (file_exists($path)) {
            require_once $path;
            //echo "run:$path";
            ;
        }
    }

    //throw new \Exception('Composer autoloader could not be found. Install dependencies with `composer install` and try again.');


}

?>
<!--
/**
##INFO##
{"title":"excel Dasar ","detail":"membuat excel menggunakan PHP Spreadsheet "}
##INFO##
**/
-->
<?php
$spreadsheet = new Spreadsheet();

$spreadsheet->setActiveSheetIndex(0)
    ->setCellValue('A1', 'Hello')
    ->setCellValue('B2', 'world!')
    ->setCellValue('C1', 'Hello')
    ->setCellValue('D2', 'world!');

$spreadsheet->getActiveSheet()
    ->setTitle('Simple');


/*
Pada Bagian ini disarankan simpan ke folder dahulu
sebelum mengeluarkan..
atau di download
*/
$file='contoh001.xlsx';

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="'.$file.'"');
header('Content-Length: ' . filesize($file));

header('Content-Transfer-Encoding: binary');
header('Cache-Control: must-revalidate');
header('Pragma: public');

ob_clean();
flush();

$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save($file);

$str=file_get_contents($file);

die($str);