可以读取EXCEL文件的js代码.docVIP

可以读取EXCEL文件的js代码 js读取 EXCEL 文件 的实现代码，比较全了大家可以自行测试了。首页给个有中文说明的例子，下面的例子很多大家可以多测试。代码如下:script language=javascript type=text/javascript!-- function readExcel() { var excelApp; var excelWorkBook; var excelSheet; try{ excelApp = new ActiveXObject(Excel.Application); excelWorkBook = excelApp.Workbooks.open(C:\\XXX.xls); excelSheet = oWB.ActiveSheet; //WorkSheets(sheet1) excelSheet.Cells(6,2).value;//cell的值 excelSheet.usedrange.rows.count;//使用的行数 excelWorkBook.Worksheets.count;//得到sheet的个数 excelSheet=null; excelWorkBook.close(); excelApp.Application.Quit(); excelApp=null; }catch(e){ if(excelSheet !=null || excelSheet!=undefined){ excelSheet =nul; } if(excelWorkBook != null || excelWorkBook!=undefined){ excelWorkBook.close(); } if(excelApp != null || excelApp!=undefined){ excelApp.Application.Quit(); excelApp=null; } } // --/script 代码如下:如果是在网页上打开EXCEL 文件，那么在关闭的时候，进程里还有EXCEL.EXE，所以必须关闭后，刷新本页面！script function ReadExcel() { 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;i46;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) { document.all.txtArea.value = tempStr; } document.all.txtArea.value = tempStr; oXL.Quit(); CollectGarbage(); } /script html input type=file id=upfile /input type=button onclick=ReadExcel(); value=read br textarea id=txtArea cols=50 rows=10/textarea /html 二、 js读取excel文件 代码如下:script function readThis(){ var tempStr = ; var filePath= document.all.upfile.value; var oXL = new ActiveXObject(Excel.application); var oWB = oXL.Workbooks.open(filePa