Yii 导出excel

 public function actionExport(){
        $product_ids = $this->request_param_get['product_ids'];
        $Stocks = Stocks::model()->with('product')->findAll('store_id=:store_id AND t.product_id IN (' . $product_ids . ')', 
             array(':store_id'=>$this->user_info['store_id']));
        krsort($Stocks);
        $customer_list = UserModel::getUserInfo($this->user_info['user_id']);//获取此海外仓客户
        Yii::import('application.extensions.OfficeTools.PHPExcel',1);
        $start_head_row = 1;//第一行输出表头
        $start_row = 2;//第二行开始输出数据
        //表头数据
        $print_head = array(
            'A'=>'SKU',
            'B'=>'Description',
            'C'=>'Client',
            'D'=>'Inventory',
            'E'=>'Blocked Inventory',
            'F'=>'Question  Inventory'
        );
        $objectPHPExcel = new PHPExcel();
        //报表头输出
        foreach($print_head as $k=>$v){
            $objectPHPExcel->setActiveSheetIndex(0)->setCellValue($k.$start_head_row,$v);
        }
        if(!empty($Stocks)){
            //表数据输出
            $j = $start_row;
            foreach($Stocks as $k=>$stock){
                $data = array(
                    'A'=>$stock->product->product_sn,
                    'B'=>$stock->product->product_name_en,
                    'C'=>isset($customer_list[$stock->user_id]) ? $customer_list[$stock->user_id] : '',
                    'D'=>$stock->stock_num,
                    'E'=>$stock->freeze_num,
                    'F'=>$stock->disabled_num
                );
                foreach ($print_head as $key=>$value){
                    $objectPHPExcel->setActiveSheetIndex(0)->setCellValue($key.$j,$data[$key]);
                }
                $j++;
            }
        }
        $objectPHPExcel->getActiveSheet()->getDefaultColumnDimension()->setWidth(20);//设置单元格宽度
        header('Content-Type : application/vnd.ms-excel');
        header('Content-Disposition:attachment;filename="'.'inventory-'.date("Y-m-j").'.xls"');
        $objWriter= PHPExcel_IOFactory::createWriter($objectPHPExcel,'Excel5');;
        $objWriter->save('php://output');
    }
//视图层
 <span οnclick="window.open('<?=Yii::app()->createUrl('wms/stock/exportFlow/product_id/'.$stock->product_id)?>')">Export</span>