php 常用功能之导入导出-zend 框架下导出excel

public function exportAction(){
$id =$this->_request->getParam(‘id’);
set_time_limit(0);//永久执行直到程序结束
ini_set(‘display_errors’, 1);//设置开启错误提示
error_reporting(‘E_ALL & ~E_NOTICE ‘);//错误等级提示
$modelrule = new Logistic_Model_Channelrule();$data = $modelchannelrule->exportSearch(); include_once APPLICATION_PATH . ‘../library/PHPExcel/PHPExcel.php’; //设定缓存模式为经gzip压缩后存入cache$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
$cacheSettings = array(); PHPExcel_Settings::setCacheStorageMethod($cacheMethod,$cacheSettings);

    $objPHPExcel = new PHPExcel();
    $objPHPExcel->setActiveSheetIndex(0);
    $objActSheet = $objPHPExcel->getActiveSheet();
    $objActSheet->setTitle('Sheet1');
    $cellName = array('A','B','C','D','E');
    for($i=0;$i<count($cellName);$i++){        $objPHPExcel->getActiveSheet()->getColumnDimension($cellName[$i])->setAutoSize(true);        $objPHPExcel->getActiveSheet()->getStyle($cellName[$i].'1')->getFont()->setBold(true);
    }
    $objPHPExcel->getActiveSheet()->SetCellValue('A1', '名称');
    $objPHPExcel->getActiveSheet()->SetCellValue('B1', '名称');
    $objPHPExcel->getActiveSheet()->SetCellValue('C1', '费用');
    $objPHPExcel->getActiveSheet()->SetCellValue('D1', '操作费');
    $objPHPExcel->getActiveSheet()->SetCellValue('E1', '单价');  
    foreach ($data as $key => $items){
        $objPHPExcel->getActiveSheet()->setCellValue('A'.($key+2), $items['CHANNELRULEID']);
        $objPHPExcel->getActiveSheet()->setCellValue('B'.($key+2), $items['COUNTRYID']);
        $objPHPExcel->getActiveSheet()->setCellValue('C'.($key+2), $items['HANDLING']);
        $objPHPExcel->getActiveSheet()->setCellValue('D'.($key+2), "HELLO");
        $objPHPExcel->getActiveSheet()->setCellValue('E'.($key+2), $data['price']);

    }
    header("Content-Type: application/vnd.ms-excel");
    header("Content-Disposition:attachment;filename=导出文件名称" . date('Y-m-d', mktime()) . ".xls");
    header("Pragma:no-cache");
    header("Expires:0");
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
    $objWriter->save('php://output');
    exit;
}