google-spreadsheets-parser

Simple Google Spreadsheets parser for JavaScript

Installation

NPM

npm install google-spreadsheets-parser

Manual Download

Download from here

Introduction

1. Create new Google Spreadsheet

   

2. Publish spreadsheet

   

   You can show following tables from published url

   

3. Setting

   With Browser, import googleSpreadsheetsParser.js in header

   <script type="text/javascript" src="https://github.com/tanakaworld/google-spreadsheets-parser/raw/master/path/to/googleSpreadsheetsParser.js"></script>

   Node.js

   var GoogleSpreadsheetsParser = require('google-spreadsheets-parser')

4. Get data

   var gss = new GoogleSpreadsheetsParser(publishedUrl, {sheetTitle: 'Sample', hasTitle: true});
   
   console.log(gss.titles);          // ["ID", "Name", "Age"]
   console.log(gss.contents);        // [Array[3], Array[3], Array[3], Array[3], Array[3]]
   console.log(gss.contents[2][1]);  // Doug

Features

• .titles : Table titles array in the frst row.
• .contents : Table data 2d array in the second row later.
• .toJson() : JSON data of contents.

Demo

• With Browser
• Parameterized test