PHPExcel导入导出excel

保存

  import('Org.Util.PHPExcel');
        import('Org.Util.PHPExcel.Writer.Excel2007');
        import('Org.Util.PHPExcel.IOFactory');
        import('Org.Util.UserReply');
        $this->object = new \PHPExcel();
        $fileName = "./1.xlsx";
            $fileType = \PHPExcel_IOFactory::identify($fileName);
            $objReader = \PHPExcel_IOFactory::createReader($fileType);
            $objPHPExcel = $objReader->load($fileName); 

            $objPHPExcel->getActiveSheet()->setCellValue('A' . $data['s'], $data['id']);
            $objPHPExcel->getActiveSheet()->setCellValue('B' . $data['s'], $data['departId']);
            $objPHPExcel->getActiveSheet()->setCellValue('C' . $data['s'], $data['randId']);
            $objPHPExcel->getActiveSheet()->setCellValue('D' . $data['s'], $data['headimgurl']);
            $objPHPExcel->getActiveSheet()->setCellValue('E' . $data['s'], $data['nickname']);
            $objPHPExcel->getActiveSheet()->setCellValue('F' . $data['s'], $data['mobile']);  
            
            $objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel);
            $objWriter->save($fileName);

导入

        $inputFileType = 'Excel2007';
        //$fileName = "./".$id.".xlsx";
        $fileType = \PHPExcel_IOFactory::identify($fileName);
        $objReader = \PHPExcel_IOFactory::createReader($fileType);
        $objPHPExcel = $objReader->load($fileName);

        $currentSheet = $objPHPExcel->getSheet(0); //第一个工作簿
        $allRow = $currentSheet->getHighestRow(); //行数

        $output = array();
        $preType = '';

        //$qh = $currentSheet->getCell('B4')->getValue();
        //按照文件格式从第7行开始循环读取数据
        for ($i = 1; $i <= $allRow; $i++) {
            //$xh = (int)$currentSheet->getCell('A'.$i)->getValue();
            //if(empty($xh))break;
            $output[$i]['actionId'] = $id;
            $output[$i]['partName'] = $currentSheet->getCell('A' . $i)->getValue(); //主队
            $output[$i]['realName'] = $currentSheet->getCell('B' . $i)->getValue(); //客队
        }

header头信息导出

     $filename = date('YmdHis').'_export_data.xls';
        header("Content-type:application/vnd.ms-excel; charset=UTF-8"); 
        Header("Accept-Ranges:bytes");
        header("Content-Disposition:attachment; filename=".$filename);
        header('Cache-Control: max-age=0');
        header("Pragma: no-cache");
        header("Expires: 0");
        echo iconv("UTF-8", "gb2312",'编号ID').chr(9); 
        echo iconv("UTF-8", "gb2312",'卡号').chr(9);
        echo iconv("UTF-8", "gb2312",'密码').chr(9);
        echo chr(13);
        foreach ($list as $key => $value) {
             echo strval($value['cardId']+10000000).chr(9);
             echo $value['number'].chr(9);
             echo $value['pwd'].chr(9);
             echo chr(13);   

        }

http://blog.csdn.net/yanhui_wei/article/details/7930502