【www.gdgbn.com--面向对象编程】
php读取execel文档
$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);
?>
ID
UNM
EMAIL
QQ
Phone
Other
while(!$rs->eof())
{
?>
=$rs["ID"]?>
=$rs["unm"]?>
=$rs["email"]?>
=$rs["qq"]?>
=$rs["phone"]?>
=$rs["other"]?>
$rs->movenext;
}
?>