php excel导入导出

源代码

excel导出
 include_once '../../../lib/phpexcel/phpexcel.class.php';
        $objPHPExcel  = new \PHPExcel();
        $objWriter =new \PHPExcel_Writer_Excel2007($objPHPExcel);

$objPHPExcel->createSheet();
        $objPHPExcel->setactivesheetindex(5);
        $objPHPExcel->getActiveSheet(5)->setCellValue('A1', '项目');
        $objPHPExcel->getActiveSheet(5)->setCellValue('B1', '修复成功');
        $objPHPExcel->getActiveSheet(5)->setCellValue('C1', '修复失败');
        $objPHPExcel->getActiveSheet(5)->setTitle('汇总');


        $objPHPExcel->getActiveSheet(5)->setCellValue('A2', '荔湾移动4G');
        $objPHPExcel->getActiveSheet(5)->setCellValue('B2', $repair_data->yd4gs);
        $objPHPExcel->getActiveSheet(5)->setCellValue('C2', $repair_data->yd4gf);
  
//导出
 $path='../../../www/data/excelexport';
        $filename = time() . '.xls';
        $objWriter->save("$path/$filename");

        $name = $filename;
        $fileName = $path.'/' . $name; //得到文件名
        header("Content-Disposition:  attachment;  filename=" . $fileName); //告诉浏览器通过附件形式来处理文件
        header('Content-Length: ' . filesize($fileName)); //下载文件大小
        readfile($fileName);  //读取文件内容
excel导入
 include_once '../../../lib/phpexcel/phpexcel.class.php';
        $file = $_FILES['file'];
        if ($file['error'] == 4) $this->error('请选择上传excel文件');
        $file_types = explode ( ".", $file['name'] );
        $excel_type = array('xls','csv','xlsx');
        if (!in_array(strtolower(end($file_types)),$excel_type)){
            $this->error("不是Excel文件，请重新上传");
        }

        //哪一行开始是实际数据
        $start_index=2;

        //设置获取excel对象
        $objReader = \PHPExcel_IOFactory::createReader('Excel2007');//配置成2003版本，因为office版本可以向下兼容

   $objPHPExcel = $objReader->load($file['tmp_name'],$encode='utf-8');//$file 为解读的excel文件
 $sheet = $objPHPExcel->getSheet(0);
        $highestRow = $sheet->getHighestRow()+$start_index; // 取得总行数
        $success_item = $fail_item = 0;
 for($j=$start_index;$j<=$highestRow;$j++)
        {
            $mt_number = $objPHPExcel->getActiveSheet()->getCell("G".$j)->getValue();//平台监控点编号
}
Response::success('成功条数:'.$success_item.'，失败条数：'.$fail_item);