$data = $array['DataProvider'];
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("K'iin Balam")
->setLastModifiedBy("K'iin Balam")
->setTitle("YiiExcel Test Document")
->setSubject("YiiExcel Test Document")
->setDescription("Test document for YiiExcel, generated using PHP classes.")
->setKeywords("office PHPExcel php YiiExcel UPNFM")
->setCategory("Test result file");
// Add some data
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', 'Дата')
->setCellValue('B1', 'Логин')
->setCellValue('C1', 'Организация')
->setCellValue('D1', '№ заказа')
->setCellValue('E1', 'Плательщик')
->setCellValue('F1', 'Сумма')
->setCellValue('G1', 'Тип')
->setCellValue('H1', 'Вариант оплаты')
->setCellValue('I1', 'Счет')
->setCellValue('J1', 'Дата оплаты')
->setCellValue('K1', 'Статус-балланс');
for ($i = 0; $i < count($data); $i++) {
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A'.($i+2), $data[$i]->date)
->setCellValue('B'.($i+2), $data[$i]->user->username)
->setCellValue('C'.($i+2), $data[$i]->user->company)
->setCellValue('D'.($i+2), $data[$i]->id)
->setCellValue('E'.($i+2), $data[$i]->payer)
->setCellValue('F'.($i+2), $data[$i]->value)
->setCellValue('G'.($i+2), $data[$i]->type)
->setCellValue('H'.($i+2), $data[$i]->variant_add)
->setCellValue('I'.($i+2), $data[$i]->invoice)
->setCellValue('J'.($i+2), $data[$i]->date_realy)
->setCellValue('K'.($i+2), $data[$i]->status_ballanse);
}
// Miscellaneous glyphs, UTF-8
/*$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A4', 'Miscellaneous glyphs')
->setCellValue('A5', 'йаищвкофылпьядцьз');*/
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('YiiExcel');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Save a xls file
$filename = 'Glyanec-fin';
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="'.$filename.'.xls"');
header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
//$objWriter->save('test.xls');
unset($this->objWorksheet); unset($this->objPHPExcel);