Module: ActiveRecordToGoogleSpreadsheet::Converter::ActiveRecordBaseConverter

Extended by:
Utils
Includes:
Utils
Included in:
ActiveRecord::Base
Defined in:
lib/activerecord_to_google_spreadsheet/converter.rb

Instance Method Summary collapse

Methods included from Utils

get_worksheet_by_name

Instance Method Details

#from_google_spreadsheet ⇒ Object 



26
27
 
# File 'lib/activerecord_to_google_spreadsheet/converter.rb', line 26

def from_google_spreadsheet
end

#to_google_spreadsheet(session, spreadsheet_key, name: self.model_name.name, worksheet_title: false, row_offset: 1) ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
# File 'lib/activerecord_to_google_spreadsheet/converter.rb', line 7

def to_google_spreadsheet(session, spreadsheet_key, name: self.model_name.name, worksheet_title: false, row_offset: 1)

  clazz = self.model_name.name.capitalize.singularize.camelize.to_s.constantize
  spreadsheet = session.spreadsheet_by_key(spreadsheet_key)
  ws = get_worksheet_by_name(spreadsheet, name)

  clazz.column_names.each_with_index.each do |name, column_index|
    if worksheet_title
      ws[row_offset, column_index+1] = name
      ws[row_offset + 1, column_index + 1] = self[name]
    else
      ws[row_offset, column_index + 1] = self[name]
    end

  end
  ws.save
  ws.reload
end