SheetJS Demo

by skibulk

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.16.9/xlsx.full.min.js"></script>

JavaScript

console.clear();

var url = "https://docs.google.com/spreadsheets/d/e/2PACX-1vTvCqw-yj_yMax4XrlyS-eqNzvgQ4dF8goDVcGI8Td5Y9T0AjLLEqsgHpzhCq0szk7IpW63SeRc-w6S/pub?output=xlsx";

/* set up async GET request */
var req = new XMLHttpRequest();
req.open("GET", url, true);
req.responseType = "arraybuffer";

req.onload = function(e) {
  var data = new Uint8Array(req.response);
  var workbook = XLSX.read(data, {type:"array"});
  console.log(workbook);
  
  for(var i = 0; i < workbook.SheetNames.length; i++){
  	var sheet = workbook.Sheets[workbook.SheetNames[i]];
    var csv = XLSX.utils.sheet_to_csv(sheet, {blankrows: false});
    console.log(csv);
  }

	/*
  var first_sheet_name = workbook.SheetNames[0];
  var address_of_cell = 'A1';

  var worksheet = workbook.Sheets[first_sheet_name];

  var desired_cell = worksheet[address_of_cell];

  var desired_value = (desired_cell ? desired_cell.v : undefined);
  */
}

req.send();