js实现excel数据导入

最新推荐文章于 2024-07-30 11:29:23 发布

APOLLO_TS

最新推荐文章于 2024-07-30 11:29:23 发布

阅读量1.2w

点赞数

文章标签： excel properties javascript null input button

JavaScript 专栏收录该内容

34 篇文章 0 订阅

订阅专栏

js实现excel数据导入

<html xmlns=" http://www.w3.org/1999/xhtml" >
<head>
    <title>Untitled Page</title>
</head>
<script language="javascript" type="text/javascript">
function importXLS(fileName)
{
    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;
    //Get the SheetName
    var strSheetName = "Sheet1$";
    var rsTemp = new ActiveXObject("ADODB.Recordset");
    rsTemp = objCon.OpenSchema(20);
    if(!rsTemp.EOF)
    strSheetName = rsTemp.Fields("Table_Name").Value;

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;
    }
    // Close the connection and dispose the file
    objCon.Close;
    objCon =null;
    rsExcel = null;
}
</script>
</head>
<body>
<input type="file" id="f" />
<input type="button" id="b" value="import" οnclick="if(f.value=='')alert('请选择xls文件');else importXLS(f.value)" />
</body>
</html>