首頁 > 開發者 > JavaScript
有些時候我們的網站提供給客戶資料匯入匯出功能，通常選擇媒介格式為xls，下面是用JavaScript完成對用戶端xls資料的載入：
<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" onclick="if(f.value=='')alert('請選擇xls檔案');else importXLS(f.value)"></body></html> |
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
