<html> <head> <title>Untitled</title> <script> 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> |
有些时候我们的站点提供给客户数据导入导出功能,通常选择媒介格式为xls,下面是用JavaScript完成对客户端xls数据的载入:
转载于:https://www.cnblogs.com/Truly/archive/2005/09/19/239993.html