• thinkphp3.2 phpexcel导入


    
    
    //导入
    public
    function textImp(){ //框架上传文件 $upload = new ThinkUpload(); $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); //表头 $objExcel->getActiveSheet() ->setCellValue('A1','name1') ->setCellValue('B1','name2'); //内容 $objExcel->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"); // $objwriter = PHPExcel_IOFactory::createWriter($objPhpExcel, 'Excel5'); $objPhpExcel->save('php://output'); }

      

  • 相关阅读:
    mysql查询版本
    mysql导出bug备注
    linux查找文件
    linux 编译式安装nginx
    linux文件校验
    linux 编译式安装apache
    网络层
    数据链路层
    物理层
    servlet过滤器
  • 原文地址:https://www.cnblogs.com/limonyun/p/9390846.html
Copyright © 2020-2023  润新知