
public function textImp(){
$upload = new \Think\Upload();
$upload->maxSize = 3145728;
$upload->exts = array('xlsx');
$upload->rootPath = './Public/uploads/';
$upload->savePath = '';
$info = $upload->upload();
$filename = './Public/uploads/' . $info["updataexcel2007"]["savepath"] . $info["updataexcel2007"]["savename"];
vendor("PHPExcel.PHPExcel");
$objPhpExcel = \PHPExcel_IOFactory::load($filename);
$result = $objPhpExcel->getActiveSheet()->toArray(true, true, true, true);
}
public function textDown(){
vendor("PHPExcel.PHPExcel");
$objExcel = new \PHPExcel();
$objPhpExcel = new \PHPExcel_Writer_Excel2007($objExcel);
$objPhpExcel->getActiveSheet()
->setCellValue('A1','name1')
->setCellValue('B1','name2');
$objPhpExcel->getActiveSheet()
->setCellValue('A2','xx1')
->setCellValue('B2','xx2');
header("Pragma: public");
header("Expires: Thursday January 11th 2018");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");
header("Content-Disposition:attachment;filename='text.xlsx'");
header("Content-Transfer-Encoding:binary");
$objPhpExcel->save('php://output');
}