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 73 74 75 76 77 78 79 80 81 82 83 84
|
<?php
include 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$tableau[0]=['ID_CODIF' => 1,
'ID_GROUPECODIF' => 50,
'VALEUR' => 'Demande de démonstration',
'ORDRE' => 0,
'ETAT' => 0,
'OPTN' => 0,
'HIDEHTL' => 0,
'REGROUPER' => 0
];
$tableau[1] = [
'ID_CODIF' => 2,
'ID_GROUPECODIF' => 50,
'VALEUR' => 'Demande de devis',
'ORDRE' => 1,
'ETAT' => 0,
'OPTN' => 0,
'HIDEHTL' => 0,
'REGROUPER' => 0
];
$tableau[2] = [
'ID_CODIF' => 3,
'ID_GROUPECODIF' => 50,
'VALEUR' => 'Demande entrante',
'ORDRE' => 2,
'ETAT' => 0,
'OPTN' => 0,
'HIDEHTL' => 0,
'REGROUPER' => 0
];
$tableau[3] = [
'ID_CODIF' => 4,
'ID_GROUPECODIF' => 50,
'VALEUR' => 'appel d\'offre',
'ORDRE' => 3,
'ETAT' => 0,
'OPTN' => 0,
'HIDEHTL' => 0,
'REGROUPER' => 0
];
$filename = "file.xlsx";
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
/**
* On crée les entêtes
*/
$t = current($tableau);
$i=1;
foreach ($t as $key => $value) {
$sheet->setCellValueByColumnAndRow($i, 1, $key);
$i++;
}
/**
* On crée les données
*/
$i = 2;
foreach ($tableau as $value) {
$j = 1;
foreach ($value as $v) {
$sheet->setCellValueByColumnAndRow($j, $i, $v);
$j++;
}
$i++;
}
$writer = new Xlsx($spreadsheet);
/**
* Envoie le fichier dans le navigateur
*/
$header = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
header('Content-type:' . $header);
header('Content-Disposition:inline;filename=' . $filename);
$writer->save('php://output'); |
Partager