PHPExcel from Array by cli or browser, support php5, php7, php8
通过命令行或者浏览器把PHP数组中的数据导出到excel中。同时支持php低版本和高版本
vi composer.json
{
"name": "test",
"type": "library",
"minimum-stability": "dev",
"require": {
"jacena/php-excel-export": "dev-master"
},
"repositories": {
"packagist": {
"type": "composer",
"url": "https://packagist.org"
},
"jacena/php-excel-export": {
"type": "git",
"url": "https://github.com/jacena/php-excel-export.git"
}
}
}
- 安装 install
composer install --ignore-platform-reqs -vvv
- 更新 update
composer require --ignore-platform-reqs -vvv
vi test.php
<?php
namespace test;
require_once("vendor/autoload.php"); // 如果用的框架,肯定已经自动加载了。可以注释
use Jacena\PhpExcelMaker\PHPExcelMaker;
$keys = $title = [];
$data = [
['user_name'=>'jack', 'age'=>'20', 'sex'=>'1'],
['user_name'=>'hack', 'age'=>'30', 'sex'=>'2'],
['user_name'=>'jack', 'age'=>'22', 'sex'=>'1'],
['user_name'=>'jack', 'age'=>'23', 'sex'=>'2'],
['user_name'=>'jack', 'age'=>'32', 'sex'=>'2'],
['user_name'=>'jack', 'age'=>'40', 'sex'=>'2'],
['user_name'=>'jack', 'age'=>'60', 'sex'=>'1'],
];
$title = [
'user_name' => '姓名',
'age' => '年龄',
'sex' => '性别',
];
$excel = new PHPExcelMaker();
if (PHP_SAPI == 'cli') {
// var_dump($excel->getPHPVersion());exit;
$excel->exportExcel($keys, $title, $data, 'xxx'); // 数组名和文件名一致
exit;
}else {
// var_dump($excel->getPHPVersion());exit;
$excel->exportExcel($keys, $title, $data, 'xxxx', false); // 数组名和文件名一致
}