54 lines
2.2 KiB
PHP
54 lines
2.2 KiB
PHP
<?php session_start();
|
|
|
|
|
|
require_once '../PHPExcel.php';
|
|
|
|
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
|
|
header('Content-Disposition: attachment;filename="'.date("Y-m-d").'_zrzut_wody_na_odprowadzalniki.xlsx"');
|
|
header('Cache-Control: max-age=0');
|
|
|
|
$styleArray = array(
|
|
'font' => array(
|
|
'bold' => true,
|
|
'size' => 16,
|
|
'color' => array('rgb' => 'B22222')
|
|
));
|
|
$styleArray1 = array(
|
|
'font' => array(
|
|
'bold' => true,
|
|
));
|
|
|
|
$objPHPExcel = new PHPExcel();
|
|
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:F1');
|
|
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(25);
|
|
$objPHPExcel->getActiveSheet()->getStyle('A1:F1')->applyFromArray($styleArray);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Zrzut wody na odprowadzalniki '.str_replace('Dębina', 'P/Bełchatów - bariera ochronna Dębina', $_SESSION['syndis_eq_stock']) );
|
|
|
|
|
|
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A2:F2');
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('A2', 'Data '.$_SESSION['rap003_array_date']);
|
|
|
|
$kolumna=4;
|
|
|
|
for($i=0;$i<count($_SESSION['rap003_array']);$i++)
|
|
{
|
|
|
|
//$objPHPExcel->getActiveSheet()->SetCellValue('A'.($kolumna+$i), $_SESSION['rap003_array'][$i]['col_1']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('A'.($kolumna+$i), $_SESSION['rap003_array'][$i]['col_2']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('B'.($kolumna+$i), $_SESSION['rap003_array'][$i]['col_3']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('C'.($kolumna+$i), $_SESSION['rap003_array'][$i]['col_4']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('D'.($kolumna+$i), $_SESSION['rap003_array'][$i]['col_5']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('E'.($kolumna+$i), $_SESSION['rap003_array'][$i]['col_6']);
|
|
$objPHPExcel->getActiveSheet()->SetCellValue('F'.($kolumna+$i), $_SESSION['rap003_array'][$i]['col_7']);
|
|
|
|
if($_SESSION['rap003_array'][$i]['znacznik']=='blue' || $_SESSION['rap003_array'][$i]['znacznik']=='red')
|
|
$kolumna++;
|
|
|
|
}
|
|
|
|
|
|
$objPHPExcel->getActiveSheet()->setTitle('Zrzut wody na odprowadzalniki');
|
|
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
|
|
$objWriter->save('php://output');
|
|
exit;
|
|
?>
|