(Click “Share” and set visibility to “Anyone with the link” or “Public on the web.”) As an example, let’s use this spreadsheet, which contains 1986 National League batting statistics. Sheetrock’s only required option is the URL of a public Google Spreadsheet. View source! Extend and adapt them! Specify a spreadsheet. Any formatting you’ve applied to your data-including hyperlinks-probably won’t show up. Sheetrock expects a single header row of column labels in the first row of the Sheet. In order for others to access the data in your Sheet with Sheetrock, the Sheet must be public. Sheetrock is designed to work with any Google Sheet, but makes some assumptions about the format and availability. Sheetrock can also be used with Node.js see the documentation for details. The examples on this page use jQuery, but Sheetrock doesn’t require it. Grab the latest version of Sheetrock for your project. Please see the GitHub repository for detailed documentation of the available options or to contribute, explore, or raise an issue. Customize to your heart’s content with your own callbacks.Easily mix in your favorite templating system ( Handlebars, Underscore, etc.).Lazy-load large data sets (infinite scroll with ease).Query sheets using the SQL-like Google Visualization query language-grouping, sorting, filters, pivots, and more. It has no dependencies-but if jQuery is available, it will register as a plugin.īasic retrieval is a snap but you can also: Sheetrock can be used in the browser or on the server (Node.js). All you need is the URL of a public Google Sheet. In other words, use a Google spreadsheet as your database! Load entire worksheets or leverage SQL-like queries to sort, group, and filter data. Sheetrock is a JavaScript library for querying, retrieving, and displaying data from Google Sheets.
0 Comments
Leave a Reply. |