<!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!") // } 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>