public static function export()
{
$list = Impexp::getList();
/*foreach($list[0] as $i=>$item){
print Impexp::dfe($i).'1,'.$item.'<br>';
}
//for($i=65;$i<=90;$i++)print chr($i);
print '<pre>';print_r($list);die;*/
header('Content-Type: text/html; charset=utf-8');
header('P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"');
header('Cache-Control: no-store, no-cache, must-revalidate');
header('Cache-Control: post-check=0, pre-check=0', FALSE);
header('Pragma: no-cache');
header('Content-transfer-encoding: binary');
header('Content-Disposition: attachment; filename=export.xls');
header('Content-Type: application/octet-stream');
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("")->setLastModifiedBy("")->setTitle("Office 2007 XLSX")->setSubject("Office 2007 XLSX")->setDescription("Document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("GBROS file");
$sheet = $objPHPExcel->setActiveSheetIndex(0);
foreach ($list[0] as $i => $item) {
$sheet->setCellValue(Impexp::dfe($i) . '1', $item);
$sheet->getColumnDimension(Impexp::dfe($i))->setAutoSize(true);
}
foreach ($list as $i => $items) {
if ($i != 0) {
foreach ($items as $ii => $item) {
$sheet->setCellValue(Impexp::dfe($ii) . ($i + 1), $item);
$objPHPExcel->getActiveSheet()->getStyle(Impexp::dfe($ii) . ($i + 1))->getAlignment()->setWrapText(true);
}
}
}
$objPHPExcel->getActiveSheet()->setTitle('Лист 1');
$objPHPExcel->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
