在YII中使用PHPExcel扩展导出数据到EXCEL中

1、First download the php extension：

http://www.yiiframework.com/extension/phpexcel/

2、Extract the release file under protected/extensions

3、See the following code example:

$data = array(
    1 => array ('Name', 'Surname'),
    array('Schwarz', 'Oliver'),
    array('Test', 'Peter')
);
Yii::import('application.extensions.phpexcel.JPhpExcel');
$xls = new JPhpExcel('UTF-8', false, 'My Test Sheet');
$xls->addArray($data);
$xls->generateXML('my-test');

使用案例

public function actionPhpexcel2(){
            /*$data = array(
                1 => array ('Name', 'Surname'),
                array('Schwarz', 'Oliver'),
                array('Test', 'Peter')
            );*/
            $model= Members::model()->findAll();
            $data=array(
                1=>array('用户ID','微信号OpenId','微信昵称','头像','累积盾牌','本周盾牌','是否中奖')
            );
            foreach($model as $item){
                $data[]=$item->attributes;
            }
            Yii::import('application.extensions.phpexcel.JPhpExcel');
            $xls = new JPhpExcel('UTF-8', false, 'My Test Sheet');
            $xls->addArray($data);
            $xls->generateXML('my-test');
        }

 view中

<tr class="odd"><th>导出所有用户对盾牌数</th><td><a href="./index.php?r=admin/Pictures/phpexcel2">点击导出EXCEL</a></td></tr>