Sheetrock

Sheetrock can parse various fields from a Web spreadsheet if given a Google Spreadsheet URL. Once read, the data will be retrieved and embedded in a local page.

Based on a display template and various instructions, Sheetrock can manipulate spreadsheet data and use all of it or just small parts of the spreadsheet inside a page.

Besides this, Sheetrock can also lazy-load the spreadsheet data and query for various spreadsheet meta details as well.

Documentation is included with the package's README file.

Features:

• Works solely in the browser
• All what's needed is a Google Spreadsheet URL
• Use an SQL-like Google Visualization query language
• Filters, sorting, grouping, and more
• Outputs useful debug information to the browser console
• Templated output
• Caching

What is new in this release:

• No longer depends on jQuery
• Use in browser or on server (with or without virtual DOM)
• Module renamed from jquery-sheetrock to sheetrock
• Now expects a single header row in row 1
• Passes consistent row numbers to the row template, starting at 1

What is new in version 0.2.1:

• Handle null cell values.

What is new in version 0.1.10:

• Update key extraction to work with the new version of Google Spreadsheets.
• Added note about (hopefully temporary) incompatibility with the new version of Google Spreadsheets.

What is new in version 0.1.5:

• Added option to enable row group tags (thead and tbody).

What is new in version 0.1.0:

• Added jQuery plugin manifest.

Requirements:

• JavaScript enabled on client side