Yii Resultset To Phpexcel

[yii_king (Micho23)]

I am trying to export the data retrieved from the database, through PHPExcel to Excel. All the examples on PHPExcel website refers to examples where the mysql result set is being looped through. Excel is opened but there is no data populated so I guess that I am somehow looping through the resultset in the wrong way?

My query is executed like this:

$command = Yii::app()->db->createCommand($sql);

$resultset = $command->queryAll();

I am then calling the method below.

ExportController::exportArrayToExcel($resultset);

The below code is the function I want to use for export by passing the returned resultset array.

/**

* 


* This function is used to export a retrieved array directly from db


* @param array $data


*/

public function exportArrayToExcel($data) {

	Yii::import('ext.phpexcel.XPHPExcel');


	$objPHPExcel = XPHPExcel::createPHPExcel();


	$fname = "test.xlsx";


	$col = 0;


	$row = 0;


	//while($row = mysql_fetch_array($data)) {


	    foreach($data as $key=>$value) {


	       $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);


    	    $col++;


	        $row++;


	    }


	    


	//}


	// Redirect output to a clients web browser (Excel5)


	header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');


	header("Content-Disposition: attachment;filename=$fname");


	header('Cache-Control: max-age=0');


	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');


	//$objWriter->save($fname);


	$objWriter->save('php://output');


	exit;

}