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.
You can install it using npm
$ npm install --save fadiIf you've checked out the source code repository from GitHub, you may ensure everything works fine before proceeding forward by running the following:
$ node testsTo 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(...)