google-spreatsheet-manager

0.0.1 • Public • Published

google-spreatsheet-manager

this is a wrapper of google-spreatsheet

basic usage

let sheetID = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
let cred = path.join(__dirname, './cred.json')

export async function example(){
  let sheetManager = new SpreadSheetManager(sheetID,cred)
  let authResult = await sheetManager.auth()
  let sheets = await sheetManager.getSheets()
  let mainSheet = sheets.worksheets[0]

  let parserList = await sheetManager.cellsParser(mainSheet,parser)

  console.log(parserList)
}


function parser(cells){
  return cells.filter(function(cell, index) {
    return (cell.col == 1)
  }).map(function(cell, index) {
    return cell.value.toLowerCase()
  })
}

API

create manager

new SpreadSheetManager((String) sheet_id, (json)[auth], [options])

Create a new google spreadsheet object.

  • sheet_id -- the ID of the spreadsheet (from its URL)
  • auth - (optional) an existing auth token
  • options - (optional)
  • visibility - defaults to public if anonymous
  • projection - defaults to values if anonymous

auth

SpreadSheetManager.auth() -> void

getSheets

SpreadSheetManager.getSheets() -> Array

rowsParse

SpreadSheetManager.rowsParse((Object) sheet, (function) parser) -> Array

cellsParse

SpreadSheetManager.cellsParse((Object) sheet, (function) parser) -> Array

Dependencies (2)

Dev Dependencies (0)

    Package Sidebar

    Install

    npm i google-spreatsheet-manager

    Weekly Downloads

    0

    Version

    0.0.1

    License

    ISC

    Last publish

    Collaborators

    • gollowars