node-spreadsheets

An adaptor for Google Spreadsheets API.

Install

npm install spreadsheets

Usage

require spreadsheets

varauthenticate=require("spreadsheets");

authenticate with Google Client Login & get your spreadsheets list

authenticate({Email: youremailforgoogleaccount,Passwd: password},function(err,spreadsheets){if(err)// handle errorspreadsheets.list(function(err,list){if(err)// handle error
........});});

choose a spreadsheet and a worksheet

varspreadsheet=list[spreadsheetkey];spreadsheet.worksheet(function(err,sheets){if(err))// handle errorvarworksheet=sheets[*worksheetkey*];});

get cells and change value

worksheet.cell({"min-row": 2,"min-col": 4,"max-col": 4},function(err,cells){if(err)// handle errorvarcell=cells[cellkey];// for example R3C4cell.changeValue("any value",function(err){if(err)// handle error
......
});});

change styles

worksheet.style({scol: 2,ecol: 3,srow: 2,erow: 4},function(err,style){if(err)// handle errorstyle.color("#ff0000",function(){});style.bgColor("#ff0000",function(){});style.fontsize("10pt",function(){});style.align("right",function(){});});

Dependency

• node-jQuery