/PHP/Phpoffice create excel and download

Phpoffice create excel and download

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

class DownloadExcel
{
    public static function createExcel(array $data, array $headers = [],
                                       $fileName = 'data.xlsx')
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();

        for ($i = 0, $l = sizeof($headers); $i < $l; $i++) {
            $sheet->setCellValueByColumnAndRow($i + 1, 1, $headers[$i]);
        }

        for ($i = 0, $l = sizeof($data); $i < $l; $i++) { // row $i
            $j = 0;
            foreach ($data[$i] as $k => $v) { // column $j
                $sheet->setCellValueByColumnAndRow($j + 1, ($i + 1 + 1), $v);
                $j++;
            }
        }

        $writer = new Xlsx($spreadsheet);
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment; filename="'. urlencode($fileName).'"');
        $writer->save('php://output');
    }

}

Source: stackoverflow.com

Similar codes

0 vote332 views1 answer
Laravel vue error 500
PHP Laravel
0 vote280 views1 answer
Php image rotate upload
PHP
0 vote293 views1 answer
Laravel eloquent select one column in array
PHP Laravel
1 vote258 views2 answers
Laravel pluck multiple columns
PHP
3 votes317 views1 answer
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file laravel
PHP Laravel
11 votes258 views2 answers
Select distinct laravel
PHP
0 vote245 views1 answer
Symfony see all make command
PHP
9 votes283 views3 answers
Laravel enum migration
PHP Laravel
0 vote322 views1 answer
Laravel get file to browser send
PHP Laravel
0 vote322 views1 answer
Wordpress change language of specific text php
PHP Wordpress