Aller je reposte le code, à force de tout changer on va plus savoir où ca en est =>
<?php
include("global.inc.php");
require_once "class.writeexcel_workbook.inc.php";
require_once "class.writeexcel_worksheet.inc.php";
// BDD stuff / pas encore créé, on verra après :)
$query = "SELECT Chassis, Montant, Avenant, Nature, Lieu, Details, MarqueurV, vehicules.idLot FROM vehicules INNER JOIN lots ON vehicules.idLot = lots.idLot AND lots.idLot = '$_GET[idLot]'";
$requeteID = mysql_query($query);
// Fin des trucs BDD
$FileCodeLotName = ereg_replace(' ','_',$NomClient.'-'.$codeLot.'.xls');
$fname = tempnam('d:\Sites\yyyyyy\tmp', 'xls');
$workbook =& new writeexcel_workbook($fname);
$worksheet =& $workbook->addworksheet("$codeLot");
$worksheet->set_column('A:A', 20);
#######################################################################
#
# Ecriture du code Lot, du NomClient et du Transporteur : A1 > G1
#
//$worksheet->set_column('A:G', 15);
$heading =& $workbook->addformat(array(
bold => 1,
color => 'blue',
size => 12,
merge => 1,
border => 2,
));
$headings = array("$codeLot",'',"$NomClient",'','','','test');
$worksheet->write_row('A1', $headings, $heading);
#######################################################################
#
#
#
$text_format =& $workbook->addformat(array(
bold => 1,
italic => 1,
color => 'white',
size => 10,
border => 2,
align => 'center',
fg_color => 'grey'));
$tableHeader = array('VIN','Montant','Avenant','Nature','Lieu','Détails','Etat');
$worksheet->write_row('A2',$tableHeader,$text_format);
$text_format2 =& $workbook->addformat(array(size=>8,align=>'center',border=>1));
$i=2;
while ($data = mysql_fetch_assoc($requeteID))
{
$i = $i + 1;
$MontantTotal = $MontantTotal + $data['Montant'];
$chassisRow = array("$data[Chassis]","$data[Montant]","$data[Avenant]","$data[Nature]","$data[Lieu]","$data[Details]","$data[MarqueurV]");
$worksheet->write('A'.$i,$chassisRow,$text_format2);
}
$i = $i + 1;
$LastRow = array("Total","$MontantTotal",'','',"$i","véhicules","");
$worksheet->write_row('A'.$i,$LastRow,$heading);
// Fin de la création du fichier excel
$workbook->close();
header("Content-Type: application/x-msexcel; name=\"example-demo.xls\"");
header("Content-Disposition: inline; filename=\"example-demo.xls\"");
$fh=fopen($fname, "rb");
fpassthru($fh);
unlink($fname);
?>