PHP reads Execel document
<?php
$path = Realpath ("Book1.xls");
Create an ADO Object
$ado = new COM ("ADODB. Connection ") or Die (" ADO Init failt ");
$ado-> Open ("Driver={microsoft Excel DRIVER (*.xls)};d bq=". $path);
To select a worksheet, use: [Table name $]
$sql = "SELECT * FROM [user$]";
$rs = $ado->execute ($sql);
?>
<table width= "100%" border= "0" cellpadding= "0" cellspacing= "1" bgcolor= "#CCCCCC" >
<tr>
<TD align= "center" >ID</td>
<TD align= "center" >UNM</td>
<TD align= "center" >EMAIL</td>
<TD align= "center" >QQ</td>
<TD height= "align=" "Center" >Phone</td>
<TD align= "center" >Other</td>
</tr>
<?php
while (! $rs->eof ())
{
?>
<tr>
<TD align= "center" bgcolor= "#FFFFFF" ><?= $rs ["ID"]?></td>
<TD align= "center" bgcolor= "#FFFFFF" ><?= $rs ["UNM"]?></td>
<TD align= "center" bgcolor= "#FFFFFF" ><?= $rs ["Email"]?></td>
<TD align= "center" bgcolor= "#FFFFFF" ><?= $rs ["QQ"]?></td>
<TD height= align= "center" bgcolor= "#FFFFFF" ><?= $rs ["Phone"]?></td>
<TD align= "center" bgcolor= "#FFFFFF" ><?= $rs ["Other"]?></td>
</tr>
<?php
$rs->movenext;
}
?>
</table>