think PHP6 excel导出

封装基础库

基础层的作用：负责封装特定功能的库或应用第三方类库

在lib层添加Excel类

在Excel类中定义静态的方法，方便调用

namespace app\admin\lib;

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

class Excel
{
    /**
     * 导出
     * @param array $header
     * @param bool $type
     * @param array $data
     * @param string $fileName
     * @return \think\response\Json|void
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     */
    public static function export($header = [], $type = true, $data = [], $fileName = "1910"){
        // 实例化类
        $preadsheet = new Spreadsheet();
        // 创建sheet
        $sheet = $preadsheet->getActiveSheet();
        // 循环设置表头数据
        foreach ($header as $k => $v) {