@colorfulcompany/gas-spreadsheet-onetime-reader v0.5.6

SpreadsheetOnetimeReader

Simple Google Spreadsheet Reader

feature

• search()
• toObject()

SpreadsheetApp returns Array of Array structure "[ [], [] ]", but it's hard to handle them. SpreadsheetOnetimeReader provides convinent toObject() method.

Usage

let sheet = new SpreadsheetOnetimeReader(
  SpreadsheetApp,
  <bookId>,
  <sheetName>,
  opts = {
    skipHeaders: <num>
  })

sheet.search('and', [ ['~', 'id', /^201706[0-9]+/], ['==', 'name', 'Aiu'] ])
sheet.toObject()

result

[
  {
    id:    2017062101,
    point: 79,
    name:  "Aiu"
  },
  {
    id:    2017062812,
    point: 64,
    name:  "Aiu"
  },
  ...
]

and narrowing with pickFields option

sheet.opts({pickFields: ['id', 'point']})
sheet.toObject()

result

[
  {
    id:    2017062101,
    point: 79
  },
  {
    id:    2017062812,
    point: 64
  },
  ...
]