JavaScript 读取excel

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<html>
<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;
        var strSheetName = "Sheet1$";
        var rsTemp = new ActiveXObject("ADODB.Recordset");
        rsTemp = objCon.OpenSchema(20);
        while(!rsTemp.EOF)
        {
                if (rsTemp("TABLE_TYPE")=="TABLE")
                {
                        //alert(rsTemp("TABLE_NAME"));
                        rsExcel = new ActiveXObject("ADODB.Recordset");
                        strQuery = "SELECT * FROM [" + rsTemp("TABLE_NAME") + "]";
                        rsExcel.ActiveConnection = objCon;
                        rsExcel.Open(strQuery);
                        mm=rsTemp("TABLE_NAME")+"表内容<br><table  border='1' cellspacing='0' cellpadding='0'>"
                        for(i = 0;i<rsExcel.Fields.Count;++i)
                                {
                                        mm=mm+"<td>"+rsExcel.Fields(i).name+"</td>";
                                }
                        while(!rsExcel.EOF)
                        {
                                mm=mm+"<tr>"
                                for(i = 0;i<rsExcel.Fields.Count;++i)
                                {
                                        mm=mm+"<td>"+rsExcel.Fields(i).value+"</td>";
                                }
                                mm=mm+"</tr>"
                                rsExcel.MoveNext;
                        }
                }
                document.write(mm+"</table><br>")
                mm=""
                rsExcel = null
                rsTemp.MoveNext;
        }
        objCon.Close;
        objCon =null;
        rsExcel = null;
}
</script>
</head>
<body>
<input type="file" id="f" />
<input type="button" id="b" value="显示工作簿内容" onClick="if(f.value=='')alert('请选择xls文件');else importXLS(f.value)" />
</body>
</html>

 

posted @   StormeR  阅读(977)  评论(0编辑  收藏  举报
编辑推荐:
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· Linux系列:如何用heaptrack跟踪.NET程序的非托管内存泄露
阅读排行:
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· Manus的开源复刻OpenManus初探
· AI 智能体引爆开源社区「GitHub 热点速览」
· 三行代码完成国际化适配,妙~啊~
· .NET Core 中如何实现缓存的预热?
点击右上角即可分享
微信分享提示