Class: GoogleSpreadsheet::Worksheet
- Inherits:
-
Object
- Object
- GoogleSpreadsheet::Worksheet
- Defined in:
- lib/to_google_spreadsheet.rb
Instance Method Summary collapse
Instance Method Details
#populate(rows) ⇒ Object
29 30 31 32 33 34 35 36 37 38 |
# File 'lib/to_google_spreadsheet.rb', line 29 def populate(rows) # TODO: Stop looping, put directly into the Google Spreadsheet hash # provided by the Gem # https://github.com/gimite/google-spreadsheet-ruby/blob/master/lib/google_spreadsheet.rb#L693-700 rows.each_with_index do |row, row_nr| get_hash_from_row(row).sort_by { |k,v| k.to_s }.each_with_index do |val, col_nr| self[row_nr + 2, col_nr + 1] = val.last end end end |
#set_header_columns(row) ⇒ Object
22 23 24 25 26 27 |
# File 'lib/to_google_spreadsheet.rb', line 22 def set_header_columns(row) # #sort_by to sort by symbols get_hash_from_row(row).keys.sort_by { |k,v| k.to_s }.each_with_index do |key, col_nr| self[1, col_nr + 1] = humanize(key) end end |