php读取execel文档

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);
?>

 
   
   
 
   
   
 
   
 
   while(!$rs->eof())
{
  ?>
 
   
   
 
   
   
 
   
 
    $rs->movenext;
  }
  ?>

ID	UNM	EMAIL	QQ	Phone	Other