Phpspreadsheet 导入导出功能

安装Composer官网链接https://phpspreadsheet.readthedocs.io/en/latest/faq/

https://getcomposer.org/Composer-Setup.exe

开启phpfile拓展php.ini这行;extension=fileinfo改为:

extension=fileinfo

根目录安装Phpspreadsheet

composer require phpoffice/phpspreadsheet

前端js请求生成跳转请求

var link=document.createElement('a');
 document.body.appendChild(link);
 link.href="";
 link.click();

后端代码

<?php
header('Access-Control-Allow-Origin:*');
header("Cache-Control:post-check=0,pre-check=0",false);
header("Pragma:no-cache");
require 'vendor/autoload.