作者:温思家羽绒家纺旗舰店 | 来源:互联网 | 2018-07-17 06:14
ec(2);php读取execel文档<?php$pathrealpath("Book1.xls");创建ADO对象$adonewCOM("ADODB.Connection")ordie("ADOInitFailt");$ado->Open("DRIVER{Micr
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;
}
?>