Class: GSheets::V3::WorkSheet

Inherits:
Object
  • Object
show all
Defined in:
lib/g_sheets/v3/work_sheet.rb

Instance Method Summary collapse

Constructor Details

#initialize(session:, grid_id: " default", id:) ⇒ WorkSheet

Returns a new instance of WorkSheet.



4
5
6
7
8
 
# File 'lib/g_sheets/v3/work_sheet.rb', line 4

def initialize(session:, grid_id: " default", id:)
  @grid_id = grid_id
  @session = session
  @id = id
end

Instance Method Details

#headers ⇒ Object 



10
11
12
 
# File 'lib/g_sheets/v3/work_sheet.rb', line 10

def headers
  cells_first_row["feed"]["entry"].map {|e| e["content"]["$t"]}
end

#rows ⇒ Object 



14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
 
# File 'lib/g_sheets/v3/work_sheet.rb', line 14

def rows
  data_list = worksheet_as_list["feed"]["entry"]
  list = data_list.map {|entry|
    [
      "title: #{entry['title']['$t']}",
      entry["content"]["$t"]
    ].join(", ")
  }

  result = []
  list.each do |l|
    row = {}
    l.split(",").each do |elem|
      e = elem.split(":")
      row[e.first.strip.freeze] = e.last.strip.freeze
    end
    result << row
  end
  result.map(&:values)
end