simple-excel

simple-excel copied to clipboard

PHP 7.4.21 Laravel 8.* apache package latest version

Code

$projects = DB::select("query hidden");
$servers = DB::select("query hidden");

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

$nameSheet = $writer->getCurrentSheet();
$nameSheet->setName('Projects');

$array = json_decode(json_encode($projects), true);
$stream->addRows(json_decode(json_encode($projects), true));

$addressSheet = $writer->addNewSheetAndMakeItCurrent();
$addressSheet->setName('Servers');
$stream->addRow(['Project_ID']);
$stream->addRows(json_decode(json_encode($servers), true));


return $stream->toBrowser();`

Result:

This site can’t be reached

if i only return string in this controller it will return the string, but for this site can't be reached