array(
'bold' => true,
'size' => 16
));
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:C1');
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(25);
$objPHPExcel->getActiveSheet()->getStyle('A1:C1')->applyFromArray($styleArray);
// dla piezometrów
if (!empty($_SESSION['site404pdet_array']))
{
$_SESSION['site401pdet_array']=$_SESSION['site404pdet_array'];
$_SESSION['site401pdet_dic'][0]['DIC_POL_LANG'] = 'Zwierciadło statyczne HST [m]';
}
$objPHPExcel->getActiveSheet()->SetCellValue('A1', str_replace(array('','','',''), array('','','',''), $_SESSION['site401pdet_dic'][0]['DIC_POL_LANG']));
$objPHPExcel->getActiveSheet()->SetCellValue('A2', 'Lp.');
$objPHPExcel->getActiveSheet()->SetCellValue('B2', 'Data pomiaru');
$objPHPExcel->getActiveSheet()->SetCellValue('C2', 'Wartość');
for($i=0;$igetActiveSheet()->SetCellValue('A'.($i+3), $i+1);
$objPHPExcel->getActiveSheet()->SetCellValue('B'.($i+3), $_SESSION['site401pdet_array'][$i]['water_audit']);
$objPHPExcel->getActiveSheet()->SetCellValue('C'.($i+3), $_SESSION['site401pdet_array'][$i]['water_value']);
}
$objPHPExcel->getActiveSheet()->setTitle('Lista pomiarów');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;
?>