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 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
| $sheet->setCellValueByColumnAndRow(0,1,'identifiant' );
$sheet->setCellValueByColumnAndRow(1,1,'code' );
$sheet->setCellValueByColumnAndRow(2,1,'sexe' );
$sheet->setCellValueByColumnAndRow(3,1,'age' );
$sheet->setCellValueByColumnAndRow(4,1,'composition' );
$sheet->setCellValueByColumnAndRow(5,1,'nombreEnfants_3ans' );
$sheet->setCellValueByColumnAndRow(6,1,'nombreEnfants_matpri' );
$sheet->setCellValueByColumnAndRow(7,1,'nombreEnfants_sec' );
$sheet->setCellValueByColumnAndRow(8,1,'nombreTotalEnfants' );
$sheet->setCellValueByColumnAndRow(9,1,'modeGardeActuel' );
$sheet->setCellValueByColumnAndRow(10,1,'depose' );
$sheet->setCellValueByColumnAndRow(11,1,'organisation' );
$sheet->setCellValueByColumnAndRow(12,1,'choixModeGarde' );
$sheet->setCellValueByColumnAndRow(13,1,'employeur' );
$sheet->setCellValueByColumnAndRow(14,1,'raison' );
$sheet->setCellValueByColumnAndRow(15,1,'maniere' );
$sheet->setCellValueByColumnAndRow(16,1,'horairesLundi' );
$sheet->setCellValueByColumnAndRow(17,1,'horairesMardi' );
$sheet->setCellValueByColumnAndRow(18,1,'horairesMercredi' );
$sheet->setCellValueByColumnAndRow(19,1,'horairesJeudi' );
$sheet->setCellValueByColumnAndRow(20,1,'horairesVendredi' );
$sheet->setCellValueByColumnAndRow(21,1,'horairesLundiP' );
$sheet->setCellValueByColumnAndRow(22,1,'horairesMardiP' );
$sheet->setCellValueByColumnAndRow(23,1,'horairesMercrediP' );
$sheet->setCellValueByColumnAndRow(24,1,'horairesJeudiP' );
$sheet->setCellValueByColumnAndRow(25,1,'horairesVendrediP' );
$sheet->setCellValueByColumnAndRow(26,1,'attentes' );
$sheet->setCellValueByColumnAndRow(27,1,'estivale' );
$sheet->setCellValueByColumnAndRow(28,1,'residence' );
$sheet->setCellValueByColumnAndRow(29,1,'remarques' );
$sheet->setCellValueByColumnAndRow(30,1,'dateHeure' );
$ligne = 2;
while($data = $req->fetch()){
$colonne=0;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['identifiant']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['code']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['sexe']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['age']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['composition']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['nombreEnfants_3ans']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['nombreEnfants_matpri']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['nombreEnfants_sec']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['nombreTotalEnfants']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['modeGardeActuel']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['depose']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['organisation']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['choixModeGarde']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['employeur']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['raison']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['maniere']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesLundi']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesMardi']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesMercredi']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesJeudi']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesVendredi']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesLundiP']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesMardiP']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesMercrediP']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesJeudiP']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['horairesVendrediP']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['attentes']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['estivale']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['residence']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['remarques']);$colonne++;
$sheet->setCellValueByColumnAndRow($colonne, $ligne, $data['dateHeure']);$colonne++;
$ligne++;//ligne suivante
} |
Partager