问将Google Sheets单元格数据导入简单的HTML元素

EN

GET https://sheets.googleapis.com/v4/spreadsheets/spreadsheet_id/values/range 

function fetchValues(){
         console.log("-----checkIfEmpty-----");
         var xhr = new XMLHttpRequest();
         xhr.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/'+myspreadsheetId+'/values/'+"Sheet1!"+A+":"+Z);
         xhr.setRequestHeader('Authorization', 'Bearer ' + myAccessToken);

          var arrayBuffer;
          var myArr;

         xhr.onload = function (oEvent) {
             arrayBuffer = xhr.response; // Note: not oReq.responseText
             console.log("arrayBuffer "+ arrayBuffer);
             myArr = JSON.parse(arrayBuffer);

              for(var i = 0; i <= myArr.values.length; i++){
                      document.write(myArr.values[0][i] + "   ");
              }
         };
         xhr.send(null);
      }