Getting started with web programming 2.2 reading parameters in Excel and XML

(1) Read Excel Parameters in

Need to import external files , from github find xlsx.core.min.js, Download and import

And then in HTML Set upload control in

<input type="file" id="excel-file">

Then listen for control change events

$('#excel-file').change(function(e) {
    var files = e.target.files;
    var fileReader = new FileReader();
    fileReader.onload = function(ev) {
      try {
        var data = ev.target.result,
          workbook = XLSX.read(data, {
            type: 'binary'
          }), //  Read in binary stream to get the whole copy excel Table objects 
          persons = []; //  Store the acquired data 
      } catch (e) {
        console.log(' load EXCEL  File error !');
        return;
      }

      //  Table range of the table , It can be used to judge whether the header quantity is correct 
      var fromTo = '';
      //  Traverse each table and read 
      for (var sheet in workbook.Sheets) {
        if (workbook.Sheets.hasOwnProperty(sheet)) {
          fromTo = workbook.Sheets[sheet]['!ref'];
          console.log(fromTo);
          persons = persons.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet]));
          // break; //  If you only take the first table , Just uncomment the line 
        }
      }
      
    };

    //  Open the file in binary mode 
    fileReader.readAsBinaryString(files[0]);

  });

resulting persons Is the corresponding parameter set .

(2) Read XML Parameters in

Use ajax Method to access xml file , But in the visit xml Need to get the document before the document url Address , So first read the address , Then you can access the corresponding address XML file .

 $('#fileField').change(function(e) {
    var url = null;
    var fileObj = document.getElementById("fileField").files[0];
    if (window.createObjcectURL != undefined) {
      url = window.createOjcectURL(fileObj);
    } else if (window.URL != undefined) {
      url = window.URL.createObjectURL(fileObj);
    } else if (window.webkitURL != undefined) {
      url = window.webkitURL.createObjectURL(fileObj);
    }    
    $.ajax({
      url: url,
      dataType: 'xml',
      type: 'GET',
      async:false,
      error: function(xml)
      {
        alert(" load XML  File error !");
      },
      success: function(xml)
      {
        $(xml).find("e").each(function(i)
        {          
          var orderid = $(this).children(" Order ID").text();        
          var clothid = $(this).children(" Order product ID").text();
          var clothamount = $(this).children(" Order quantity ").text();
          //var buckle = $(this).children("buckle").text();
          console.log(orderid+"  "+clothid+"  "+clothamount);

        });       
        fillformbyxml(xml);
      }
    });
  });