1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
// Titre de la feuille
$objPHPExcel->getActiveSheet()->setTitle('Normal');
$objPHPExcel->getActiveSheet()->setCellValue('B1','Année Universitair :'.$AneUniv);//Ici nous écrivons dans une cellule.
$objPHPExcel->getActiveSheet()->setCellValue('B3','Enseignat :');
$objPHPExcel->getActiveSheet()->setCellValue('C3',$NomEns);
$objPHPExcel->getActiveSheet()->setCellValue('B5','Semestre :');
$objPHPExcel->getActiveSheet()->setCellValue('C5',$Semestre);
$objPHPExcel->getActiveSheet()->setCellValue('B7','Matiere :');
$objPHPExcel->getActiveSheet()->setCellValue('C7',$Matiere);
$objPHPExcel->getActiveSheet()->setCellValue('B9','Etudinat Normal');
$objPHPExcel->getActiveSheet()->setCellValue('A11','NINS');
$objPHPExcel->getActiveSheet()->setCellValue('B11','Nom');
$objPHPExcel->getActiveSheet()->setCellValue('C11','PRENOM');
$objPHPExcel->getActiveSheet()->setCellValue('D11','NOTE DS');
$objPHPExcel->getActiveSheet()->setCellValue('E11','NOTE EVALUATION');
$objPHPExcel->getActiveSheet()->setCellValue('F11','MOYENNE');
$li=12;
foreach($TblEtuNorm as $Etu){
$objPHPExcel->getActiveSheet()->setCellValue('A'.$li,$Etu['nins']);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$li,$Etu['nom_etudiant']);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$li,$Etu['prenom_etudiant']);
$li++;
}
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save($Matiere.'.xlsx'); |
Partager