php导出excel

php 5.6

git clone https://github.com/PHPOffice/PHPExcel.git

//导入文件
require_once("/PHPExcel/Classes/PHPExcel.php");
$_phpExcel = new \PHPExcel();
$_phpExcel->getProperties()->setTitle("low php excel test");
$arr = [
    ['t1',10],
    ['t2',19],
];
$sub_title = [
    ['title','age'],
];
$_phpExcel->getActiveSheet()->fromArray($sub_title,null);
$_phpExcel->getActiveSheet()->fromArray($arr,null,'A2');

$_write = new \PHPExcel_Writer_Excel2007($_phpExcel);
$_write->save('low_php_excel.xlsx');

**************************
php 7.2
git clone https://github.com/PHPOffice/PhpSpreadsheet.git

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

$title = 'test';

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setTitle($title);

$columns=['名称','年龄'];

$list=[["liujin",'18'],["lili",19]];

foreach ($columns as $k=>$column) {
    $sheet->setCellValueByColumnAndRow($k+1,1,$column);
}
foreach ($list as $k => $item){
    foreach ($item as $j=>$v) {
        $sheet->setCellValueByColumnAndRow($j+1,$k+2,$item[$j]);
    }
}
$writer = new Xlsx($spreadsheet);
$file_path = 'tmp.xlsx';
$writer->save($file_path);