Fadi

Fadi is a simple API to read from your public Google Spreadsheet files. You can:

• Get all rows from a file
• Get a specific row.
• Get a range of rows.

Installation

You can install it using npm

$ npm install --save fadi

Usage

If you've checked out the source code repository from GitHub, you may ensure everything works fine before proceeding forward by running the following:

$ node tests

To use Fadi, first you have to import the module and make an instance of Fadi.

var Fadi = require('fadi');
var fadi = new Fadi(api_key, spreadsheet_id);

To retrevive all rows:

fadi.fetch_alaa_rows((result) => console.log(result))

To get a row at a specific place:

fadi.fetch_specific_row(row_num, (result) => console.log(result))

To get a range of rows:

fadi.fetch_specific_range(range, (result) => console.log(result))

Also you can convert two dimensional array to JSON arrays, dealing with the first row as a header.

Fadi.arr2json(...)