Generate Tables From Public Google Spreadsheets – gshtmltable.js

Preview:

Description:

gshtmltable.js is a JavaScript library for generating an HTML table from a public Google spreadsheet.

How to use it:

1. To get started, include the gshtmltable.js library on the page.

<script src="./lib/gshtmltable.js"></script>

2. Draw an HTML table (desktop version) from a public Google spreadsheet you provide.

<div class="desktop_table">

drawTables({
  url: "https://script.google.com/macros/s/AKfycbx_gztrrwzJWjjatG8Uk8col_g3hr9VuhSzqgv8ehkWEXAMMxoXT-sNBamBKzY2bWkPWw/exec?callback=?",
  desktop_container: ".desktop_table",
  responsive_container: null
});

3. Draw a mobile-friendly table from a public Google spreadsheet you provide.

<div class="responsive_table"></div>

drawTables({
  url: "https://script.google.com/macros/s/AKfycbx_gztrrwzJWjjatG8Uk8col_g3hr9VuhSzqgv8ehkWEXAMMxoXT-sNBamBKzY2bWkPWw/exec?callback=?",
  desktop_container: null,
  responsive_container: ".responsive_table"     
});

4. Apply additional CSS classes to the table.

drawTables({
  desktop_css : "",
  responsive_css : "" 
});