Javascript从外部Excel文件中读取数据

以下是实现该功能的函数代码：

//读取Excel内容 http://yige.org
     function f_ReadExcel() {
         $("#btnYes")[0].disabled = true;
         var filePath = $("#txtFile")[0].value;
         if (filePath == "" || filePath == null || filePath == "undefined") {
             alert("请选择一个Excel文档");
             return;
         }
         var oXL = new ActiveXObject("Excel.application");
         var oWB = oXL.Workbooks.open(filePath);
         oWB.worksheets(1).select();
         var oSheet = oWB.ActiveSheet;
         try {
             var count = $("#count")[0];
             var i = parseInt(count.value);
             var j = 2;
             if (i == 1) {
                 if ($("#txtEnglishName" + i)[0].value == "") {
                     --i;
                 }
             }
             while(true)
             {
                 if (oSheet.Cells(j, 1).value == undefined || oSheet.Cells(j, 3).value == undefined || oSheet.Cells(j, 6).value == undefined)
                 {
                     break;
                 }
                 f_AddRow();
                 i++;
                 $("#txtLoadingDate" + i)[0].value = f_ToDate(oSheet.Cells(j, 1).value);
                 $("#txtPONumber" + i)[0].value = oSheet.Cells(j, 2).value == undefined ? "" : oSheet.Cells(j, 2).value;
                 $("#txtEnglishName" + i)[0].value = oSheet.Cells(j, 3).value;
                 $("#txtProductName" + i)[0].value = oSheet.Cells(j, 4).value == undefined ? "" : oSheet.Cells(j, 4).value;
                 $("#txtISBN" + i)[0].value = oSheet.Cells(j, 5).value == undefined ? "" : oSheet.Cells(j, 5).value;
                 $("#txtQuantity" + i)[0].value = oSheet.Cells(j, 6).value;
                 $("#txtQtyPerCarton" + i)[0].value = oSheet.Cells(j, 7).value == undefined ? 0 : oSheet.Cells(j, 7).value;
                 $("#txtCarton" + i)[0].value = oSheet.Cells(j, 8).value == undefined ? 0 : oSheet.Cells(j, 8).value;
                 $("#txtCtnPerCrate" + i)[0].value = oSheet.Cells(j, 9).value == undefined ? 0 : oSheet.Cells(j, 9).value;
                 $("#txtCrate" + i)[0].value = oSheet.Cells(j, 10).value == undefined ? 0 : oSheet.Cells(j, 10).value;
                 $("#txtCW" + i)[0].value = oSheet.Cells(j, 11).value == undefined ? 0 : oSheet.Cells(j, 11).value;
                 $("#txtCtnSize" + i)[0].value = oSheet.Cells(j, 12).value == undefined ? "" : oSheet.Cells(j, 12).value;
                 $("#txtProductSize" + i)[0].value = oSheet.Cells(j, 13).value == undefined ? "" : oSheet.Cells(j, 13).value;
                 $("#txtCrSize" + i)[0].value = oSheet.Cells(j, 14).value == undefined ? "" : oSheet.Cells(j, 14).value;
                 $("#txtTailSize" + i)[0].value = oSheet.Cells(j, 15).value == undefined ? "" : oSheet.Cells(j, 15).value;
                 $("#txtVolume" + i)[0].value = oSheet.Cells(j, 16).value == undefined ? 0 : f_Round(oSheet.Cells(j, 16).value, 2);
                 $("#txtNWPerCarton" + i)[0].value = oSheet.Cells(j, 17).value == undefined ? 0 : f_Round(oSheet.Cells(j, 17).value, 2);
                 $("#txtGWPerCarton" + i)[0].value = oSheet.Cells(j, 18).value == undefined ? 0 : f_Round(oSheet.Cells(j, 18).value, 2);
                 $("#txtNWT" + i)[0].value = oSheet.Cells(j, 19).value == undefined ? 0 : f_Round(oSheet.Cells(j, 19).value, 2);
                 $("#txtGWT" + i)[0].value = oSheet.Cells(j, 20).value == undefined ? 0 : f_Round(oSheet.Cells(j, 20).value, 2);
                 $("#txtUnitPrice" + i)[0].value = oSheet.Cells(j, 21).value == undefined ? 0 : f_Round(oSheet.Cells(j, 21).value, 4);
                 $("#txtAmount" + i)[0].value = oSheet.Cells(j, 22).value == undefined ? 0 : f_Round(oSheet.Cells(j, 22).value, 2);
                 $("#txtRemark" + i)[0].value = oSheet.Cells(j, 23).value == undefined ? "" : oSheet.Cells(j, 23).value;
                 j++;
             }
             setTimeout(f_AutoCalSum, 500);
             $("#btnNo")[0].click();         
         } catch (e) {
             $("#btnNo")[0].click(); 
         }
         oXL.Quit();
         CollectGarbage();
     }

相关文章

• Javascript创建一个选择文件的弹窗 2012/06/16
• Javascript把数据导出到外部Excel文档 2012/06/16
• js禁止刷新_屏蔽Alt+F4的代码 2012/06/14
• JS把预定义的字符转换为HTML实体的函数htmlspecialchars 2012/06/07
• JS函数中arguments对象的使用 2012/06/05
• javascript回调函数及推论 2012/05/30
• JS动态创建带name的iframe在IE下跳转问题 2012/05/28
• JS实现俄罗斯方块 2012/05/24
• JavaScript编码模式 2012/05/23
• javascript处理与当前时间间隔的函数 2012/05/23