浏览器:IE
安全设置:默认
代码:
- <script>
- function readThis(){
- var tempStr = "";
- var filePath= document.all.upfile.value;
- var oXL = new ActiveXObject("Excel.application");
- var oWB = oXL.Workbooks.open(filePath);
- oWB.worksheets(1).select();
- var oSheet = oWB.ActiveSheet;
- try{
- for(var i=2;i<46;i++){
- if(oSheet.Cells(i,2).value =="null" || oSheet.Cells(i,3).value =="null" )
- break;
- var a = oSheet.Cells(i,2).value.toString()=="undefined"?"":oSheet.Cells(i,2).value;
- tempStr+=(" "+oSheet.Cells(i,2).value+
- " "+oSheet.Cells(i,3).value+
- " "+oSheet.Cells(i,4).value+
- " "+oSheet.Cells(i,5).value+
- " "+oSheet.Cells(i,6).value+"/n");
- }
- }catch(e){
- //alert(e);
- document.all.txtArea.value = tempStr;
- }
- document.all.txtArea.value = tempStr;
- oXL.Quit();
- CollectGarbage();
- }
- </script>
- <html>
- <input type="file" id="upfile" /><input type="button" οnclick="readThis();" value="读取">
- <br>
- <textarea id="txtArea" cols=50 rows=10></textarea>
- </html>
原文:http://blog.csdn.net/sainery/archive/2008/08/18/2790491.aspx