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);
/*
* @param mixed 表格为空时返回的值
* @param boolean 是否启用公式计算
* @param boolean 是否格式化单元格
* @param boolean 返回的行和列
*/
$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信息
header("Pragma: public"); //可以缓存响应中的信息
header("Expires: Thursday January 11th 2018"); //GMT格式的时间 时间过期则阻止缓存
header("Cache-Control:must-revalidate, post-check=0, pre-check=0"); // 3个header 输出不缓存
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');
}
thinkphp3.2 excel导入
最新推荐文章于 2024-07-13 09:47:45 发布