0x1998 - MANAGER
Edit File: export_xls.php
<?php session_cache_limiter('private'); include "config/auth-config.php"; include "config/authcheck.php"; include "config/garde.php"; //$list=$_SESSION['list']; $requete=$_SESSION['requete']; $fichier=$_SESSION['fichier']; $debut=$_SESSION['debut']; $fin=$_SESSION['fin']; $onglet=$_SESSION['onglet']; $formats=$_SESSION['format']; require_once('config/excel/Worksheet.php'); require_once('config/excel/Workbook.php'); function HeaderingExcel($filename) { header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=".$filename ); header("Expires: 0"); header("Cache-Control: no-cache, post-check=0,pre-check=0"); header("Pragma: public"); } // HTTP headers HeaderingExcel($fichier); // Creating a workbook $workbook = new Workbook("-"); // Creating the first worksheet $worksheet1 =& $workbook->add_worksheet($onglet); // FORMAT DES COLONNES $format13 =& $workbook->add_format(); $format0 =& $workbook->add_format(); $format8 =& $workbook->add_format(); $format0->set_align('center'); $format0->set_pattern(); $format0->set_fg_color('red'); $format0->set_color('white'); $format0->set_bold('1'); $format13->set_num_format('00000'); $format13->set_align('left'); $format8->set_num_format('00 00 00 00 00'); $format8->set_align('center'); $worksheet1->set_column(0, 1, 25); $worksheet1->set_column(2, 2, 15); $worksheet1->set_column(6, 7, 15); $worksheet1->set_column(3, 3, 15); $worksheet1->set_column(7, 7, 15); $worksheet1->set_column(9, 9, 15); $worksheet1->set_column(11, 11, 15); $worksheet1->set_column(20, 20, 15); $worksheet1->set_column(23, 23, 15); $worksheet1->set_column(25, 25, 15); $result = mysqli_query($link,$requete) or die("requete impossible ... $sql"); // PREMIERE LIGNE : ENTETE $col=0; for ($i=$debut;$i<=$fin;$i++) { $worksheet1->write_string(0,$col,strtoupper(mysqli_field_name($result,$i)),$format0); $col++; } // LIGNES SUIVANTES $numligne=1; while ($info=mysqli_fetch_array($result)) { $col=0; for ($i=$debut;$i<=$fin;$i++) { //$format=($i!=5)? $format8 :$format13; $worksheet1->write($numligne,$col,$info[$i],$$formats[$i]); //$worksheet1->write($numligne,$col,$info[$i],$format); $col++; } $numligne=$numligne+1; } $workbook->close(); ?>