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
| <?php
// Nous donnons un chemin à notre fichier ici
$server="mon serveur";
$username="";
$password="";
$sqlconnect=mssql_connect($server, $username, $password);
$sqldb=mssql_select_db("BYBLOS",$sqlconnect);
$result = mssql_query("SELECT * from byblos.dbo.CLIENT_PARTENARIAT,byblos.dbo.C1_PARTENARIAT2
where byblos.dbo.CLIENT_PARTENARIAT.INDICE = byblos.dbo.C1_PARTENARIAT2.INDICE
and byblos.dbo.C1_PARTENARIAT2.LIB_STATUS LIKE 'RDV'
and byblos.dbo.C1_PARTENARIAT2.DATE like '20080412'");
$nombre = mssql_num_rows($result);
$date = Date("d-m-Y");
$ch1="extract_";
$ch3="_14h";
$nom_fichier=$ch1.$date.$ch3;
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$workbook->send('test.xls');
$worksheet =& $workbook->addWorksheet('');
$j=$nombre;
$worksheet->write(0,0,'CIVILITE');
$worksheet->write(0,1,'NOM');
$worksheet->write(0,2,'PRENOM');
$worksheet->write(0,3,'ADR1');
$worksheet->write(0,4,'ADR2');
$worksheet->write(0,5,'ADR3');
$i=0;
while( $row = mssql_fetch_array($result))
{
$i=$i+1;
$NOM=$row["NOM"];
$PRENOM=$row["PRENOM"];
$worksheet->write($i,0,$row["CIVILITE"]);
$worksheet->write($i,1,$row["NOM"]);
$worksheet->write($i,2,$row["PRENOM"]);
$worksheet->write($i,3,$row["ADR1"]);
$worksheet->write($i,4,$row["ADR2"]);
$worksheet->write($i,5,$row["ADR3"]);
$worksheet->write
}
$workbook->close();
?> |
