55 lines
2.2 KiB
PHP
55 lines
2.2 KiB
PHP
<?php session_start();
|
|
/**
|
|
* Created by PhpStorm.
|
|
* User: Przemek
|
|
* Date: 2015-10-15
|
|
* Time: 01:16
|
|
*/
|
|
|
|
//require_once '../PHPExcel.php';
|
|
require_once '/PHPExcel.php';
|
|
|
|
//header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
|
|
//header('Content-Disposition: attachment;filename="rap001.xlsx"');
|
|
//header('Cache-Control: max-age=0');
|
|
|
|
$styleArray = array(
|
|
'font' => array(
|
|
'bold' => true,
|
|
'size' => 16
|
|
));
|
|
|
|
$objPHPExcel = new PHPExcel();
|
|
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:G1');
|
|
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(25);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1:G1')->applyFromArray($styleArray);
|
|
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Wykaz energochłonności dla studni');
|
|
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('A2', 'Lp.');
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('B2', 'Studnia');
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('C2', 'Bariera');
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('D2', 'Energochłonność');
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('E2', 'Opis');
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('F2', 'Oddział');
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('G2', 'Data');
|
|
|
|
|
|
for($i=0;$i<count($_SESSION['resRap001']);$i++)
|
|
{
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('A'.($i+3), $i+1);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('B'.($i+3), $_SESSION['resRap001'][$i]['WLL_NAME']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('C'.($i+3), $_SESSION['resRap001'][$i]['SOD_UJ']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('D'.($i+3), $_SESSION['resRap001'][$i]['RDD_VALUE']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('E'.($i+3), $_SESSION['resRap001'][$i]['SOD_DESC']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('F'.($i+3), $_SESSION['resRap001'][$i]['SOD_PLC']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('G'.($i+3), $_SESSION['resRap001'][$i]['RDD_AUDIT_DATE']);
|
|
|
|
|
|
}
|
|
$objPHPExcel->getActiveSheet()->setTitle('Wykaz energochłonności');
|
|
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
|
|
//$objWriter->save('php://output');
|
|
$objWriter->save('rap001.xlsx');
|
|
exit;
|
|
?>
|