Java,J2EE,Weblogic,Oracle

          java項目隨筆
          隨筆 - 90, 文章 - 6, 評論 - 61, 引用 - 0
          數(shù)據(jù)加載中……

          JavaScript 操作excel 或word

          /////////////////////////////////////////// Parameter ///////////////////////////////////
          var winSelector = 0;
          var previousOpenedWindow   = 0;

          String.prototype.StrLenGB2312 = function(){
              var liLen = 0;
           for(liLoop = 0; liLoop< this.length;liLoop++){
             var c = this.charAt(liLoop);
               if ((escape(c)).length == (c.length) * 6 )
                liLen += 2;
               else
                 liLen ++;
             }
             return liLen;
          }

          String.prototype.StrLenUTF8 = function(){
           var liLen = 0;
           for(liLoop = 0; liLoop< this.length;liLoop++){
             var c = this.charAt(liLoop);
               if ((escape(c)).length == (c.length) * 6 )
                liLen += 3;
               else
                 liLen ++;
             }
             return liLen;
          }
          ////////////////////////////////////////////Business Function ////////////////////////
          //////////////////////////////////////////////////
          //  Attachment
          //////////////////////////////////////////////////
          function updateAttachment(formName, attachment, attachment_id, attachmentNameMessage, tableCode, srcID, originalAttachmentName) {
              var form = document.forms[formName]
              var attachmentIDs = form.elements[attachment];
           openSelector( servletPath + 'uploadFile?subCmd=requestUploadFile&formName=' + formName + '&tableCode=' + tableCode + '&srcID=' + srcID + '&attachment=' + attachment + '&attachment_id=' + attachment_id + '&attachmentNameMessage=' + attachmentNameMessage + '&originalAttachment=' + originalAttachmentName + '&originalAttachmentIDs=' + attachmentIDs.value, 'updateAttachment', 620, 400)
          }


          /////////////////////////////////////////////  Basic Funciton /////////////////////////
          function openSelector(url, title, width, height) {
              if(!checkSelector()) return;
              winSelector = window.open(url, title,"width="+width+",height="+height+","+"status=0,scrollbars=1,resizable=1,left=0,top=0,dependent=1");
              winSelector.focus();
              return winSelector;
          }

          function checkSelector() {
              if(winSelector && !winSelector.closed) {
                  winSelector.focus();
                  return 0;
              }
              return 1;
          }
          var dateField;
          function selectDate(pDateFormName, pDateFieldName){
              var form = document.forms[pDateFormName];
              dateField = form.elements[pDateFieldName];
              openSelector(jsPath + 'chooseDate.html', 'chooseDate', 300,275);
          }
          function setDateValue(dateValue){
           dateField.value = dateValue;
          }
          function gotoPage_1(formName,purposePages){
           //alert("1");
           //var form = document.forms[formName]
           //var tt = 'document.' + formName + '.purpoasePage.value = ' + purposePages;
           //eval(tt);
           //var ss = 'document.' + formName + '.submit()';
           //eval(ss);
           //var form = document.forms[formName];
           //alert("2");
           //var purpoasePage = form.elements['purpoasePage'];
           //purposePage.value = purposePages;
           //alert("3");
           //form.submit();
          }

          function openWin(url, title, width, height) {
           window.open(url, title,"width="+width+",height="+height+",status=no,scrollbars=1,resizable=1");
          }

          function selectEmployee(formName, fieldName, hiddenFieldName, departmentFieldName) {
              var form = document.forms[formName]
           var appendString = "";
           if( departmentFieldName!=null ) {
                  var departmentField = form.elements[departmentFieldName];
                  if( departmentField.value!='' ) {
                      appendString = '&departmentId='+departmentField.value;
                  }else{
                      appendString = '&departmentId=-1';
                  }
           }else{
               appendString = '&departmentID=-1';
           }
              openSelector( servletPath + 'employee?subCmd=query&formName=' + formName + '&fieldName=' + fieldName +'&hiddenFieldName='+hiddenFieldName +appendString +'&isSelectHuaweiEmployee=false', 'selectEmployee', 720, 420);
          }

          /*
          * 判斷是否數(shù)字
          */
          function isCharNum(obj) {

           var testString = obj.value;
           for(var i = 0; i < testString.length; i++){
            var character = testString.charCodeAt(i);    
            if(character > 57 || character < 48){
             return false;
            }
           }
           return true;
          }


          /**
           *
           * 判斷是不是有效的英文字母和數(shù)字
           */

          function checkIsLetterNumber(str) {
              //如果為空則通過檢驗
              if (str == "" || str.length == 0) {
                  return true;
              }

              //正則表達(dá)式
              var pattern = /[^a-zA-Z0-9\s]/g;
              if (pattern.test(str)) {
                  return false;
              }
              return true;
          }


          /*** 
           * 檢查配發(fā)新卡合法性。 五個級別的渠道分卡時都調(diào)用了這個方法。 linnngo 20060609
           */
           
          function checkCardLength(smallCardNoLength,greatCardNoLength){
           //開始卡號位數(shù)檢查
           if(smallCardNoLength == 0){
            alert("請輸入開始卡號!");
            return;
           }
           if(smallCardNoLength == 19 || smallCardNoLength == 10){
            //表示可以繼續(xù)
           } else {
            alert("輸入的卡號位數(shù)不正確,必須是19或10位!你輸入的開始卡號是" + smallCardNoLength + "位!");
            return;
           }
           
           //結(jié)束卡號位數(shù)檢查
           if(greatCardNoLength == 0){
            alert("請輸入結(jié)束卡號!");
            return;
           } 
           if(greatCardNoLength == 19 || greatCardNoLength == 10){
            //表示可以繼續(xù)
           }else{
            alert("輸入的卡號位數(shù)不正確,必須是19或10位!你輸入的結(jié)束卡號是" + greatCardNoLength + "位!");
            return;
           }
           
           if(smallCardNoLength != greatCardNoLength){
            alert("輸入的開始卡號和結(jié)束卡號長度不一樣!");
            return;
           }

           //開始卡號是否數(shù)字檢查
           if(isCharNum(document.allotCardForm.smallCardNo) && isCharNum(document.allotCardForm.greatCardNo)){
            if(confirm("確定提交?")){
             document.allotCardForm.submit();
            }
           }else {
            alert("輸入的卡號不正確,卡號只能是數(shù)字!");
           }
          }

          function tableMouseOver(Obj){
           Obj.style.backgroundColor='#f2f2f2';
          }
          function tableMouseOut(Obj){
           Obj.style.backgroundColor='';
          }
           
           //指定頁面區(qū)域內(nèi)容導(dǎo)入Excel
           function AllAreaExcel()
           {
            var oXL = new ActiveXObject("Excel.Application");
            var oWB = oXL.Workbooks.Add();
            var oSheet = oWB.ActiveSheet; 
            var sel=document.body.createTextRange();
            sel.moveToElementText(dataTableId);
            sel.select();
            sel.execCommand("Copy");
            oSheet.Paste();
            oXL.Visible = true;
           }
           //指定頁面區(qū)域“單元格”內(nèi)容導(dǎo)入Excel
           function CellAreaExcel()
           {
            var oXL = new ActiveXObject("Excel.Application");
            var oWB = oXL.Workbooks.Add();
            var oSheet = oWB.ActiveSheet;
            var Lenr = dataTableId.rows.length;
            for (i=0,o=0;i<Lenr;i++,o++)
            {
           var trid = dataTableId.rows(i).id;
           if(trid)
           {
            o--;
            continue;
           }
           var Lenc = dataTableId.rows(i).cells.length;
           for (j=0;j<Lenc;j++)
           {
            if(j==0)
            {
             var tmpText = dataTableId.rows(i).cells(j).innerText;
             var position = tmpText.indexOf("\n");
             if(position > -1)
             {
              tmpText = tmpText.substring(0,position);
             }
             oSheet.Cells(o+1,j+1).value = tmpText;
            }
            else
            {
              oSheet.Cells(o+1,j+1).value = dataTableId.rows(i).cells(j).innerText;
             }
           }
            }
            oXL.Visible = true;
           }

           //指定頁面區(qū)域內(nèi)容導(dǎo)入Word
           function AllAreaWord()
           {
            var oWD = new ActiveXObject("Word.Application");
            var oDC = oWD.Documents.Add("",0,1);
            var oRange =oDC.Range(0,1);
            var sel = document.body.createTextRange();
            sel.moveToElementText(dataTableId);
            sel.select();
            sel.execCommand("Copy");
            oRange.Paste();
            oWD.Application.Visible = true;
           }

          posted on 2007-07-16 17:55 龔椿深 閱讀(493) 評論(0)  編輯  收藏


          只有注冊用戶登錄后才能發(fā)表評論。


          網(wǎng)站導(dǎo)航:
           
          主站蜘蛛池模板: 大冶市| 梁平县| 广宗县| 旺苍县| 南川市| 武汉市| 板桥市| 霍城县| 扶沟县| 东辽县| 山东省| 博乐市| 玉门市| 义乌市| 桂平市| 囊谦县| 定襄县| 柳林县| 嘉定区| 乌海市| 哈尔滨市| 大悟县| 涿州市| 福泉市| 宣恩县| 宣化县| 福海县| 定南县| 社会| 贵州省| 防城港市| 长治县| 中江县| 阜城县| 蒙城县| 武宣县| 通渭县| 文安县| 内丘县| 尚义县| 浑源县|