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.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\IOFactory;
//ob_end_clean();
$servername = "localhost";
$server_user = "";
$server_pass = &