JSFiddle - React, Tailwind, and code Playground

by yairamon

HTML

<script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script>
<button type="button" onclick="loadData()">Load Spreadsheet Data</button>
<div id="display"></div>

asdasasdasd

JavaScript

docid = "1HTrFAr7g1dBe8sBcakISa6g0_PRP3MVEaYpGMacdk0k";

// country city total KP...
docid = "18zuQ2uYEd3pB4qzK-SbDpLvpb4AH775Hq2xnckJw5VQ";
gid = "1629564902";


function loadData() {
          var url = 
          "https://docs.google.com/spreadsheets/d/" + docid + "/export?id=Total%20KP&format=xlsx&gid=" + gid;
          
                    var url = 
          "https://docs.google.com/spreadsheets/d/" + docid + "/export?id=Total%20KP&format=xlsx"; // all sheets?
          
          

alert (url);


var oReq = new XMLHttpRequest();
oReq.open("GET", url, true);
oReq.responseType = "arraybuffer";

oReq.onload = function(e) {

  var arraybuffer = oReq.response;

  /* convert data to binary string */
  var data = new Uint8Array(arraybuffer);
  var arr = new Array();
  for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);
  var bstr = arr.join("");

  /* Call XLSX */
  var workbook = XLSX.read(bstr, {type:"binary"});

  /* DO SOMETHING WITH workbook HERE */
  
  debugger;
  
  var first_sheet_name = workbook.SheetNames[0];
  
  
  /* Get worksheet */
  var worksheet = workbook.Sheets[first_sheet_name];
  console.log(XLSX.utils.sheet_to_json(worksheet,{raw:true}));
  
 }
 
 oReq.send();
 
 }
 

/*
          xmlhttp = new XMLHttpRequest();
          xmlhttp.onreadystatechange = function () {
              if (xmlhttp.readyState == 4) {
                  document.getElementById("display").innerHTML = xmlhttp.responseText;
        //          alert(xmlhttp.responseText);
              }
         //     else
       //       	alert( xmlhttp.readyState);
          };
          xmlhttp.open("GET", url, true);
          xmlhttp.send(null);
  
      }
      */