Affichage de données dans Excel

[vainuiz]

Bonjour à tous!

J'apprends avec le tutoriel de MaitrePylos à exporter les données de ma base MySQL vers Excel.

Mon script ouvre bien le fichier Excel et affiche seulement "UN"enregistrement alors que j'en ai au plus une quinzaine.

Pouvez-vous m'aider s'il vous plaît?

Je vous propose mon script.

Code :

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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
<?php
/** PHPExcel */
include 'Classes/PHPExcel.php';
include('config.php');
 
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
 
// Add some data
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Date');
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('A3', 'Banque');
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('B3', 'Compte');
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('C3', 'Intitule');
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('D3', 'Montant');
 
$sql="SELECT intituleCompte,noCompte,MontantT
FROM banque, t_societe, t_inventaire
WHERE banque.IdSoc= t_societe.IdSoc
ANd t_societe.IdSoc = t_inventaire.IdSoc";
$res=mysql_query($sql) or die ('Erreur affichage!');
 
while($data=mysql_fetch_row($res))
{
	$intitule=$data[0];
	$nocompte=$data[1];
	$montant=$data[2];
 
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A4', 'Banque SCOREDO');
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('B4', $intitule);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('C4', $nocompte);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('D4', $montant);	
}			
///////////////////////////////////////////////////////////////////////
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('F2', 'Details especes');
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('F3',10000);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F4',5000);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F5',1000);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F6',500);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F7',100);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F8',100);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F9',50);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F10',20);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F11',10);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F12',5);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F13',2);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F14',1);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('F15','TOTAL');			
 
$sql="SELECT B10000,B5000,B1000,B500,P100,P100bis,P50,P20,P10,P5,P2,P1,MontantT
FROM t_inventaire";
$res=mysql_query($sql) or die ('Erreur affichage détail espèce!');
 
while($data=mysql_fetch_row($res))
{
	$B10000=$data[0];
	$B5000=$data[1];
	$B1000=$data[2];
	$B500=$data[3];
	$P100=$data[4];
	$P100bis=$data[5];
	$P50=$data[6];
	$P20=$data[7];
	$P10=$data[8];
	$P5=$data[9];
	$P2=$data[10];
	$P1=$data[11];
	$MontantT=$data[12];
 
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('G3',$B10000);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G4',$B5000);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G5',$B1000);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G6',$B500);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G7',$P100);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G8',$P100bis);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G9',$P50);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G10',$P20);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G11',$P10);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G12',$P5);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G13',$P2);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G14',$P1);
$objPHPExcel->setActiveSheetIndex(0)
			->setCellValue('G15',$MontantT);
}
 
///////////////////////////////////////////////////////////////////////			
 
//Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Depot.xls"');
header('Cache-Control: max-age=0');
 
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
?>

Merci par avance.

J'utilise la dernière version de EasyPHP, MySQL dernière version également.