使用来自Yii的PHPExcel扩展来填充excel

Question

This my code:

    $col =  array("Year", "Month");
    $result = Yii::app()->db->createCommand("select * from mytable WHERE `column` = '".$cnp."' ")->queryAll();

   $dataProvider = new CArrayDataProvider($result, array());

   $excelGenerator = new ExcelView(array('dataProvider' => $dataProvider,
       'columns' => array(  
            array(
                'header' => 'Year',
                'value' => '$data->year',
            ),
            array(
                'header' => 'Month',
                'value' => '$data->month',
            ),
        ),
            ));
   $excelGenerator->run();

The result of this is an excel file with two column name Year and Month, but How can I populate with data taken from my select ? This select returns multiple results. thx

Answer 1

Since you are using CArrayDataProvider, value should be accessed as an array:

'value' => '$data["month"]',

You can also use the CGridView shorthand columns structure

'columns' => array(
    'year',
    'month::Month of Year',
    'other_column:type:Other Column',