ie浏览器用js读取excel数据

来源：互联网发布：js内置对象有哪些编辑：程序博客网时间：2024/05/29 07:08

在网上看到他人的方法，在ie上可以实现

<head>
<title>Untitled Page</title>
</head>
<script language="javascript" type="text/javascript">
function importXLS(fileName)
{
//设置连接
var objCon = new ActiveXObject("ADODB.Connection");
objCon.Provider = "Microsoft.Jet.OLEDB.4.0";//连接对象
objCon.ConnectionString = "Data Source=" + fileName + ";Extended Properties=Excel 8.0;";//连接源
objCon.CursorLocation = 1;
objCon.Open;


//设置结果集
var strQuery;
var strSheetName = "Sheet1$";

var rsTemp = new ActiveXObject("ADODB.Recordset");//获取记录集对象
rsTemp = objCon.OpenSchema(20);
if(!rsTemp.EOF)//没有记录集的结尾
strSheetName = rsTemp.Fields("Table_Name").Value;//获取sheet的名称

rsTemp = null;
rsExcel = new ActiveXObject("ADODB.Recordset");
strQuery = "SELECT * FROM [" + strSheetName + "]";
rsExcel.ActiveConnection = objCon;
rsExcel.Open(strQuery);
while(!rsExcel.EOF){
for(i = 0;i<rsExcel.Fields.Count;++i){
alert(rsExcel.Fields(i).value);
}
rsExcel.MoveNext;
}

//关闭链接
objCon.Close;
objCon =null;
rsExcel = null;
}
</script>
</head>
<body>
<input type="file" id="f" />
<input type="button" id="b" value="import" onclick="if(f.value=='')alert('请选择xls文件');else importXLS(f.value)" />
</body>
</html>

0 0