php读取execel文档
php读取execel文档
<?php
$path = realpath("Book1.xls");
//创建ADO对象
$ado = new COM("ADODB.Connection") or die("ADO Init Failt");
$ado -> Open("DRIVER={Microsoft Excel Driver (*.xls)};dbq=".$path);
//选择工作表请用:[表名称$]
$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="25" 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="25" align="center" bgcolor="#FFFFFF"><?=$rs["phone"]?></td>
<td align="center" bgcolor="#FFFFFF"><?=$rs["other"]?></td>
</tr>
<?php
$rs->movenext;
}
?>
</table>
本文地址:http://www.phprm.com/code/a5eb05276a6e2c8483aa00e817945b36.html
转载随意,但请附上文章地址:-)