Paul
/
ES-parse-XLSX-demo


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559
							<!DOCTYPE html>

<html>

  <head>

    <meta charset = "utf-8" >

    <title>parse xlsx test</title>

    <style>

       #outline {border:5px #666600 outset;padding:10px;}
       div {margin: 20px;}
        
    </style>


<script  src="js/check.xlsx.full.js" > </script>
<script  src="js/jquery.min.js" > </script>
<script  src="js/xlsx.full.min.js" > </script>

   
    <script > // type="module" type="text/javascript"

       $(function(){

         $ ('#my1').on('change',  function(event){//"input:file"
            document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                          if (SheetAmount(workbook) != true){
                            document.getElementById('message').innerHTML += SheetAmount(workbook);
                            return;
                          };
                          if (HaveSheets(workbook) != true){
                            document.getElementById('message').innerHTML += HaveSheets(workbook);
                            return;
                          };
                          if (HaveData3Para(workbook,"C","C16") != true){
                           document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C16");
                            return;
                          };
                          readWorkbook(workbook,"message","2022-06-07","张强","U1999","U1055P202，U1098P2022");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeJSONstring(workbook));
                      });
         });//id=my1


         $('#my2').on('change',function(event){//"input:file"
          document.getElementById('message').innerHTML = "";

for(var i=0;i<event.target.files.lenght;i++){

   $('#message').append(file.name+"<br>");

}

var files = event.target.files;
           if (files.length == 0) return;
           var f = files[0];
         //  document.getElementById('TextBox3').innerHTML += f.name+'\n';
           //k下面/    /g  是正则表达式
           if (!/\.xlsx$/g.test(f.name)) {
               alert('仅支持读取xlsx格式！');
               document.getElementById('message').innerHTML += "is not Xlsx type1!";
               return;
           };
           // var arr=[1,2,3];
           // alert(arr.length)
          // str2="";
          //alert(number2alphabet(30000));
          // str2=null;
           
           readWorkbookFromLocalFile(f, function (workbook) {

               if (HaveSingleSheetName(workbook,"SR") != true){
                 document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"SR");
                 return;
               };

               if (HaveData3Para(workbook,"SR","T1") != true){
                document.getElementById('message').innerHTML +=HaveData3Para(workbook,"SR","T1") ;
                 return;
               };

               checkIncomeFile(workbook,"message","202204","汤孝俊","U1066");
              // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {
                 
              //     document.getElementById('Button1').disabled =false;
                   //alert("pass!")
                  
             //  }

             alert(makeIncomeJSONstring(workbook));

           });


         });//id=my2


         $ ('#my3').on('change',  function(event){//"input:file"
            document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"GRZY") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"GRZY");
                               return;
                             };
                             if (HaveSingleSheetName(workbook,"JJZY") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"JJZY");
                               return;
                             };
                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C4") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C4");
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkBalanceFile(workbook,"message","2022-04-07","2022-04-07","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeBalanceJSONstring(workbook));
                      });
         });//id=my3


         $ ('#my4').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"KP") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"KP");
                               return;
                             };

                          if (HaveData3Para(workbook,"KP","W1") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"KP","W1")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkInvoiceFile(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeInvoiceJSONstring(workbook));
                      });
         });//id=my4

         $ ('#my5').on('change',  function(event){//"input:file"
            document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"KPCF") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"KPCF");
                               return;
                             };

                          if (HaveData3Para(workbook,"KPCF","H1") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"KPCF","H1")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkInvoiceSplitFile(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeInvoiceSplitJSONstring(workbook));
                      });
         });//id=my5


         $ ('#my6').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"CGZ") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"CGZ");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"CQT") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"CQT");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"CJT") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"CJT");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C5") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C5")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkSalaryFile(workbook,"message","202205","林玲");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       //alert(makeSalaryJSONstring(workbook));
                       console.log(makeSalaryJSONstring(workbook));
                      });
         });//id=my6


         $ ('#my7').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"DK") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"DK");
                               return;
                             };

                          if (HaveData3Para(workbook,"DK","I1") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"DK","I1")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkCashInFile(workbook,"message","2022-03-01","2022-04-10","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeCashInJSONstring(workbook));
                      });
         });//id=my7


         $ ('#my8').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"FK") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"FK");
                               return;
                             };

                          if (HaveData3Para(workbook,"FK","H1") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"FK","H1")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkCashOutFile(workbook,"message","2022-04-01","2022-04-31","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeCashOutJSONstring(workbook));
                      });
         });//id=my8


         $ ('#my9').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"B14C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B14C");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C2") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C2")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkB14CFile(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                        console.log(makeB14CJSONstring(workbook));
                       alert(makeB14CJSONstring(workbook));
                      });
         });//id=my9


         $ ('#my10').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"B15C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B15C");
                               return;
                             };

                            
                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C2") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C2")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkB15CFile(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                       alert(makeB15CJSONstring(workbook));
                      });
         });//id=my10


         $ ('#my11').on('change',  function(event){//"input:file"
           document.getElementById('message').innerHTML = "";
           for(var i=0;i<event.target.files.lenght;i++){
              $('#message').append(file.name+"<br>");
           }
           var files = event.target.files;
                      if (files.length == 0) return;
                      var f = files[0];
                      if (!/\.xlsx$/g.test(f.name)) {
                          alert('仅支持读取xlsx格式！');
                          document.getElementById('message').innerHTML += "is not Xlsx type1!";
                          return;
                      };            
                        readWorkbookFromLocalFile(f, function (workbook) {
                             if (HaveSingleSheetName(workbook,"B16") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B16");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"B17") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B17");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"B18") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B18");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"B19") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"B19");
                               return;
                             };

                             if (HaveSingleSheetName(workbook,"C") != true){
                               document.getElementById('message').innerHTML += HaveSingleSheetName(workbook,"C");
                               return;
                             };

                          if (HaveData3Para(workbook,"C","C6") != true){
                            document.getElementById('message').innerHTML += HaveData3Para(workbook,"C","C6")
                            return;
                          };
                          //checkBalanceFile(workbook,logID,strStartDate,strEndDate,userID)
                          checkB16toB19File(workbook,"message","汤孝俊");
                         // if (document.getElementById('TextBox3').innerHTML == ""&&document.getElementById('FileUpload1').value != "") {                           
                         //     document.getElementById('Button1').disabled =false;
                              //alert("pass!")                             
                        //  }
                        console.log(makeB16toB19JSONstring(workbook));
                       alert(makeB16toB19JSONstring(workbook));
                      });
         });//id=my11


       })

    </script>

  </head>

  <body>

     <div id="outline">
        <div>
           <a>选择 日报 文件</a>
           <input id="my1" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/> 
        </div>
 
        <div>
          <a>选择 收入 文件</a>
           <input id="my2" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/> 
        </div>
   
         <div>
          <a>选择 支援 文件</a>
             <input id="my3" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>            
         </div>     
    
    
         <div >
             <a>选择 开票 文件</a>
             <input id="my4" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 
    
         <div >
          <a>选择 开票拆分 文件</a>
             <input id="my5" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>            
         </div> 
    
         <div >
          <a>选择 工资 文件</a>
             <input id="my6" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 到款 文件</a>
             <input id="my7" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 付款 文件</a>
             <input id="my8" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 B14C 文件</a>
             <input id="my9" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 B15C 文件</a>
             <input id="my10" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

         <div >
          <a>选择 B16-B19 文件</a>
             <input id="my11" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple/>             
         </div> 

           <div id="message"></div>
     </div>


  </body>

</html>